> Markdown version of [/jobs/ext/463574-dba-database-migration-engineer](https://www.wearedevelopers.com/jobs/ext/463574-dba-database-migration-engineer). 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). --- # DBA / Database Migration Engineer - **Company:** IT Associates - **Location:** United States (Remote available) - **Contract:** Temporary contract - **Skills:** Amazon Web Services, Business Logic, Architectural Patterns, Batch Processing, Cloud Database, Databases, Data Validation, Extract Transform Load (ETL), Data Migration, Data Structures, IBM DB2, Database Development, Document-Oriented Databases, Job Control Language (JCL), PostgreSQL, Mainframes, Performance Tuning, Query Optimization, SQL Stored Procedures, Test Data, Database Optimization, Database Migration, Cloud Migration, Database Backup, Legacy Systems - **Published:** June 4, 2026 - **Apply:** https://www.dice.com/job-detail/e3663bf5-50de-44b1-b242-1cce572749e1 ## About the Role * Strong experience with DB2, and mainframe-based systems * Proven experience in database migration (DB2 * PostgreSQL or similar) * Hands-on experience with AWS (DMS, SCT, RDS/Aurora PostgreSQL) OR any other cloud migration experience * Solid understanding of data modeling, schema conversion, and ETL processes * Experience with batch processing, large data volumes, and transactional systems ## Description DBA / Database Migration Engineer ( DB2 to PostgreSQL, AWS) - Mainframe Modernization * 6 month contract * 100% Remote * Immediate start * Client has a data Engineer in the team. They want a someone with Mainframe modernization experience - DB2 DBA expertise , PostgreSQL expertise , Cloud migration experience WITH THE GOAL TO do Performance tuning, Data validation, check Migration quality, Scalability and Production readiness, Seeking a hands-on DBA / Database engineer to support a large-scale mainframe modernization initiative involving migration of applications and data from DB2 environments to AWS PostgreSQL. This role requires strong expertise in legacy systems, data migration, and cloud-based database platforms, with the ability to translate mainframe logic into modern architectures, * Analyze and interpret legacy DB2 schemas, stored procedures, triggers, data dependencies and JCL workflows to understand data structures and business logic * Design and support database migration from DB2 to Amazon Aurora PostgreSQL /PostgreSQL in AWS * Support test data creation, extraction, and migration for development, test, UAT, and end-to-end testing cycles. * Collaborate with AWS and system integrator teams to validate functional equivalence between legacy and modernized databases. * Execute data reconciliation, integrity checks, and migration validation across environments. * Support initial data migration dry runs and advise on final production cutover planning and sequencing. * Coordinate database-related troubleshooting during integration, performance, and UAT testing. * Document database migration processes, validation results, triggers, and go-live support procedures. * Analyze and diagnose performance issues in AWS PostgreSQL / Aurora PostgreSQL environments, including slow query identification and execution plan review. * Perform database performance tuning including query optimization, index design and management, and configuration tuning for AWS PostgreSQL workloads. * Manage database backup and restore procedures in AWS environments, including RDS/Aurora snapshot management and point-in-time recovery validation. * Setup and perform database maintenance activities including vacuuming, table statistics updates, bloat management, and database health monitoring in PostgreSQL. * Advise and assist Customer with database development best practices, initial database setup, and configuration in AWS environments. * Work with Customer's mainframe team to coordinate database support needs for legacy testing, ensuring alignment between DB2 source and PostgreSQL target environments. * Work with Customer during Go-Live planning to enable Customer to manage the logistics of data migration to production, including downtime windows, communication planning, cutover sequencing, and rollback procedures. ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Database Magic behind 40 Million operations/s](https://www.wearedevelopers.com/videos/748-database-magic-behind-40-million-operations-s) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Dirty Tests And How To Clean Them](https://www.wearedevelopers.com/videos/515-dirty-tests-and-how-to-clean-them) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Tomorrow's cloud data platforms - fully managed database-as-a-service (DBaaS)](https://www.wearedevelopers.com/videos/254-tomorrow-s-cloud-data-platforms-fully-managed-database-as-a-service-dbaas) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)