Job Description

Overview:

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