> Markdown version of [/jobs/ext/1813317-senior-data-migration-consultant](https://www.wearedevelopers.com/jobs/ext/1813317-senior-data-migration-consultant). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data Migration Consultant - **Company:** Pi-Square Technologies LLC - **Location:** Austin, TX, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Legacy Database, .NET Framework, Amazon Web Services, Audit Trail, Cloud Computing, Cloud Computing Security, Information Systems, Databases, Data Validation, Extract Transform Load (ETL), Data Transformation, Data Migration, Data Normalization, Data Structures, Data Warehousing, Relational Databases, Database Development, Microsoft SQL Server, MySQL, Oracle (Applications), Performance Tuning, Migration Manager, Standard Sql, PL-SQL, SQL Databases, SQL Server Integration Services, SQL Server Analysis Services, Transact-SQL, Enterprise Data Management, Scripting, Change Data Capture, Data Strategy, Database Migration, Amazon Relational Database Service, Information Technology - **Published:** July 18, 2026 - **Apply:** https://www.careerjet.com/jobad/usc49a8833e48107c386f34e290ccbf295 ## About the Role * 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 GovCloud (preferred) * Amazon RDS for MySQL * Amazon RDS for SQL Server * Understanding of cloud security and compliance requirements. * Preferred Qualifications * AWS Certification (Solutions Architect, Database Specialty, or equivalent). * Experience supporting government, defense, or regulated industry environments. * Knowledge of Change Data Capture (CDC) methodologies. * Experience handling high-volume data migration programs. * Security & Compliance Requirements (Mandatory) * Citizenship Requirement: Must be a U.S. Citizen. * Dual citizenship is not acceptable. * Must be eligible to work on systems subject to U.S. government regulatory controls. * Ability to successfully pass required background investigations. * 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 ## Description 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 * 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 GovCloud 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, Senior SSIS/SSAS Data Warehouse Developer Primary Skills: SSIS, SSAS, SQL Server 20192022, Data Warehouse Development, Microsoft .NET, ETL Development, SQL Server Secondary Sk… + 14 days ago + Apply easily, Enterprise Data Architect (Data Management Strategy & Data Warehouse Modernization) Total Required Experience in Years: 18+ Years Mode of Work: Hybrid (3Days Onsite / 2 Days Re… + 14 days ago + Apply easily + ## Related Videos - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [AWS Migration within 3 months](https://www.wearedevelopers.com/videos/196-aws-migration-within-3-months) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [The Migration Cookbook](https://www.wearedevelopers.com/videos/100164-the-migration-cookbook) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [System change: restart as developer?](https://www.wearedevelopers.com/magazine/39-system-change-restart-as-developer) - [The Best Job Search Websites of 2025](https://www.wearedevelopers.com/magazine/368-the-best-job-search-websites-of-2025)