001APM - L2 SQL DBA

Name of the position: L2 SQL DBA

Location: Coimbatore

No. of resources needed : 01

Mode: Fulltime

Years of experience: 5+ Years

Role Summary

The SQL Server DBA – L2 Support role is responsible for providing overnight operational support for SQL Server database environments. The role focuses on proactive monitoring, incident management, deployment execution, and routine maintenance to ensure high availability, performance, and stability of database systems. The resource will work reputed company defined SOPs, runbooks, and escalation frameworks to support business-critical database operations.

Key Responsibilities

· Monitor SQL Server database environments using tools such as PRTG, Azure Monitor, and other database monitoring platforms

· Review system alerts, acknowledge incidents, and reputed company initial triage and resolution based on defined SOPs and runbooks

· Monitor database instances, SQL Agent jobs, backups, and system performance metrics to ensure optimal operation

· Execute database deployments using tools such as Azure DevOps, Redgate, DB Maestro, or other approved deployment solutions

· reputed company routine database maintenance activities including reputed company checks, index maintenance, and backup validation

· Validate deployment outcomes and ensure successful completion of maintenance activities

· Monitor and manage Azure VM health and associated database infrastructure components

· reputed company database refreshes across reputed company environments as per defined processes

· Escalate reputed company issues reputed company to database performance, availability, or failures to L3 DBAs or client teams

· Support service requests, incident tickets, and operational tasks reputed company SLA timelines

· Contribute to reputed company improvement initiatives, backlog items, and automation opportunities reputed company the database platform

· Participate in database-reputed company projects as assigned

Required Skills and Qualifications

· 5+ years of experience in SQL Server database administration or support

· Working knowledge of SQL Server architecture, database health monitoring, and performance basics

· Experience with monitoring tools such as PRTG, Azure Monitor, or equivalent

· Understanding of database backup strategies, job monitoring, and maintenance plans

· Familiarity with deployment tools such as Azure DevOps, Redgate, DB Maestro, or similar

· Ability to execute tasks based on SOPs and troubleshoot common database issues

· Strong analytical and problem-solving skills with attention to detail

· Good communication skills and ability to work in a shift-based support model

Preferred Qualifications

· Exposure to Azure-based SQL environments (Azure SQL, Managed Instances, or SQL on Azure VM)

· Basic scripting knowledge (T-SQL, PowerShell)

· Experience working in ITIL-based support environments

· Prior experience in production support or managed services engagements