MS SQL Database Administrator – L2
Job Designation: MS SQL Database Administrator – Level 2.
Employment Type: Full-time | Onsite.
Experience: 3–5 years of MS SQL Server administration.
About the Role:
As an MS SQL DBA, you will manage, maintain, and optimize SQL Server databases across production and DR environments. You will ensure performance tuning, high availability, backup/recovery readiness, and support day-to-day operations for banking and enterprise applications.
Key Responsibilities:
• Manage installation, configuration, and administration of MS SQL Server databases
• Perform regular backup & recovery using native SQL Server tools
• Monitor performance metrics using SQL Profiler, DMVs, and Extended Events
• Optimize slow queries, indexes, and database schemas
• Perform patching, version upgrades, migrations
• Monitor events, logs, deadlocks, blocking sessions
• Implement high-availability (HA) methods: Failover Cluster, AlwaysOn AG
• Perform security hardening and user/role management
• Support application deployment and DB release activities
• Participate in DR drills, replication verification, and failover testing
• Provide daily monitoring reports & capacity planning inputs
Required Skills & Experience:
• Strong hands-on knowledge of SQL Server 2012/2014/2016/2019
• Experience in AlwaysOn, clustering, backup/restore, log shipping
• Strong T-SQL querying, troubleshooting, and performance tuning
• Familiarity with SSIS, SSRS (added advantage)
• Understanding of Windows Server OS & AD integration
• Experience in banking/financial domain preferred
• Good communication, RCA preparation & documentation skills