Role: L2 Database Administrator (DBA) – MS SQL Server
Experience: 6-8 years
Support Model: 24/7
Location: Plano, TX and Atlanta, GA (Day1 Onsite)
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
Never miss an opportunity! Create an alert based on the job you applied for.
