Data Migration DB2
Level Required for Primary Skill Expert (14+ years experience - 10+ years of US exp required)
Key skills
Mainframe
AWS Java
AWS Python
Data Migration Engineer
• Data (Management Information/MIS): Intermediate
• Data Migration: Advanced
• IBM z/OS Mainframe: Advanced
• Strong Mainframe Background with experience in Data Migration – Preferably DB2
This a remote role for a Senior level experience in DBA Mainframe Modernization. Highly likely to be extended.
Lead end-to-end database migration projects including DB2 z/OS/VSAM to DB2 LUW, DB2 to cloud-hosted databases (e.g., Db2 on Cloud, Db2 Warehouse), and cross-platform migrations
Assess source database environments, catalog dependencies, and develop comprehensive migration plans with risk mitigation strategies
Execute schema conversion, data extraction, transformation, and loading (ETL) AWS glue or any equivalent tools
Validate data integrity, application compatibility, and performance benchmarks pre- and post-migration
Scheduling and monitoring jobs using control-M
Required Qualifications
14+ years of hands-on experience administering IBM DB2 databases in enterprise environments
Strong expertise in DB2 for z/OS (including utilities such as REORG, RUNSTATS, COPY, RECOVER, LOAD, and UNLOAD)
Experience with automation and scripting using Python, Shell/Bash for DB2 operations
Demonstrated experience with DB2 LUW administration on Linux and/or AIX platforms
Proven track record of leading successful large-scale DB2/VSAM migration or upgrade projects
Proficiency in SQL tuning, EXPLAIN analysis, access path optimization, and performance diagnostics
Experience with DB2 high availability and disaster recovery solutions (HADR)
Working knowledge of JCL, REXX, and TSO/ISPF in mainframe environments
Familiarity with IBM Data Studio or any IBM Db2 Administration Tool
Never miss an opportunity! Create an alert based on the job you applied for.
