SQL Migration Architect W2 only - Hybrid onsite (SQL, TSQL, Refactoring)

Overview

Hybrid
Depends on Experience
Full Time
No Travel Required
Able to Provide Sponsorship

Skills

MySQL
Migration
SQL
Microsoft SSIS
Microsoft SQL Server
Extract
Transform
Load
Database Design
Database
Transact-SQL
Performance Tuning
Database Refactoring
Data Migration
Data Validation
Stored Procedures

Job Details

Note: This is a W2-only opportunity with Virtusa. No third-party agencies or C2C arrangements will be considered. Candidates must be eligible to work directly on Virtusa's payroll. Full benefits provided including matching 401k and/or relocation assistance

Job Title: MS SQL Migration Architect (Hybrid – W2 Only)

Location: Smithfield, RI (Hybrid – Onsite + Remote)
Employment Type: Full-time | W2 Only (No C2C/Third Party)

Job Description:

Virtusa is seeking a highly experienced MS SQL Migration Architect to lead and execute large-scale data migration projects for a major client engagement. This is a hybrid role based in Smithfield, RI, offering flexibility to work both onsite and remotely.

As a key member of the data modernization team, you will assess legacy database infrastructures, define and implement migration strategies, and ensure performance, scalability, and data integrity across environments.

Key Responsibilities:

  • Lead end-to-end data migration efforts to Microsoft SQL Server from platforms such as Oracle, MySQL, PostgreSQL, Access, and flat files

  • Analyze current data systems and create comprehensive, phased migration plans

  • Design, develop, and optimize T-SQL scripts, stored procedures, and database schema structures

  • Utilize SSIS to build robust ETL pipelines and data validation workflows

  • Implement data mapping, transformation, and cleansing strategies

  • Collaborate with application teams, DBAs, and analysts to gather migration requirements

  • Ensure minimal downtime and robust rollback capabilities during transitions

  • Monitor and troubleshoot issues throughout the migration lifecycle

  • Document architecture, strategies, and outcomes

Required Skills & Qualifications:

  • Bachelor’s degree in Computer Science, Information Technology, or related field

  • 15+ years of experience in MS SQL Server development and data migration

  • 10+ years as a SQL Server DBA with deep infrastructure understanding

  • Expertise in T-SQL, database schema design, triggers, views, and performance tuning

  • Proficient with SSIS and other ETL tools

  • Hands-on experience migrating from multiple platforms (Oracle, MySQL, PostgreSQL, Access)

  • Strong troubleshooting, performance optimization, and data governance skills

  • Solid knowledge of rollback and failover strategies

#SQLMigrationArchitect #HybridSQLJob #TSQLExpert #DatabaseRefactoring #SQLPerformance #VirtusaJobs #SeniorTechRole #ETLArchitect #SmithfieldTechJobs #SQLServerTransformation

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.