L2 Database Administrator - IT Operations

<p><b>L2 MS SQL Server DB Support Engineer</b><br/><br/><b>Location : Gurgaon (Work from Office)</b><br/><br/><b>Overview :</b><br/><br/>The ideal candidate will combine excellence in both the operational day-to-day execution as well as project implementation work.

The resource will manage the MS SQL DB Infra of DC, DR and Cloud DB.<br/><br/><b>RESPONSIBILITIES : </b><br/><br/>- Manage On-premises and Cloud DB Support<br/><br/>- Monitor DB health and performance<br/><br/>- DB creation and manage DB permission<br/><br/>- Manage SQL Server databases maintenance tasks like DBCC Check DB, Rebuild Indexes, Update Stats<br/><br/>- Installation of SQL Server version 2016/2017/2019/2022.<br/><br/>- Perform SQL Server Hardening as per best practice.<br/><br/>- Perform SQL Server patching on Standalone and Cluster Servers.<br/><br/>- Manage SQL DB log file size.<br/><br/>- Ability to prepare database activity plan and execute.<br/><br/>- Ability to Troubleshoot DB issue and provide solution.<br/><br/>- Manage DB backups and restores.<br/><br/>- Provide 24x7 support for critical production systems.<br/><br/>- Implementation of Alert configuration to get notification for any issue.<br/><br/>- Configure and manage SSRS, SSIS and SSAS.<br/><br/>- Monitor daily backup activity and reporting to proactively avoid issues and troubleshoot missed and failed backup jobs.<br/><br/>- Perform restores for various type of data in case of data loss as per business requirement.<br/><br/>- Manage Business Continuance in relation to Disaster Recovery.<br/><br/>- Provide assistance on SOP documentation at all levels of the projects/changes/support.

<br/><br/>- Assess and implement best practices in line with change management process.<br/><br/>- Ability to handle escalated tickets and provide solution/RCA in time.<br/><br/>- Ability to explore automation of current tasks and drive it<br/><br/><b>Experience :</b><br/><br/>- 4+ Years of Experience in handling .<br/><br/>- Experience on Installation of SQL Server version 2016/2017/2019/2022.

<br/><br/>- Experience on configure and manage SQL Server High Availability (HA) setup like SQL Cluster, AlwaysOn with SQL Version 2016/2017/2019.<br/><br/>- Experience on configure Disaster Recovery (DR) for SQL Server DB via Log Shipping<br/><br/>- Experience on migration and upgradation of SQL Server Database.<br/><br/>- Experience in managing SQL Server Security.<br/><br/>- Experience on configure Database mirroring and Replication.<br/><br/>- Experience in performance tunning.<br/><br/>- Manage Cloud DB.<br/><br/>- Basic knowledge on MySQL and PostgreSQL<br/><br/><b>Qualification :</b><br/><br/>- Bachelor or higher degree in one of these fields.<br/><br/>- BE/B.TECH/MCA/BCA<br/><br/>- MS SQL Server certifications a plus</p> (ref:hirist.tech)