Senior SQL Server Migration Lead (40TB Wave Upgrade)

HCL Technologies Limited

New Jersey

On-site

USD 140,000 - 180,000

Full time

2 days ago

Be an early applicant

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

HCL Technologies Limited in the United States (New Jersey) seeks a Senior SQL Server Migration Lead to drive a multi-wave upgrade of ~40 TB databases from SQL Server 2008/2012 to SQL Server 2022. You will own the migration strategy, assess the existing landscape, and coordinate with ETL and applications teams to ensure zero disruption to operations.

The role requires hands-on upgrade experience across large estates, knowledge of SQL Server architecture, and familiarity with SSRS/Power BI data

Qualifications

Hands-on experience upgrading SQL Server from 2008/2012 to 2022.
Knowledge of collation, storage, SQL Agent, SSIS Catalog, backups, and performance baselining.
Experience with 100+ database estates and wave-based migration planning.
Familiarity with SSRS and Power BI data source repointing (not report development).
Experience with Agile delivery and fixed-price engagements.

Responsibilities

Lead discovery and assessment of the SQL Server landscape (edition, patch level, collation, and job scheduler estate).
Define migration strategy, wave plan, and migration runbook.
Plan and execute migrations across Waves, including partitioning/reorganization.
Coordinate with ETL on connection strings, server references, and config remediation.
Lead production cutover, rollback planning, and post-go-live support.
Maintain risk/dependency register and scale through governance.