Job
Description
Job Title: SQL Server DBA Location: Mumbai / Kolkata / Chennai / Delhi Experience Required: 5 – 7 Years Employment Type: Full-Time Shift: Rotational Night Shifts (Including Weekends) – 24/7 Support Environment Job Overview: We are seeking a proactive and skilled MS SQL Server DBA to manage and support our critical database infrastructure across a 24/7 support model . The ideal candidate should have strong experience with SQL Server 2019 , Always On Availability Groups , Change Data Capture (CDC) , audit and security management , and experience working in high-availability and disaster recovery environments. Experience on Microsoft Azure is a plus. Key Responsibilities: Install, configure, and maintain Microsoft SQL Server 2019 databases in production, test, and development environments. Manage and monitor Always On Availability Groups , failover clustering , and DR (Disaster Recovery) setups. Implement and maintain SQL Change Data Capture (CDC) , backup strategies, and database recovery. Perform query tuning , index optimization , and troubleshoot performance issues. Set up and enforce SQL Server security policies , including auditing , encryption , and role-based access control . Participate in and support rotational night shifts , including weekend on-call responsibilities as part of a 24x7 team. Maintain comprehensive documentation of database configurations, policies, and procedures. Work closely with application teams, infrastructure, and security to ensure high database availability and performance. Must-Have Skills: Strong experience as an MS SQL Server DBA (2016/2019) . Hands-on expertise with Always On Availability Groups and HA/DR configurations . Experience with SQL CDC (Change Data Capture) and SQL Server auditing . Proficiency in query tuning , index optimization , and performance troubleshooting . Knowledge of security management , including user permissions and encryption mechanisms. Good-to-Have Skills: Experience working in Microsoft Azure SQL or hybrid cloud environments. Exposure to automation using PowerShell or T-SQL . Familiarity with monitoring tools such as SolarWinds, Redgate, or native SQL tools. Behavioral Competencies: Excellent problem-solving and troubleshooting abilities. Strong communication skills and ability to work in a team-oriented environment. Willingness to work in a rotating shift and take ownership during critical incidents. Detail-oriented with a commitment to operational excellence. Why Join Us? Work in a mission-critical, enterprise-level 24/7 environment. Opportunity to be part of complex HA/DR solutions and cutting-edge Azure integrations . Career growth in a collaborative, fast-paced, and technology-focused team. Show more Show less
