01Overview
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 within defined SOPs, runbooks, and escalation frameworks to support businesscritical 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 perform 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
Perform routine database maintenance activities including integrity 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
Perform database refreshes across lower environments as per defined processes
Escalate complex issues related to database performance, availability, or failures to L3 DBAs or client teams
Support service requests, incident tickets, and operational tasks within SLA timelines
Contribute to continuous improvement initiatives, backlog items, and automation opportunities within the database platform
Participate in databaserelated 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 problemsolving skills with attention to detail
Good communication skills and ability to work in a shiftbased support model
Preferred Qualifications
Exposure to Azurebased SQL environments (Azure SQL, Managed Instances, or SQL on Azure VM)
Basic scripting knowledge (TSQL, PowerShell)
Experience working in ITILbased support environments
Prior experience in production support or managed services engagements .
