Job Summary Role: L2 Database Administrator (DBA) - MS SQL Server Experience: 6-8 years Support Model: 24/7 Location: Plano, TX and Atlanta, GA (Day1 Onsite) Need bachelor's degree. Salary Range- $80K- $90K Per Annum Skills & Experience - Hands-on experience administering Microsoft SQL Server in production environments, including instance startup/shutdown, configuration parameter changes, and operational maintenance.
- Strong working knowledge of SQL Server monitoring and maintenance, including full/differential/log backups, restore operations, DBCC integrity checks, statistics updates, and scheduled maintenance jobs.
- Ability to perform routine SQL Server health diagnostics and remediation, including DBCC checks, identifying space and growth risks, and proactively addressing common availability and performance issues.
- Ability to execute approved SQL Server changes (installations, upgrades, patching, configuration updates) by following documented runbooks, validation steps, and rollback procedures.
- Working understanding of ITSM processes using ServiceNow, including Incident, Problem, Change, and Request Management, with accurate ticket updates and timely escalation to L3 DBAs.
- Practical experience in SQL Server performance monitoring and basic tuning, including identifying slow-running queries, detecting blocking and deadlocks, and monitoring CPU, memory, and I/O contention.
- Ability to escalate complex performance and query optimization issues to L3 DBAs with appropriate diagnostics and analysis.
- Hands-on execution of SQL Server backup validation and restore activities, including support for recovery and disaster recovery exercises under L3 guidance.
- Experience supporting SQL Server security operations, including login and role management, permission changes, and execution of approved security controls.
- Experience supporting audit and compliance activities for SQL Server environments, including evidence collection, remediation execution, and documentation updates.
Recommended Certifications Microsoft Certified: Azure Database Administrator Associate (DP-300)
Azure Solutions Architect Expert is an advantage
Windows 2019/22/ Redhat Linux 8.x/9.x
ITIL V4
The pay range for this role is $80,000 - $90,000* per annum including any bonuses or variable pay. Tech Mahindra also offers benefits like medical, vision, dental, life, disability insurance and paid time off (including holidays, parental leave, and sick leave, as required by law). Ask our recruiters for more details on our Benefits package. The exact offer terms will depend on the skill level, educational qualifications, experience and location of the candidate.
