Senior Technical Lead - SQL Server
United States
Apply now
Job Description
Senior Technical Lead - SQL Server
Others, Rhode Island

Job Summary

We are seeking a SQL Developer with strong database migration and data processing expertise to support a large-scale Sybase to SQL Server migration program. The role will focus on schema conversion, stored procedure remediation, query optimization, and data validation to ensure a secure, accurate, and high-performance migration.

Key Responsibilities

Analyze and convert database objects (schemas, tables, stored procedures, triggers) from Sybase to SQL Server
Refactor and optimize existing SQL logic to align with SQL Server (T-SQL)
Develop and enhance complex SQL queries, stored procedures, and views
Perform query tuning and performance optimization using indexing and execution plan analysis
Design and execute data validation and reconciliation scripts to ensure data accuracy and integrity
Support large-scale data migration activities, including data extraction, transformation, and loading validation
Collaborate with ETL teams (Informatica) and application teams for seamless data flow and DB integration
Assist in testing phases (SIT, UAT, E2E) including defect analysis and resolution
Troubleshoot and resolve data, performance, and migration-related issues during cutover and post-go-live
Document database changes, migration logic, and dependencies in line with audit and compliance requirements

Skill Requirements

1. Strong Proficiency In Sql Server, Including Database Design, Development, And Optimization Techniques.
2. In-Depth Understanding Of Sql Query Writing, Performance Tuning, And Troubleshooting Complex Database Issues.
3. Solid Knowledge Of Data Modeling, Etl Processes, And Implementing Best Practices In Database Management.
4. Familiarity With Agile Methodologies And Project Management Frameworks.

Other Requirements

Experience in database migration / modernization projects

Experience with Informatica ETL tools
Knowledge of Power BI / reporting queries optimization
Scripting knowledge (Unix/Linux / Python)
Financial services domain experience
Maximum Salary (US):  151000
Minimum Salary (US):  95000
Apply now
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 226,300 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 December 2025 totaled $14.5 billion.

Compensation and Benefits

A candidate’s pay within the range will depend on their skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year.