Track Lead - AzureMSSQL DBA, Microsoft Azure (IN)
HCLTech
HCLTech
Seeking a skilled Azure MSSQL DBA to manage and optimize Microsoft SQL Server environments within the Azure cloud. This role involves installation, configuration, administration, patching, and upgrades of SQL Server instances across production, DR, UAT, and non-production environments.
Key responsibilities include in-depth troubleshooting of complex L3 issues such as blocking, deadlocks, performance bottlenecks, and corruption. You will also be responsible for performance tuning, query optimization, and maintaining database integrity through regular backups and recovery procedures.
This position offers an opportunity to work with advanced SQL Server features like Always On Availability Groups, Failover Cluster Instances, and Log Shipping. You will also support critical database activities including migration, consolidation, and version upgrades, ensuring seamless operations and data availability. A proactive approach to security hardening and vulnerability remediation is essential.
Administer, patch, and upgrade Microsoft SQL Server environments on Azure. Manage diverse database environments including Production, Disaster Recovery (DR), User Acceptance Testing (UAT), and non-production.
Resolve complex L3 technical issues, focusing on performance diagnostics like blocking, deadlocks, high resource utilization, and disk I/O. Address database corruption, connectivity problems, and availability concerns.
Execute comprehensive SQL performance tuning, optimize queries, analyze execution plans, and manage index/statistics for optimal performance. Ensure data durability and recoverability through robust backup, restore, and point-in-time recovery strategies.
Configure and troubleshoot high availability solutions such as Always On Availability Groups, Failover Cluster Instances, Log Shipping, and SQL Replication. Facilitate database migration, consolidation, refresh, and version-upgrade projects.
Manage database security by overseeing logins, users, roles, permissions, and service accounts. Monitor database growth, conduct capacity planning, and manage SQL Server Agent jobs and scheduled tasks.
Implement SQL Server security hardening, apply patches, and remediate vulnerabilities. Troubleshoot application-to-database and infrastructure connectivity issues, leading technical resolution for critical incidents.
Perform detailed Root Cause Analysis (RCA) for major incidents and develop proactive solutions. Plan and execute production changes in adherence to ITIL Change Management best practices. Automate routine DBA tasks using T-SQL and PowerShell.
Collaborate effectively with cross-functional teams including Windows, Storage, Backup, Network, Cloud, Security, and Application teams. Engage with Microsoft/OEM support for intricate technical challenges. Provide mentorship and technical guidance to L1/L2 DBAs. Maintain and update SOPs, runbooks, technical documentation, and knowledge base articles.
Proven experience in installing, configuring, administering, patching, and upgrading Microsoft SQL Server environments.
Proficiency in managing Production, DR, UAT, and non-production databases, with a strong understanding of their specific requirements.
Expertise in troubleshooting complex L3 issues, including blocking, deadlocks, high CPU/memory utilization, disk I/O bottlenecks, database corruption, and connectivity problems.
Skilled in SQL performance tuning, query optimization, execution plan analysis, and index/statistics maintenance for optimal database performance.
Experience with database backup, restore, recovery, and point-in-time recovery strategies is essential.
Hands-on experience configuring and administering Always On Availability Groups, Failover Cluster Instances, Log Shipping, and SQL Replication.
Ability to support database migration, consolidation, refresh, and version-upgrade activities effectively.
Strong understanding of SQL Server security, including managing logins, users, roles, permissions, and service accounts.
Experience with database capacity planning and monitoring database growth.
Proficiency in managing SQL Server Agent jobs, maintenance tasks, and scheduled activities.
Knowledge of SQL Server security hardening, patching, and vulnerability remediation.
Ability to troubleshoot application-to-database and infrastructure connectivity issues.
Experience in leading technical troubleshooting during P1/P2 incidents and performing detailed Root Cause Analysis (RCA).
Familiarity with ITIL Change Management processes for planning and executing production changes.
Experience in automating routine DBA activities using T-SQL and PowerShell.
Excellent collaboration skills to coordinate with Windows, Storage, Backup, Network, Cloud, Security, and Application teams.
Ability to engage Microsoft/OEM support for complex technical issues.
Experience in providing technical guidance and mentoring to junior DBAs.
Proficiency in maintaining SOPs, runbooks, technical documentation, and knowledge articles.
HCLTech
IT Consulting