Senior Data Migration Consultant/Lead; AWS GovCloud Job Austin area,Texas USA,IT/Tech

Position: Senior Data Migration Consultant / Lead (AWS GovCloud)

LTTS US Branch

Austin, Texas

Job Description

Job Description & Skill Requirement:

Position Title:

Senior Data Migration Consultant / Data Migration Lead (AWS Gov Cloud)

Location:

Austin, Texas (Onsite)

Employment Type:

TPC

Project Duration: 9 Months

Job Summary

Seeking an experienced Senior Data Migration Consultant to lead and execute a large-scale enterprise data migration initiative for a government-regulated environment. The consultant will be responsible for designing, developing, and executing secure, repeatable, and auditable migration processes to move data from legacy database platforms (Oracle, SQL Server, or similar technologies) into AWS Gov Cloud-hosted target environments utilizing Amazon RDS for MySQL and/or Amazon RDS for SQL Server while ensuring compliance with stringent security and regulatory requirements.

Key Responsibilities

Migration Strategy & Planning

Analyze source systems and data structures.

Develop comprehensive migration strategies supporting:

Full data loads

Incremental migrations

Delta/CDC-based migration approaches

Create migration plans, rollback procedures, and risk mitigation strategies.

Perform dependency and integration impact analysis.

Data Transformation & Mapping

Develop data transformation specifications based on business requirements.

Create source-to-target mappings at table and column levels.

Define and document

Data transformation rules

Data normalization requirements

Data quality standards

Validation and reconciliation approaches

Migration Development

Design and develop reusable migration scripts using: SQL, T-SQL, PL/SQL

Equivalent database-native scripting languages

Develop

Pre-migration validation scripts

Data readiness assessment scripts

Conflict detection scripts

Migration execution scripts

Reporting and audit scripts

Ensure migration solutions are executable within AWS Gov Cloud environments.

Migration Execution

Execute migration activities across:

Staging environments

Production environments

Support multiple migration cycles for testing, validation, and production cutover.

Analyze migration results and resolve defects.

Perform data reconciliation and validation activities.

Generate migration reports and present findings to stakeholders.

Reporting & Documentation

Produce comprehensive migration documentation.

Maintain audit trails and migration execution records.

Deliver

Data Transformation Specifications

Migration Plans

Migration Scripts Documentation

Migration Execution Reports

Data Validation Reports

Required Qualifications

Education:

Bachelor's degree in computer science, Information Systems, Engineering, or related discipline. Master s degree preferred.

Experience

8+ years of database development and data migration experience.

5+ years of enterprise-scale migration project experience.

Proven experience migrating data from:
Oracle, Microsoft SQL Server, Other enterprise RDBMS platforms

Technical Skills

SQL

T-SQL

PL/SQL

Database migration and ETL development.

Data modeling and data transformation.

Data quality management and reconciliation.

Performance optimization of large-volume data migrations.

Cloud Technologies

Hands-on experience with

AWS Gov Cloud (preferred)

Amazon RDS for MySQL

Amazon RDS for SQL Server

Understanding of cloud security and compliance requirements.

Job Requirement

Key Deliverables

Data Transformation Specifications Document

Scope-Specific Data Migration Plan

SQL-Based Migration Scripts and Documentation

Migration Execution Reports

Data Validation and Reconciliation Reports

Production Cutover Support

/SQL, T-SQL, Data Validation, Data Reconciliation, Cloud Migration, Government Projects.

#J-18808-Ljbffr

Senior Data Migration Consultant​/Lead; AWS GovCloud

Senior Data Migration Consultant/Lead; AWS GovCloud