Ms Sql Dba

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