TELECOMMUTE Data Migration DB2

Rapisource LLC

United States

2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Working hours

Regular working hours

Job source

dice.com

Tech stack

Java (Programming Language) IBM AIX Amazon Web Services Bash Shell Cloud Computing Databases Data Integrity Extract Transform Load (ETL) Data Migration Data Mining IBM DB2 Linux

+12 more

Disaster Recovery Job Control Language (JCL) Rexx (Programming Language) Python (Programming Language) Mainframes Virtual Storage Access Methods Z/OS Tso/ispf System Availability Database Migration AWS Glue Control M

Requirements

Level Required for Primary Skill Expert (14+ years experience - 10+ years of US exp required)

Key skills

Mainframe

AWS Java, * 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)