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