Sr Database Administrator

About the role

The Senior Database Administrator supports multiple product teams across Dealer Solutions and works on cloud migration initiatives. Key responsibilities include managing, optimizing, and re-architecting the current on-premises database environment, stabilizing and remediating the existing infrastructure, designing and executing a safe, phased migration to AWS, and supporting the organization's cloud strategy.

Responsibilities

• Manage and support enterprise-scale Microsoft SQL Server environments, including databases in the 10+ terabyte range across development, QA, and production.
• Lead and participate in SQL Server upgrades, version migrations, patching, and maintenance efforts with minimal disruption to business-critical applications.
• Design, implement, and maintain high-availability and disaster recovery solutions, particularly Always On Availability Groups.
• Maintain and optimize database performance, availability, and reliability, including tuning queries, indexes, and stored procedures.
• Perform and validate database backup, recovery, and maintenance activities to ensure data integrity and operational continuity.
• Advanced SQL Server administration options (trace flags, DB options, and query hints).
• Develop automation using PowerShell, T-SQL, CI/CD pipelines, and Infrastructure as Code.
• Support enterprise monitoring, alerting, and observability solutions tailored to SQL Server health, availability, and performance metrics.
• Establish operational standards, runbooks, and incident response procedures.
• Contribute to the planning and execution of database migration and cloud transformation initiatives, with a focus on migrating to AWS (RDS for SQL Server, EC2-hosted SQL Server).
• Implement database security best practices, including user access management, encryption, auditing, and compliance controls.
• Create and maintain automation scripts, monitoring solutions, operational procedures, and technical documentation.
• Collaborate with software engineering, DevOps, infrastructure, product, and security teams to support business-critical applications and modernization efforts.

Requirements

• Bachelor's degree in a related discipline and 4 years' experience in a related field.
• Minimum 2+ years of AWS database migration experience.
• Minimum 5+ years of experience with Microsoft SQL Server database platform in the 10+ terabyte range.
• Strong hands-on experience with SQL Server replication, including troubleshooting latency and consistency issues.
• Demonstrated experience with SQL Server upgrades, migrations, and patching across multiple environments.
• Solid understanding of Windows Server administration as it relates to SQL Server hosting and configuration.
• Proven experience with SQL Server clustering and high-availability solutions (e.g., failover clustering).

Qualifications

• Nice to have in Atlas MongoDB and PostgreSQL.

Skills

• Advanced SQL Server administration options (trace flags, DB options, and query hints).
• Develop automation using PowerShell, T-SQL, CI/CD pipelines, and Infrastructure as Code.
• Support enterprise monitoring, alerting, and observability solutions tailored to SQL Server health, availability, and performance metrics.
• Establish operational standards, runbooks, and incident response procedures.
• Contribute to the planning and execution of database migration and cloud transformation initiatives, with a focus on migrating to AWS (RDS for SQL Server, EC2-hosted SQL Server).
• Implement database security best practices, including user access management, encryption, auditing, and compliance controls.
• Create and maintain automation scripts, monitoring solutions, operational procedures, and technical documentation.
• Collaborate with software engineering, DevOps, infrastructure, product, and security teams to support business-critical applications and modernization efforts.

Benefits

• Flexibility to take as much vacation with pay as deemed consistent with duties, the company's needs, and obligations.
• Seven paid holidays throughout the calendar year.
• Up to 160 hours of paid wellness annually for personal or family member wellness.
• Additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, and parental leave.

Pay

USD 121,800.00 - 203,000.00 per year.

Schedule

Not specified.