DB2 Replication Engineer Administrator

IPolarity LLC; Whippany (NJ); On-site; USD 110,000 - 150,000; Full time

Job summary

IPolarity LLC is seeking a DB2 Replication Engineer to design, install, and support IBM IIDR/CDC replication across DB2 z/OS and distributed environments. You will configure capture, apply, and control processes and troubleshoot issues to ensure real-time synchronization.

The role emphasizes performance tuning, disaster recovery testing, and integration with MQ/ETL platforms. Knowledge of Q Replication is preferred; located in NJ/Plano/US locations with potential travel.

Qualifications

• DB2 for z/OS expertise.
• IIDR/CDC real-time replication experience.
• Q Replication knowledge (preferred).
• ZDIH familiarity.
• UNIX administration and scripting.
• RACF access control.
• JCL, TSO/ISPF, SDSF.
• Replication architecture and performance tuning.
• Experience with MIPS optimization initiatives.

Responsibilities

• Design, install, configure, and support DB2 replication solutions across DB2 z/OS and distributed environments.
• Implement and maintain IBM CDC (IIDR) and Q Replication for real-time and near-real-time data synchronization.
• Configure and manage replication components including Capture, Apply, and Control processes.
• Troubleshoot replication failures, data inconsistencies, latency issues, queue backlogs, and connectivity problems.
• Perform performance tuning to optimize replication throughput, reduce latency, and minimize source system impact.
• Support integration with DB2 LUW, MQ, ETL platforms, and distributed databases.
• Provide L2/L3 production support, root cause analysis, and disaster recovery testing.

Skills

DB2 for z/OS

IIDR / CDC

Q Replication

ZDIH

UNIX administration

RACF

JCL/TSO/ISPF

SDSF

Replication architecture

Performance tuning

MIPS optimization

Job description

In addition to Phoenix, AZ, candidates may be considered for the following alternative locations: Plano, TX; Charlotte, NC; Richmond, VA; Jacksonville Beach, FL; Pennington, NJ; and Chicago, IL.

Key Responsibilities

• Design, install, configure, and support DB2 replication solutions across DB2 z/OS and distributed environments.
• Implement and maintain IBM CDC (IIDR) and Q Replication for real-time and near-real-time data synchronization.
• Configure and manage replication components including Capture, Apply, and Control processes.
• Troubleshoot replication failures, data inconsistencies, latency issues, queue backlogs, and connectivity problems.
• Perform performance tuning to optimize replication throughput, reduce latency, and minimize source system impact.
• Support integration with DB2 LUW, MQ, ETL platforms, and distributed databases.
• Provide L2/L3 production support, root cause analysis, and disaster recovery testing.

Required Skills

• DB2 for z/OS
• IBM InfoSphere Data Replication (IIDR) / CDC
• Q Replication (preferred)
• ZDIH
• UNIX administration and scripting
• RACF
• JCL, TSO/ISPF, SDSF
• Replication architecture, CDC concepts, and performance tuning
• Experience with MIPS optimization/reduction initiatives

Preferred Skills

• MQ / Messaging Systems
• REXX, Python, Shell Scripting
• Monitoring tools (OMEGAMON, MainView, etc.)
• ETL/Data Warehousing
• Cloud/Hybrid Data Architectures
• Data Migration & Modernization Programs
• Real-Time Data Streaming Solutions

Suggested Job Titles

• DB2 Replication Engineer
• DB2 Replication Administrator
• Q Replication Engineer
• IBM CDC Administrator
• IIDR Specialist
• Mainframe Data Replication Engineer