About the Role
The Senior Database Administrator will support multiple product teams across Dealer Solutions and play a key role in working on managed and optimized enterprise database systems cloud migration initiatives. This role will be responsible for managing, optimizing, and re-architecting the current on-premises database environment. As a key technical enabler of the organization’s cloud strategy, the Senior Database Administrator will first stabilize and remediate the existing database infrastructure, then design and execute a safe, phased migration to AWS. This position bridges the gap between the current aging, monolithic on-premises database environment running on on-prem infrastructure and a future-state scalable, cost-efficient, cloud-native database platform.
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.
- Monitor 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.
- 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.
- Troubleshoot and resolve complex database issues related to performance, connectivity, storage, security, and application integration.
- 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. The right candidate could also have a different combination, such as a master’s degree and 2 years’ experience; a Ph.D. and up to 1 year of experience; or 8 years’ experience in a related field.
- Requires 2+ years of AWS database migration experience.
- Requires 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).
Skills
- Microsoft SQL Server
- AWS database migration
- SQL Server replication
- SQL Server upgrades, migrations, and patching
- Windows Server administration
- SQL Server clustering
- High-availability solutions
- PowerShell
- T-SQL
- CI/CD pipelines
- Infrastructure as Code
- Atlas MongoDB
- PostgreSQL
Location
- USA
Work Type
- Hybrid
- Remote
Experience Level
- Senior
- Individual Contributor
Education Level
- Bachelor's degree
- Master's degree
- Ph.D.
Salary/Compensations
- $121,800.00 - $203,000.00
Benefits
- Flexible vacation with pay
- Seven paid holidays
- Up to 160 hours of paid wellness annually
- Bereavement leave
- Time off to vote
- Jury duty leave
- Volunteer time off
- Military leave
- Parental leave
- Health care insurance (medical, dental, vision)
- Retirement planning (401(k))
- Paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO)
About the Company
- Cox Automotive transforms the way the world buys, owns, sells – or simply uses – cars through groundbreaking technology and a commitment to stellar experiences for drivers and dealers alike.
- Cox Automotive employees get to work on iconic consumer brands like Autotrader and Kelley Blue Book and industry-leading dealer-facing companies like vAuto and Manheim, all while enjoying the people-centered atmosphere that is central to our life at Cox.
Equal Opportunity
- Cox is an Equal Employment Opportunity employer – All qualified applicants/employees will receive consideration for employment without regard to that individual’s age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law.
- Cox provides reasonable accommodations when requested by a qualified applicant or employee with disability, unless such accommodations would cause an undue hardship.
- EOE, including disability/vets
