Senior Technical Architect
United States
Apply now
Job Description
Senior Technical Architect
Others, Rhode Island

Job Summary

Lead Sybase ASE discovery, profiling, reverse engineering, and migration assessment activities. Build Sybase dependency inventories, identify dependency chains, assess conversion complexity and remediation effort, use SSMA and AI-augmented discovery accelerators for schema and code analysis, validate AI-generated outputs, support migration planning and data validation activities, and present migration assessments and approaches to client stakeholders.

Key Responsibilities

Lead Sybase ASE discovery, profiling, and reverse engineering of schemas, tables, indexes, views, stored procedures, triggers, functions, jobs, and database-level dependencies.
Own the Sybase to SQL Server migration assessment, including T-SQL compatibility, dynamic SQL, dialect conversion, data-type gaps, and unsupported constructs.
Build Sybase dependency inventory across repositories, including direct application connections, batch jobs, ETL pipelines, reports, and web-service data-access layers.
Identify primary (App → Sybase) and secondary (App → Web Service → Sybase) dependency chains in partnership with the Integration Architect.
Assess conversion complexity, remediation effort, and performance impact across procedures, triggers, and dynamic SQL workloads.
Use SSMA and AI-augmented database discovery accelerators within client's approved LLM environment for schema and code analysis.
Validate AI-generated schema, complexity, and lineage outputs through structured SME reviews.
Sign off on assessment artifacts.
Support data reconciliation, validation strategy, cutover planning, and post-migration data certification design.
Present migration complexity, risk heatmaps, and the Sybase to SQL Server migration approach to senior client stakeholders.

Skill Requirements

Mandatory Skills

Database Discovery and Profiling
Database Reverse Engineering
SQL Server
Sybase ASE
T-SQL Compatibility Analysis
Dynamic SQL Analysis
Dialect Conversion
Data Type Gap Analysis
Dependency Analysis and Inventory Creation
Stored Procedures
Triggers
Functions
SSMA (SQL Server Migration Assistant)
AI-Augmented Database Discovery Accelerators
Schema Analysis
Code Analysis
Data Reconciliation
Validation Strategy
Cutover Planning
Migration Complexity and Impact Assessment

Other Requirements

Experience Requirements

12+ years in database engineering.

Deep hands-on SQL Server experience.
Good hands-on Sybase ASE experience.
Heterogeneous migration experience.

 
Maximum Salary (US):  198000
Minimum Salary (US):  114000
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 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. 

 

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.