As a Senior SQL Server Database Administrator, you will be primarily responsible for managing and optimizing Microsoft SQL Server environments, both on-premises and in AWS (with some exposure to Azure). You will proactively monitor, tune, and maintain database performance and reliability while collaborating with cross-functional teams to ensure smooth deployments, scalability, and compliance with system standards.
Duties & Responsibilities
- Deploy, configure, and manage large-scale Microsoft SQL Server databases (on-prem and AWS), along with supporting PostgreSQL and MySQL environments.
- Monitor and tune database performance queries, indexes, I/O, caching. Identify and resolve performance bottlenecks and deadlocks.
- Perform root cause analysis for slow queries and support load testing and performance benchmarking with development and performance teams.
- Provide data-related insights to assist in performance investigations or product improvements.
- Recommend and execute database scaling strategies (vertical and horizontal) to meet growth and system demand.
- Develop and maintain stored procedures, T-SQL scripts, and database jobs for automation and performance optimization.
- Manage database replication, clustering, and high-availability configurations across data centers and cloud regions.
- Oversee backup and recovery procedures, and maintain disaster recovery readiness.
- Install and test database upgrades, patches, and migrations in production and non-production environments.
- Design and maintain database schema, tables, stored procedures, and permissions in accordance with best practices.
- Ensure code deployments and updates are executed smoothly following operational procedures.
- Document, prioritize, and resolve support tickets in compliance with SLAs.
- Collaborate with engineering, operations, and application teams to enhance database performance and stability.
Skills Required
- Extensive hands-on experience with Microsoft SQL Server (administration, T-SQL, stored procedures, performance tuning, and troubleshooting).
- Expertise in query optimization, indexing, and database performance analysis.
- Experience with SQL Server replication, clustering, and Always On Availability Groups.
- Experience managing SQL Server in AWS (EC2, RDS, or Aurora); exposure to Azure SQL or Azure VMs is a plus.
- Familiarity with PostgreSQL and MySQL administration.
- Proficiency in scripting (PowerShell, Bash, or Python) for automation tasks.
- Solid understanding of operational security, networking, and distributed systems principles.
- Excellent analytical and troubleshooting skills, able to resolve complex issues rapidly.
- Strong communication and collaboration skills to work effectively with engineering and operations teams.
- Ability to thrive in a fast-paced environment with multiple concurrent
