Data engineer- DB2

Position: Data Engineer with experience in Migration (DB2

Location – Hybrid (2 Days onsite at nearby Deloitte office)

Georgia - Atlanta, Texas – Austin, Dallas, Houston; Arizona – Gilbert, Phoenix; Florida

Lake Mary, Orlando, Tampa; North Carolina – Charlotte; Massachusetts – Boston.

Contract C2C

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 is 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) using 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