---

---

Location

Chennai | India

---

Job description

Detailed JD *(Roles and Responsibilities)

• Manage SQL Server databases.
• Install, configure, and maintain database servers and processes.
• Monitor systems health and performance.
• Experience in Database high availability feature like ALWAYS ON
• Refine and automate regular processes, track issues, and document changes.
• Provide support for critical production systems.
• Perform scheduled maintenance and support release deployment activities.
• Monitoring all the Alerts. Every alert DBA team member will respond with the initially response.
• and followed by resolution email.
• Troubleshooting the SQL jobs maintenance jobs failed
• Troubleshoot disk space alert.
• Experience in Creating, maintaining and scheduled jobs.
• Database backup and restore including monitoring and verifying backups and perform ad-hoc.
• backups and restore.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Experience in MSSQL Built-in tools such as SQL Profiler, SQL Database Tuning Advisor, Query
• Execution Plan, etc. as well as third party tools; Actifio / Foglight.
• Experience in creating and maintaining SQL Agent Jobs and Maintenance Plans
• Microsoft SQL server Version updates and patching activities

Mandatory skills*

MS SQL Server 2012/2014/2016/2017/2019 and Windows administration

Desired skills*

MS SQL Server 2012/2014/2016/2017/2019

---

Job tags

---

---

Salary