Sr Database Administrator

CAI Cox Automotive Corp Svcs., LLC; Village of New Hyde Park (NY); Hybrid; USD 121,800 - 203,000; Full time

Benefits offered by this job

Flexible vacation

Paid wellness hours

Health care insurance

401(k) retirement planning

Job summary

CAI Cox Automotive Corp Svcs., LLC is seeking a Senior Database Administrator to manage enterprise-scale SQL Server environments. This role involves leading cloud migrations to AWS and ensures high-availability and disaster recovery solutions are maintained.

Candidates should have a Bachelor’s degree and several years of experience with SQL Server and AWS. The position offers flexible working arrangements, comprehensive benefits, and supports career growth in a collaborative environment.

Qualifications

• Bachelor’s degree in a related discipline and 4 years’ experience.
• 2+ years of AWS database migration experience.
• 5+ years of experience with Microsoft SQL Server databases.

Responsibilities

• Manage enterprise-scale Microsoft SQL Server environments.
• Design, implement, and maintain high-availability and disaster recovery solutions.
• Diagnose and resolve complex database issues.

Skills

AWS database migration

Microsoft SQL Server

SQL Server replication

PowerShell

Education

Bachelor’s degree in a related discipline

Tools

Atlas MongoDB

PostgreSQL

Job description

Job Overview

Company Cox Automotive - USAJob Family: Group Information TechnologyJob Profile: Database Sr AdministratorManagement Level: Individual ContributorWork Style: Flexible, Hybrid (remote part of the week)Compensation: Base salary range of $121,800.00 – $203,000.00. Additional incentive program may be offered.

Job Description

The Senior Database Administrator will support multiple product teams across Dealer Solutions and play a key role in 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 and designing a safe, phased migration to AWS, bridging the gap between the aging monolithic on‑premises infrastructure and a future‑state scalable, cost‑efficient, cloud‑native 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 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.
• Utilize advanced SQL Server administration options such as trace flags, database 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.
• Provide expertise in SQL Server replication across multiple databases; troubleshoot replication latency, distribution bottlenecks, and data consistency issues.
• Diagnose and resolve complex database issues related to performance, connectivity, storage, security, and application integration.
• Collaborate with software engineering, DevOps, infrastructure, product, and security teams to support business‑critical applications and modernization efforts.
• Contribute to the planning and execution of database migration and cloud transformation initiatives, focusing 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.

Qualifications

• Bachelor’s degree in a related discipline and 4 years’ experience in a related field. Alternative combinations may be accepted (e.g., master’s degree and 2 years, Ph.D. and up to 1 year, or 8 years of experience).
• 2+ years of AWS database migration experience.
• 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).

Preferred Qualifications

• Nice to have experience in Atlas MongoDB and PostgreSQL.

Drug Testing

To be employed in this role, a pre‑employment drug test is required. Cox Automotive does not administer a pre‑employment drug test for marijuana for this position. The company is a drug‑free workplace; possession, use, or being under the influence of drugs illegal under federal or state law during work hours, on company property, and/or in company vehicles is prohibited.

Benefits

Eligible employees enjoy flexible vacation with pay, up to 160 hours of paid wellness annually, 7 paid holidays, as well as additional paid time off for bereavement, voting, jury duty, volunteer work, military leave, and parental leave. Health care insurance (medical, dental, vision), retirement planning (401(k)), and other standard benefits are also available.

Equal Employment Opportunity Statement

Cox Automotive is an Equal Employment Opportunity employer. All qualified applicants/employees will receive consideration for employment without regard to 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.