Senior Data Migration Consultant

• Location: Austin, Texas (Onsite)
• Project Duration: 9 Months+ Contract

Job Summary: 

Key Responsibilities 

1. Migration Strategy & Planning
2. Analyze source systems and data structures.
3. Develop comprehensive migration strategies supporting:
4. Full data loads
5. Incremental migrations
6. Delta/CDC-based migration approaches
7. Create migration plans, rollback procedures, and risk mitigation strategies.
8. Perform dependency and integration impact analysis.
9. Data Transformation & Mapping
10. Develop data transformation specifications based on business requirements.
11. Create source-to-target mappings at table and column levels.

Define and document: 

1. Data transformation rules
2. Data normalization requirements
3. Data quality standards
4. Validation and reconciliation approaches

Migration Development 

1. Design and develop reusable migration scripts using: SQL, T-SQL, PL/SQL
2. Equivalent database-native scripting languages

Develop: 

1. Pre-migration validation scripts
2. Data readiness assessment scripts
3. Conflict detection scripts
4. Migration execution scripts
5. Reporting and audit scripts

Ensure migration solutions are executable within AWS GovCloud environments. 

1. Migration Execution
2. Execute migration activities across:
3. Staging environments
4. Production environments
5. Support multiple migration cycles for testing, validation, and production cutover.
6. Analyze migration results and resolve defects.
7. Perform data reconciliation and validation activities.
8. Generate migration reports and present findings to stakeholders.

Reporting & Documentation 

1. Produce comprehensive migration documentation.
2. Maintain audit trails and migration execution records.

Deliver: 

1. Data Transformation Specifications
2. Migration Plans
3. Migration Scripts Documentation
4. Migration Execution Reports
5. Data Validation Reports

Required Qualifications 

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

Experience 

2. 8+ years of database development and data migration experience.
3. 5+ years of enterprise-scale migration project experience.
4. Proven experience migrating data from: Oracle, Microsoft SQL Server, Other enterprise RDBMS platforms

Technical Skills 

1. SQL
2. T-SQL
3. PL/SQL
4. Database migration and ETL development.
5. Data modeling and data transformation.
6. Data quality management and reconciliation.
7. Performance optimization of large-volume data migrations.
8. Cloud Technologies

Hands-on experience with: 

1. AWS GovCloud (preferred)
2. Amazon RDS for MySQL
3. Amazon RDS for SQL Server
4. Understanding of cloud security and compliance requirements.

Preferred Qualifications 

1. AWS Certification (Solutions Architect, Database Specialty, or equivalent).
2. Experience supporting government, defense, or regulated industry environments.
3. Knowledge of Change Data Capture (CDC) methodologies.
4. Experience handling high-volume data migration programs.

Key Deliverables 

1. Data Transformation Specifications Document
2. Scope-Specific Data Migration Plan
3. SQL-Based Migration Scripts and Documentation
4. Migration Execution Reports
5. Data Validation and Reconciliation Reports
6. Production Cutover Support