Job Description

Job Title: MS SQL DBA (Azure)
Years of Experience : 8+
Job Location: Gurgaon/Bangalore/ HYD
Number of Positions : 1
Job Summary:
We are looking for an experienced and highly skilled MS SQL Database Administrator (DBA) with 8+ years of experience, specializing in both on-premises and Azure cloud environments. The ideal candidate will have extensive expertise in managing, administering, and optimizing MS SQL databases in the cloud, particularly within Microsoft Azure. As an MS SQL DBA - Azure, you will be responsible for the end-to-end management of high-performance, high-availability, and scalable SQL Server databases across on-premises and cloud environments, ensuring the security, reliability, and performance of the systems.
Key Responsibilities:
Lead the administration, maintenance, and support of MS SQL Server databases, both on-premises and in the cloud (Azure SQL Database, Azure SQL Managed Instance, and Azure Virtual Machines).
Design, implement, and manage high availability and disaster recovery (HA/DR) solutions in Azure using technologies such as Always On Availability Groups, Failover Clustering, Azure Site Recovery, and Azure SQL Managed Instance.
Manage database migrations from on-premises SQL Server environments to Azure SQL databases, ensuring minimal downtime, data integrity, and seamless integration with existing systems.
Perform routine database performance tuning and query optimization, leveraging advanced techniques such as indexing, execution plan analysis, and resource management.
Oversee the configuration, automation, and monitoring of database systems using PowerShell, Azure CLI, and Azure Automation for routine tasks such as backups, updates, and maintenance.
Design and implement security policies and procedures to ensure data privacy, integrity, and compliance with industry standards (e.g., GDPR, HIPAA).
Monitor and troubleshoot SQL Server performance, availability, and security issues, ensuring proactive resolution of problems.
Collaborate with application developers and IT teams to ensure database solutions are optimized for cloud infrastructure, business needs, and scalability.
Develop and implement backup and recovery strategies for both on-premises and Azure environments, ensuring data protection and availability in case of failure.
Provide support for production database environments, including troubleshooting, database tuning, and recovery.
Work with Azure-native tools (e.g., Azure Monitor, Log Analytics, and Application Insights) to monitor and optimize database performance in Azure environments.
Establish and enforce best practices for database management, including automation, patching, and upgrades.
Document all database processes, configurations, and architectural designs to ensure knowledge sharing and compliance.
Mentor and guide junior DBAs and team members, providing technical leadership and supporting ongoing training and development.
Participate in database design and architecture planning with application and infrastructure teams to meet business requirements and performance standards.
Ensure database scalability, high availability, and disaster recovery capabilities in line with organizational and cloud strategies.
Required Qualifications:
8+ years of experience as a Database Administrator with a strong background in MS SQL Server administration and support.
Extensive hands-on experience with Microsoft Azure services, including Azure SQL Database, Azure SQL Managed Instance, and Azure Virtual Machines.
Strong knowledge and experience in designing, implementing, and managing high availability and disaster recovery solutions (Always On Availability Groups, Failover Clustering, etc.) in both on-premises and cloud environments.
Proven experience with database performance tuning, query optimization, and troubleshooting in SQL Server environments.
Strong understanding of database security practices, including encryption, auditing, role-based access controls, and security patches.
Proficiency in PowerShell, Azure CLI, and automation tools for managing SQL Server databases and cloud resources.
Experience with database migration strategies from on-premises to Azure SQL environments, with a focus on seamless data transfer and application uptime.
Familiarity with using Azure-native monitoring and diagnostic tools (e.g., Azure Monitor, Log Analytics, Application Insights) to track database health and performance.
In-depth knowledge of backup, restore, and disaster recovery strategies, with a solid understanding of data protection principles and best practices.
Strong analytical, problem-solving, and troubleshooting skills in high-performance and mission-critical environments.
Excellent communication skills, both verbal and written, with the ability to collaborate with both technical and non-technical teams.
Bachelor's degree in computer science, Information Technology, or a related field, or equivalent professional experience.
Preferred Qualifications:
Microsoft Certified: Azure Database Administrator Associate certification or equivalent.
Experience with Azure DevOps and CI/CD pipelines for automated database deployments and management.
Familiarity with other database technologies (e.g., MySQL, PostgreSQL) and hybrid cloud environments.
Knowledge of containerized database solutions using Docker, Kubernetes, or Azure Kubernetes Service (AKS).
Familiarity with Azure Synapse Analytics, Azure Data Factory, and Azure Data Lake.
Strong leadership experience and ability to mentor a team of DBAs.
Advanced scripting skills with Python or other automation languages.

Skills Required