Manage SQL Server DBs through multiple lifecycle environments Dev, QA, Staging and Production.
Strong expertise in Database HA-DR including AG, Failover clustering at windows and SQL layers. Hands on experience in setting DR across multiple datacenters is must.
Very strong query optimization skills and complex query tuning hands on experience.
Must be familiar with day-to-day operations such as monitoring, performance tuning and capacity planning.
Ability to develop the required techniques to capture data , analyse and fix the issues with respect to resources(CPU,IO,Memory NW etc)
Refine and automate regular processes, track issues, and document changes.
Strong Automation and scripting knowledge(Powershell or Python)
Knowledge on Windows , Linux , Oracle and My SQL DB's. Having Exp in any Bigdata technology is added advantage.
Strong English written/verbal communications
Self-motivated individual who works well in a team environment.
Willingness to work in 24X7 rotational shifts and Oncall.