DATABASE MIGRATION ENGINEER

Austin, TX, US • Posted 9 hours ago • Updated 9 hours ago
Contract W2
Contract Corp To Corp
Contract Independent
9 Months
Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🤯 Applying directly to the forehead...

Job Details

Skills

  • Amazon RDS
  • Amazon Web Services
  • Auditing
  • Change Data Capture
  • Cloud Computing
  • Cloud Security
  • Computer Science
  • Data Migration
  • Data Modeling
  • Data Quality
  • Data Structure
  • Data Validation
  • Database
  • Database Migration
  • Extract, Transform, Load
  • Information Systems
  • Microsoft SQL Server
  • Migration
  • MySQL
  • Normalization
  • Oracle
  • PL/SQL
  • Performance Tuning
  • RDBMS
  • Regulatory Compliance
  • Reporting
  • Risk Management
  • SQL
  • Scripting
  • Strategic Planning
  • Testing
  • Transact-SQL
  • Impact Analysis
  • Mapping
  • AWS Gov Cloud
  • SQL Server

Summary

• 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 GovCloud-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

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.
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.
  • Dice Id: 90942645
  • Position Id: 9032109
  • Posted 9 hours ago
Contact the job poster
VM

Vinitha Moses

Recruiter @ Vings Technologies
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Austin, Texas

Yesterday

Easy Apply

Third Party, Contract

60 - 62

Austin, Texas

Today

Easy Apply

Contract

Austin, Texas

27d ago

Easy Apply

Contract

Depends on Experience

Austin, Texas

Yesterday

Easy Apply

Contract

80 - 100

Search all similar jobs