Description
CarShield is seeking an experienced Database Administrator to join its growing database team. In this role, you'll be responsible for administering and optimizing our SQL Server environment, ensuring the availability, performance, security, and reliability of critical databases that support our business. You'll work closely with developers and IT teams to implement high-availability solutions, troubleshoot production issues, maintain backup and disaster recovery strategies, and continuously improve database performance and operational efficiency.
- Administer and monitor SQL Server instances across our on-premises environment
- Manage Always On Availability Groups, including failover, replica health, and AG job synchronization
- Own backup/restore strategies and DR testing to ensure RTO/RPO targets are met
- Performance-tune queries and workloads via execution plans, DMVs, wait stats, and indexing
- Manage SQL Server security — logins, roles, permissions auditing, and least-privilege enforcement
- Respond to production incidents, diagnose root causes, and implement durable fixes
- Collaborate with developers to review schema changes and query patterns before they hit production
- Monitor and maintain SQL Agent jobs, including Change Data Capture (CDC)
Requirements
- 5+ years of SQL Server DBA experience in a production environment
- Hands-on experience administering Always On Availability Groups
- Strong grasp of performance tuning — execution plans, index strategy, wait statistics
- Solid understanding of SQL Server security, auditing, and access control
- Experience with backup/restore, DR planning, and failover procedures
- Must be able to work on-site in St. Peters, MO 5 days/week
- Bachelor's in Computer Science, MIS, or equivalent experience
- Familiarity with Extended Events and Query Store preferred
- Exposure to Azure SQL or hybrid cloud environments preferred
- T/SQL Development when needed for project preferred
- Experience with data engineering and building data pipelines (ETL/ELT) preferred
Pay Rate and Benefits
- Salary commensurate with experience
- Group Insurance (Medical, Dental, Vision, Life, etc.).
- 401k with Employer Match.
- Discounted CarShield policies.
- Discounted Tuition at Lindenwood University.
- Professional development opportunities.
- Basketball, and other recreation available on-site.
- Fitness facilities, with the option to take classes led by on-staff personal trainer (at St. Peters headquarters).
- And more!
Skills Required
- 5+ years of SQL Server DBA experience in a production environment
- Hands-on experience administering Always On Availability Groups
- Strong grasp of performance tuning (execution plans, index strategy, wait statistics)
- Solid understanding of SQL Server security, auditing, and access control
- Experience with backup/restore, disaster recovery planning, and failover procedures
- Ability to administer and monitor SQL Server instances in an on-premises environment
- Manage SQL Agent jobs and Change Data Capture (CDC)
- Must be able to work on-site in St. Peters, MO 5 days/week
- Bachelor's degree in Computer Science, MIS, or equivalent experience
- Familiarity with Extended Events and Query Store
- Exposure to Azure SQL or hybrid cloud environments
- T/SQL development when needed for projects
- Experience with data engineering and building data pipelines (ETL/ELT)
What We Do
CarShield specializes in providing vehicle service contracts to shield members from the high cost of automobile repairs, offering flexible plans and services like roadside assistance, rental car options, and courtesy towing.
