Track Lead - AzureMSSQL DBA, Microsoft Azure

Job Summary

  Install, configure, administer, patch, and upgrade Microsoft SQL Server environments. Manage Production, DR, UAT, and non-production databases. Troubleshoot complex L3 issues including: Blocking and deadlocks High CPU and memory utilization Disk I/O and database performance issues Database corruption Connectivity and availability issues Perform SQL performance tuning, query optimization, execution-plan analysis, and index/statistics maintenance. Manage database backup, restore, recovery, and point-in-time recovery. Configure, administer, and troubleshoot: Always On Availability Groups Failover Cluster Instances Log Shipping SQL Replication where applicable Support database migration, consolidation, refresh, and version-upgrade activities. Manage SQL Server logins, users, roles, permissions, and service accounts. Monitor database growth and perform capacity planning. Manage SQL Server Agent jobs, maintenance tasks, and scheduled activities. Perform SQL Server security hardening, patching, and vulnerability remediation. Troubleshoot application-to-database and infrastructure connectivity issues. Lead technical troubleshooting during P1/P2 incidents. Perform detailed Root Cause Analysis (RCA) for major and recurring incidents. Plan and execute production changes following ITIL Change Management processes. Automate routine DBA activities using T-SQL and PowerShell. Coordinate with Windows, Storage, Backup, Network, Cloud, Security, and Application teams. Engage Microsoft/OEM support for complex technical issues. Provide technical guidance and mentoring to L1/L2 DBAs. Maintain SOPs, runbooks, technical documentation, and knowledge articles.

Key Responsibilities

  Install, configure, administer, patch, and upgrade Microsoft SQL Server environments. Manage Production, DR, UAT, and non-production databases. Troubleshoot complex L3 issues including: Blocking and deadlocks High CPU and memory utilization Disk I/O and database performance issues Database corruption Connectivity and availability issues Perform SQL performance tuning, query optimization, execution-plan analysis, and index/statistics maintenance. Manage database backup, restore, recovery, and point-in-time recovery. Configure, administer, and troubleshoot: Always On Availability Groups Failover Cluster Instances Log Shipping SQL Replication where applicable Support database migration, consolidation, refresh, and version-upgrade activities. Manage SQL Server logins, users, roles, permissions, and service accounts. Monitor database growth and perform capacity planning. Manage SQL Server Agent jobs, maintenance tasks, and scheduled activities. Perform SQL Server security hardening, patching, and vulnerability remediation. Troubleshoot application-to-database and infrastructure connectivity issues. Lead technical troubleshooting during P1/P2 incidents. Perform detailed Root Cause Analysis (RCA) for major and recurring incidents. Plan and execute production changes following ITIL Change Management processes. Automate routine DBA activities using T-SQL and PowerShell. Coordinate with Windows, Storage, Backup, Network, Cloud, Security, and Application teams. Engage Microsoft/OEM support for complex technical issues. Provide technical guidance and mentoring to L1/L2 DBAs. Maintain SOPs, runbooks, technical documentation, and knowledge articles.

Skill Requirements

  Install, configure, administer, patch, and upgrade Microsoft SQL Server environments. Manage Production, DR, UAT, and non-production databases. Troubleshoot complex L3 issues including: Blocking and deadlocks High CPU and memory utilization Disk I/O and database performance issues Database corruption Connectivity and availability issues Perform SQL performance tuning, query optimization, execution-plan analysis, and index/statistics maintenance. Manage database backup, restore, recovery, and point-in-time recovery. Configure, administer, and troubleshoot: Always On Availability Groups Failover Cluster Instances Log Shipping SQL Replication where applicable Support database migration, consolidation, refresh, and version-upgrade activities. Manage SQL Server logins, users, roles, permissions, and service accounts. Monitor database growth and perform capacity planning. Manage SQL Server Agent jobs, maintenance tasks, and scheduled activities. Perform SQL Server security hardening, patching, and vulnerability remediation. Troubleshoot application-to-database and infrastructure connectivity issues. Lead technical troubleshooting during P1/P2 incidents. Perform detailed Root Cause Analysis (RCA) for major and recurring incidents. Plan and execute production changes following ITIL Change Management processes. Automate routine DBA activities using T-SQL and PowerShell. Coordinate with Windows, Storage, Backup, Network, Cloud, Security, and Application teams. Engage Microsoft/OEM support for complex technical issues. Provide technical guidance and mentoring to L1/L2 DBAs. Maintain SOPs, runbooks, technical documentation, and knowledge articles.

Other Requirements

  Install, configure, administer, patch, and upgrade Microsoft SQL Server environments. Manage Production, DR, UAT, and non-production databases. Troubleshoot complex L3 issues including: Blocking and deadlocks High CPU and memory utilization Disk I/O and database performance issues Database corruption Connectivity and availability issues Perform SQL performance tuning, query optimization, execution-plan analysis, and index/statistics maintenance. Manage database backup, restore, recovery, and point-in-time recovery. Configure, administer, and troubleshoot: Always On Availability Groups Failover Cluster Instances Log Shipping SQL Replication where applicable Support database migration, consolidation, refresh, and version-upgrade activities. Manage SQL Server logins, users, roles, permissions, and service accounts. Monitor database growth and perform capacity planning. Manage SQL Server Agent jobs, maintenance tasks, and scheduled activities. Perform SQL Server security hardening, patching, and vulnerability remediation. Troubleshoot application-to-database and infrastructure connectivity issues. Lead technical troubleshooting during P1/P2 incidents. Perform detailed Root Cause Analysis (RCA) for major and recurring incidents. Plan and execute production changes following ITIL Change Management processes. Automate routine DBA activities using T-SQL and PowerShell. Coordinate with Windows, Storage, Backup, Network, Cloud, Security, and Application teams. Engage Microsoft/OEM support for complex technical issues. Provide technical guidance and mentoring to L1/L2 DBAs. Maintain SOPs, runbooks, technical documentation, and knowledge articles.