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
Key skills
· Mainframe
· AWS Java
· AWS Python
· Data Migration Engineer
o Data (Management Information/MIS): Intermediate
o Data Migration: Advanced
o z/OS Mainframe: Advanced
o Strong Mainframe Background with experience in Data Migration – Preferably DB2
Never miss an opportunity! Create an alert based on the job you applied for.
