Lead Database Administrator

Job Responsibilities

• Deploy, support, and upgrade SQL Server instances across our AWS environment (EC2-hosted and RDS) in partnership with our Systems Engineering team, with growing responsibility for cloud-native AWS data services (e.g., Aurora, DynamoDB, Redshift, and S3 Tables (Iceberg)-based data lakes) as we modernize our data platform.
• Coordinated with System Engineers to remove blockers, troubleshoot complex SQL Server issues, and ensure successful deployments.
• Monitor the overall health of our database infrastructure, supported by our Network Operations Center team.
• Identify opportunities for improving database performance, increasing system reliability, optimizing resource utilization, and reducing costs — including evaluating cloud-native AWS alternatives — and collaborate with systems engineering and application development to assess and deploy solutions.
• Collaborate with development teams and support application design and deployment, optimization, troubleshooting, and problem resolution.
• Develop SQL commands, stored procedures, and PowerShell scripts to automate administrative processes, facilitate monitoring, and assist in troubleshooting and problem solving.
• Serve as a go-to resource on SQL Server— including system capabilities, internals, tools, deployment, and maintenance — across both self-managed and AWS-managed (RDS/Aurora) environments, alongside our Lead DBA
• Support the organization's ongoing transition toward AWS-native database services, in partnership with our Lead DBA, evaluating fit-for-purpose options (e.g., RDS, Aurora, DynamoDB, Redshift, S3 Tables) for new and migrating workloads.
• Maintain documentation on configurations and processes and share database knowledge with systems engineers and developers.
• Support on call schedule for evening and weekends shared with Lead DBA.

Job Requirements

• 10+ years of Microsoft SQL Server database administration, including 7+ years managing large, mission-critical production systems.
• 5+ years of hands-on experience administering cloud-native AWS database services (e.g., RDS, Aurora, DynamoDB, Redshift).
• Hands-on experience with AWS database services, including SQL Server hosted on EC2 and RDS, with working knowledge of cloud-native offerings such as Aurora and RDS Multi-AZ/read replica configurations, plus working familiarity with adjacent AWS data services such as DynamoDB, Redshift, and S3-based data lakes (e.g., S3 Tables).
• Demonstrated ability to analyze and research performance-related issues, with experience using tools like Extended Events, dynamic management views (DMVs), or trace flags to diagnose and resolve deadlocks and long-running queries.
• Experience managing very large databases and knowledge of partitioned data storage, data replication, and bulk movement of large data sets.
• Thorough understanding of best practices for database maintenance, including schema management, storage management, backup management, and disaster recovery.
• Experience deploying, supporting, and optimizing SQL Server, SQL Replication, and SQL Agent.
• Experience assessing and tuning SQL Server performance while considering hardware, storage, and network performance.
• Advanced knowledge of SQL programming, including the ability to write and optimize queries, stored procedures, triggers, and user-defined functions to support database administration.
• Solid understanding of database theory and database design and their practical application to real-world situations.
• Familiarity with database security and database auditing techniques, including AWS-native controls such as IAM database authentication and encryption at rest/in transit (KMS).
• Familiarity with versions back to SQL Server 2019, with working knowledge of current-generation feature sets (e.g., SQL Server 2025).
• Bachelor's degree in a relevant discipline or equivalent practical experience; Master's degree preferred.

Preferred Qualifications

• Hands-on experience with AWS cloud-native database and analytics services such as Aurora (MySQL/PostgreSQL-compatible), DynamoDB, Redshift, or S3 Tables (Apache Iceberg tables on S3).
• Familiarity with Infrastructure-as-Code (e.g., CloudFormation or CDK) for provisioning and managing cloud database resources.
• Knowledge of Ansible is a plus.
• Exposure to AWS cost optimization practices for database workloads (storage tiering, right-sizing).
• Exposure to AI-assisted database monitoring, anomaly detection, or query-tuning tooling.
• Familiarity with Foglight is a plus.
• Familiarity with Jira and Confluence.
• Understanding of data warehouse and data lake concepts and technologies, particularly within AWS (e.g., Redshift, S3-based data lakes, AWS Glue, Lake Formation).
• Understanding of OLAP concepts and technologies.
• Knowledge of data migration methods.
• Relevant certifications
• To apply for this opportunity, simply click on the “Apply” button and submit a cover letter and resume.

An Equal Opportunity Employer