HCL Technologies Ltd logo

Track Lead - AzureMSSQL DBA, Microsoft Azure

    Highlights

    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. HCLTech is a global technology company, home to more than 230,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products.

    Numbers & Facts

    LocationWA
    IndustryComputer/IT Services
    Company Size10,000 employees or more
    Year Founded1991
    Websitehttps://www.hcltech.com/

    Description

    Job Description

    Track Lead - AzureMSSQL DBA, Microsoft Azure

    Noida, Uttar Pradesh

    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.

    Apply now

    Information at a Glance

    Why HCLTech?

    At HCLTech, youll supercharge your potential. Youll find your career. And youll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

    HCLTech is a global technology company, home to more than 230,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending September 2026 totaled $14.8 billion.

    About Company

    Employee Strength : 223,000 on March 31, 2025 
    Countries of Operation : 60 Countries

    Consolidated Revenues: US $13.8B ,for 12 months ending March 2025

    HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering and cloud, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending March 2025 for $13.8 Billion. To learn how we can supercharge progress for you, visit hcltech.com.

    Similar Jobs