Manager | MS SQL | | Engineering

Deloitte Consulting

10 - 15 years

40 - 45 Lacs

coimbatore

Posted:1 day ago| Platform:

Apply

Skills Required

performance tuning log shipping automation ms sql managed services database design powershell database administration problem management sql

Work Mode

Work from Office

Job Type

Full Time

Job Description

Act as the primary SQL Server DBA SME for operate/managed services projects.

Administer, monitor, and maintain MS SQL Server databases (on-premises and cloud-hosted AWS RDS for SQL Server, Azure SQL Database, Azure SQL Managed Instance).
Ensure high availability (HA/DR), backup, and recovery strategies using Always On Availability Groups, Log Shipping, Database Mirroring, and Clustering.
Monitor database performance, capacity, and health, and implement proactive tuning and optimization.
Manage database security, encryption, auditing, and compliance with organizational policies and industry regulations.
Automate routine DBA tasks (backups, patching, scaling, health checks, user provisioning) using PowerShell, T-SQL, and runbook automation tools.
Troubleshoot incidents, outages, and performance bottlenecks, and provide RCA with preventive measures.
Work with application and infrastructure teams to support database design, migrations, and upgrades across hybrid and multi-cloud environments.
Maintain operational documentation, runbooks, and SOPs for DBA activities.
Provide knowledge transfer, mentoring, and guidance to junior DBAs and operations staff.
Stay updated with the latest SQL Server and cloud database services to recommend adoption strategies.

Requirements:

10+ years of experience as a SQL Server DBA in enterprise and cloud environments.
Strong expertise in MS SQL Server 2012/2016/2019 and Azure SQL Database.
Hands-on experience with cloud SQL platforms AWS RDS for SQL Server, Azure SQL Database, Azure SQL Managed Instance.
Proficiency in HA/DR solutions Always On Availability Groups, Clustering, Log Shipping, Replication, Mirroring.
Expertise in performance tuning and query optimization (indexes, execution plans, partitioning).
Strong skills in T-SQL scripting and PowerShell automation.
Experience with monitoring tools (SQL Profiler, Redgate, SolarWinds DPA, SentryOne, Cloud-native monitoring in AWS CloudWatch & Azure Monitor).
Strong understanding of backup, restore, and recovery models.
Familiarity with cloud migration strategies (on-premises to AWS/Azure SQL).
Exposure to ITIL-based operate models (incident, change, and problem management).

More Jobs at Deloitte Consulting

Senior Consultant

Pune, Chennai, Bengaluru

5.0 - 10.0 yrs

INR 8 - 18 Lacs

Netsuite Functional Consultant

Hyderabad, Bengaluru, Delhi / NCR

3.0 - 9.0 yrs

Salary: Not disclosed

Consultant/Senior Consultant || MS Dynamics and Power Platform

Pune, Bengaluru, Mumbai (All Areas)

3.0 - 8.0 yrs

INR 9 - 19 Lacs

Senior Consultant

Bengaluru

6.0 - 9.0 yrs

INR 16 - 22 Lacs

Oracle CPQ- Consultant

Hyderabad, Bengaluru, Delhi / NCR

3.0 - 8.0 yrs

INR 18 - 27 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.