Track Lead - AzureMSSQL DBA, Microsoft Azure

Technology, Data & Digital · IT Infrastructure & Security · Database Administration

In short

HCLTech is seeking a Track Lead - AzureMSSQL DBA to manage and administer Microsoft SQL Server environments on Microsoft Azure. The role involves installation, configuration, patching, upgrades, troubleshooting complex L3 issues, performance tuning, and automation of DBA activities. This position is based in Noida, Uttar Pradesh, India.

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, and 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, and SQL Replication.
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.

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, and 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, and SQL Replication.
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.

Desired Qualifications

Microsoft SQL Server environments
Microsoft Azure
T-SQL
PowerShell
Always On Availability Groups
Failover Cluster Instances
Log Shipping
SQL Replication
ITIL Change Management processes

Benefits

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

Skills

Microsoft SQL ServerMicrosoft AzureT-SQLPowerShellAlways On Availability GroupsFailover Cluster InstancesLog ShippingSQL ReplicationITIL

#Microsoft SQL Server#Microsoft Azure#Database Administration#Cloud

About HCLTech

Supercharging progress through technology and innovation

HCLTech is a global technology company, home to 219,000+ people across 54 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 September 2022 totaled $12.1 billion. To learn how we can supercharge progress for…

See all open jobs at HCLTech Read more about HCLTech Website