Lead SQL Server

The company is looking for a Lead SQL Server DBA with over 10 years of experience to manage and support DBA operations in various environments, including on-premises and Azure cloud infrastructure. The ideal candidate will have expertise in cloud migration, performance tuning, database security, and leading support teams across different levels. As a Lead SQL Server DBA, you will be responsible for overseeing a team of 10+ DBAs supporting SQL Server, Oracle, and MySQL databases in multiple entities. You will lead cloud migration efforts and manage Azure-based database systems while ensuring high availability, disaster recovery, and optimized backup/restore procedures. Additionally, you will be involved in overseeing structured and unstructured database systems, optimizing performance, enhancing security, and ensuring compliance with cybersecurity regulations. Your role will also involve reviewing and managing database code quality, enforcing best practices, and supporting development teams. You will be responsible for managing DevOps database deployment pipelines using tools like Redgate and acting as a technical lead in support engagements, handling escalations and critical issues. Collaboration in onshore/offshore models and Agile environments will also be a part of your responsibilities. The ideal candidate should have at least 10 years of experience in SQL Server administration, with a strong focus on cloud migration and support, especially on Microsoft Azure. Hands-on experience with Databricks, lakehouse concepts, and data warehousing is essential. In-depth knowledge of HA/DR architecture, security optimization, compliance standards, and performance tuning is required. Familiarity with support across different service tiers, expertise in DevOps practices, and excellent communication skills are also necessary. Desirable qualifications include experience in the insurance domain, familiarity with Active Directory and Windows Server environments, and Microsoft certifications in relevant database/cloud technologies. This is a full-time position with Provident Fund benefits. The work location is in person.,