Senior Data Migration Engineer

CSI Companies is a leading workforce solutions provider specializing in IT, Healthcare, and Finance & Accounting staffing. They are seeking a Senior Data Migration Engineer with expertise in DB2 and mainframe modernization to lead large-scale database transformation initiatives, focusing on end-to-end migrations from legacy systems to modern platforms.

Responsibilities:

• Lead end-to-end database migration projects including DB2 z/OS and VSAM to DB2 LUW and cloud-hosted platforms (Db2 on Cloud, Db2 Warehouse)
• Assess existing database environments, analyze dependencies, and build detailed migration strategies with risk mitigation plans
• Execute schema conversions and perform data extraction, transformation, and loading (ETL) using AWS Glue or similar tools
• Validate data integrity, application compatibility, and performance benchmarks before and after migrations
• Monitor and manage batch processing and job scheduling using Control-M
• Optimize database performance through SQL tuning, access path analysis, and diagnostics
• Collaborate with cross-functional teams to ensure successful migration delivery and minimal disruption

Requirements:

• 8+ 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 leading large-scale DB2 or VSAM migration or upgrade initiatives
• Proficiency in SQL tuning, EXPLAIN analysis, and performance optimization
• Experience administering DB2 LUW on Linux and/or AIX platforms
• Strong scripting and automation experience using Python and/or Shell/Bash
• Experience with DB2 high availability and disaster recovery (HADR) solutions
• Working knowledge of JCL, REXX, and TSO/ISPF in mainframe environments
• Experience with IBM Data Studio or Db2 Administration tools
• Familiarity with cloud database platforms and modernization strategies
• Strong background in enterprise data migration initiatives