Track Lead (Support & Operations)
India
Job Description
Track Lead (Support & Operations)
Noida, Uttar Pradesh

Job Summary

Job Summary : Should have minimum 6+Yrs experience in SQL Database Administration Responsible for Installation, configuration and migration of SQL server (2012, 2016, 2019 & 2022) Implementing new technologies and design changes whenever required. Implementing Backup/Restoration Strategy Applying patches/upgrades to maintain security level Requirements Good understanding of MS SQL Architecture, File groups, Partitioning, Schemas, Snapshots, Memory etc. SQL Server Database Basic Administration and exposure on Latest Features. Handling of day to day activities Blockings, Long running transaction, Deadlocks etc Troubleshoot issues related to TempDb, Transaction Log and System Databases Instance/Database monitoring/configuring DB Mail/SQL Mail and Alerts & Operators Good knowledge of Index Management & Statistics Good exposure on SSIS, SSRS Knowledge and troubleshooting Issues related to HA (Log shipping, Mirroring, AlwaysOn etc.)

Job Responsibilities : Good understanding of MS SQL Architecture, File groups, Partitioning, Schemas, Snapshots, Memory etc. Good knowledge of Index Management & Statistics Good exposure on SSIS, SSRS .• Good in English communication Good in ITSM Process (Incidents, Change & Problem

Job Description : Scheduling Database Backups, taking Full and Transaction Log Backups. - \\\\r\\\\n Implementing SQL Server Database Security Policy \\\\r\\\\n Experience with Database Migration, Installation, Upgrades and Patching \\\\r\\\\n Experience in T-SQL, PowerShell scripting\\\\r\\\\n Working Knowledge of Cluster \\\\r\\\\n Experience in Performance tuning (Query and Instance level)\\\\r\\\\n Good in English communication\\\\r\\\\n Good in ITSM Process (Incidents, Change & Problem

Key Responsibilities

NA

Skill Requirements

Skill Requirement : Good understanding of MS SQL Architecture, File groups, Partitioning, Schemas, Snapshots, Memory etc. Good knowledge of Index Management & Statistics Good exposure on SSIS, SSRS .• Good in English communication Good in ITSM Process (Incidents, Change & Problem

Other Requirements

Other Requirement : Scheduling Database Backups, taking Full and Transaction Log Backups. - Implementing SQL Server Database Security Policy Experience with Database Migration, Installation, Upgrades and Patching Experience in T-SQL, PowerShell scripting Working Knowledge of Cluster Experience in Performance tuning (Query and Instance level) Good in English communication Good in ITSM Process (Incidents, Change & Problem)

Information at a Glance

Why HCLTech?

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.

HCLTech is a global technology company, home to more than 223,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 June 2026 totaled $14.8 billion.