[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.ResponsibilitiesHands‑on experience assisting in the administration of Microsoft SQL Server production environments, including basic instance start/stop activities and routine operational maintenanceWorking knowledge of SQL Server backup and recovery operations, including full/differential/log backups, restore execution under guidance, and verification of backup successFamiliarity with SQL Server preventive maintenance tasks, including index maintenance, statistics updates, and execution of scheduled maintenance jobs using standard scripts or plansAbility to perform basic SQL Server health checks, including monitoring disk space, database growth trends, and identifying common availability risks for escalationBasic exposure to SQL Server performance monitoring, including identifying slow‑running queries, monitoring CPU, memory, and I/O utilization, and capturing diagnostics for L2/L3 reviewAbility to follow approved runbooks and procedures to execute standard SQL Server changes (patching support, configuration updates, restarts) with supervisionWorking understanding of ITSM processes using ServiceNow, including logging, updating, and tracking Incident and Request tickets with proper documentationExperience supporting request fulfillment activities, such as access changes, database refresh support, and routine operational requests following defined proceduresFamiliarity with SQL Server administration tools, including SSMS and basic use of monitoring dashboards for daily operational tasksWillingness and ability to escalate issues promptly and accurately to L3 DBAs with relevant observations, logs, and collected evidenceSkillsHands‑on experience assisting in the administration of Microsoft SQL Server production environments, including basic instance start/stop activities and routine operational maintenanceWorking knowledge of SQL Server backup and recovery operations, including full/differential/log backups, restore execution under guidance, and verification of backup successFamiliarity with SQL Server preventive maintenance tasks, including index maintenance, statistics updates, and execution of scheduled maintenance jobs using standard scripts or plansAbility to perform basic SQL Server health checks, including monitoring disk space, database growth trends, and identifying common availability risks for escalationBasic exposure to SQL Server performance monitoring, including identifying slow‑running queries, monitoring CPU, memory, and I/O utilization, and capturing diagnostics for L2/L3 reviewAbility to follow approved runbooks and procedures to execute standard SQL Server changes (patching support, configuration updates, restarts) with supervisionWorking understanding of ITSM processes using ServiceNow, including logging, updating, and tracking Incident and Request tickets with proper documentationExperience supporting request fulfillment activities, such as access changes, database refresh support, and routine operational requests following defined proceduresFamiliarity with SQL Server administration tools, including SSMS and basic use of monitoring dashboards for daily operational tasksWillingness and ability to escalate issues promptly and accurately to L3 DBAs with relevant observations, logs, and collected evidenceMicrosoft Certified: Azure Database Administrator Associate (DP 300)Windows 2019/22/ Redhat Linux 8.x/9.xITIL V4Company OverviewYochana 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 SponsorshipYochana 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.