Sql Server Dba Lead

Key Responsibilities:

• Perform SQL Server administration, installation, configuration, upgrades, patching, and maintenance.
• Monitor and optimize SQL Server performance, including query tuning, indexing, blocking, deadlocks, and resource utilization.
• Implement and manage High Availability/Disaster Recovery (HA/DR) solutions, including Always On Availability Groups.
• Manage backup and recovery strategies, including backup validation and database restoration.
• Administer Azure SQL Database and Azure SQL Managed Instance (MI) environments.
• Support SQL Server to Azure migrations and hybrid on-premises/Azure database environments.
• Troubleshoot production database issues and perform Root Cause Analysis (RCA) for incidents.
• Develop and maintain automation using PowerShell and Azure CLI.
• Monitor database health, availability, capacity, and performance across production environments.
• Implement database security, access controls, permissions, and auditing in line with organizational standards.
• Collaborate with application, infrastructure, cloud, and development teams to resolve database-related issues.
• Participate in database modernization, migration, and cloud adoption initiatives.

Required Skills:

• Strong hands-on experience with Microsoft SQL Server DBA activities.
• Expertise in SQL Server performance tuning and troubleshooting.
• Strong knowledge of Always On Availability Groups, HA/DR, backup and recovery.
• Hands-on experience with Azure SQL Database and Azure SQL Managed Instance.
• Experience with SQL Server migration to Azure and hybrid database environments.
• Good knowledge of T-SQL, indexing, execution plans, blocking, deadlocks, and query optimization.
• Experience with PowerShell and/or Azure CLI for database administration and automation.
• Strong production support, incident management, and RCA experience.
• Knowledge of database security, permissions, monitoring, and auditing.
• Good communication and problem-solving skills.

Preferred Skills:

• Experience with Azure Database Migration Service (DMS).
• Knowledge of Azure Monitor, Log Analytics, and Azure Automation.
• Exposure to Infrastructure as Code (IaC) and CI/CD practices.
• Experience with database monitoring and automation tools.
• Exposure to Microsoft Fabric / modern data platform technologies is an advantage.