[Remote] Jnr L2 Database Administrator (DBA) – MS SQL Server
Note: The job is a remote job and is open to candidates in USA. Yochana is seeking a Junior L2 Database Administrator (DBA) specializing in MS SQL Server. The role involves assisting in the administration of SQL Server production environments, performing routine maintenance, and supporting operational requests.
Responsibilities
- Hands‑on experience assisting in the administration of Microsoft SQL Server production environments, including basic instance start/stop activities and routine operational maintenance
- Working knowledge of SQL Server backup and recovery operations, including full/differential/log backups, restore execution under guidance, and verification of backup success
- Familiarity with SQL Server preventive maintenance tasks, including index maintenance, statistics updates, and execution of scheduled maintenance jobs using standard scripts or plans
- Ability to perform basic SQL Server health checks, including monitoring disk space, database growth trends, and identifying common availability risks for escalation
- Basic exposure to SQL Server performance monitoring, including identifying slow‑running queries, monitoring CPU, memory, and I/O utilization, and capturing diagnostics for L2/L3 review
- Ability to follow approved runbooks and procedures to execute standard SQL Server changes (patching support, configuration updates, restarts) with supervision
- Working understanding of ITSM processes using ServiceNow, including logging, updating, and tracking Incident and Request tickets with proper documentation
- Experience supporting request fulfillment activities, such as access changes, database refresh support, and routine operational requests following defined procedures
- Familiarity with SQL Server administration tools, including SSMS and basic use of monitoring dashboards for daily operational tasks
- Willingness and ability to escalate issues promptly and accurately to L3 DBAs with relevant observations, logs, and collected evidence
Skills
- Hands‑on experience assisting in the administration of Microsoft SQL Server production environments, including basic instance start/stop activities and routine operational maintenance
- Working knowledge of SQL Server backup and recovery operations, including full/differential/log backups, restore execution under guidance, and verification of backup success
- Familiarity with SQL Server preventive maintenance tasks, including index maintenance, statistics updates, and execution of scheduled maintenance jobs using standard scripts or plans
- Ability to perform basic SQL Server health checks, including monitoring disk space, database growth trends, and identifying common availability risks for escalation
- Basic exposure to SQL Server performance monitoring, including identifying slow‑running queries, monitoring CPU, memory, and I/O utilization, and capturing diagnostics for L2/L3 review
- Ability to follow approved runbooks and procedures to execute standard SQL Server changes (patching support, configuration updates, restarts) with supervision
- Working understanding of ITSM processes using ServiceNow, including logging, updating, and tracking Incident and Request tickets with proper documentation
- Experience supporting request fulfillment activities, such as access changes, database refresh support, and routine operational requests following defined procedures
- Familiarity with SQL Server administration tools, including SSMS and basic use of monitoring dashboards for daily operational tasks
- Willingness and ability to escalate issues promptly and accurately to L3 DBAs with relevant observations, logs, and collected evidence
- Microsoft Certified: Azure Database Administrator Associate (DP 300)
- Windows 2019/22/ Redhat Linux 8.x/9.x
- ITIL V4
Company Overview
Company H1B Sponsorship