Senior Database Administrator — Atlanta, GA
Зарплата не указана
ОткликнутьсяSenior Database Administrator (SQL Server & PostgreSQL) - Onsite in Atlanta GA
We're looking for a Senior Database Administrator to oversee database operations with our client in telecommunications. The Senior DBA is a key member of the IT Systems team and is responsible for architecting, deploying, and supporting critical database infrastructure across the enterprise. The ideal person is a strong, senior level DBA with expertise in both MS SQL Server and PostgreSQL. This reports to the Senior Technology Leader and requires someone to step into a leadership capacity to guide junior team members, drive architectural improvements, and own critical database initiatives from start to finish.
Responsibilities
• Architect, deploy, and support highly available database solutions across MS SQL Server and PostgreSQL environments.
• On SQL Server: design and maintain replication topologies, index/statistics maintenance, and Query store-driven performance tuning.
• On PostgreSQL: design and maintain streaming and logical replication, connection pooling, partitioning, autovacuum/bloat management, and query plan tuning.
• Administer all databases across the full development-to-production lifecycle.
• Develop stored procedures and functions in T-SQL and PL/pgSQL.
• Optimize databases and applications for performance, reliability, and security.
• Define and enforce database standards and best practices across the organization.
• Maintain data backup, recovery, and business continuity procedures across both platforms.
• Coordinate and support application testing during database maintenance and upgrades.
• Collaborate with developers and testers during release cycles.
• Identify and resolve performance issues including long-running queries, missing indexes, and schema inefficiencies.
• Forecast storage requirements and perform ongoing capacity planning.
• Monitor and troubleshoot database issues across Linux and Windows platforms.
Qualifications
• Bachelor's degree with 5-10+ years as a Database Administrator in an enterprise environment.
• Substantial hands-on senior-level experience in both SQL Server and PostgreSQL.
• SQL Server expertise: replication, index and statistics maintenance, Query Store, performance tuning, etc.
• Strong PostgreSQL expertise: streaming and logical replication, partitioning, autovacuum/bloat management, backup/recovery, and query plan analysis.
• Strong proficiency in T-SQL and PL/pgSQL.
• Proven ability to lead projects independently and provide technical guidance to junior team members; proactive in nature with the ability to drive projects from start to finish.
• Good Linux and shell scripting experience.
• Experience with MySQL and other database platforms such as Informix.
• Familiarity with BI reporting tools and data warehousing.
• Excellent written and verbal communication skills with strong attention to detail.