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.
- 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.
- 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.
- Expertise in SQL Server replication across multiple databases; troubleshoot replication latency, distribution bottlenecks, and data consistency issues.
- 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.
