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
Yochana IT Solutions | Founded in Michigan, 2009 Headquartered at 23000 Commerce Drive, Farmington Hills, MI 48335. It was founded in 2009, and is headquartered in Farmington Hills, Michigan, USA, with a workforce of 201-500 employees. Its website is http://yochana.com/.Company H1B Sponsorship
Yochana has a track record of offering H1B sponsorships, with 5 in 2026, 21 in 2025, 11 in 2024, 3 in 2023. Please note that this does not guarantee sponsorship for this specific role.