Mainframe DB2 Replication Engineer

Description

The company designs, builds, runs and modernizes mission-critical technology systems that people depend on every day.

Clients include Fortune 100 companies.

Responsibilities

• Design, install, configure and maintain DB2 replication across mainframe and distributed platforms.
• Build and run source-to-target replication pipelines.
• Set up capture processes, apply processes and control servers.
• Deploy unidirectional and bidirectional replication, including real-time and near-real-time data synchronization.
• Diagnose and fix data inconsistencies, replication failures, queue backlogs and network interruptions.
• Carry out root cause analysis and put corrective fixes in place.
• Provide L2/L3 support for production incidents.
• Tune replication to reduce latency, use resources efficiently and limit load on source systems.
• Improve data capture efficiency, apply performance and network usage.
• Support integration between DB2 z/OS, DB2 LUW, distributed databases, message queues and ETL platforms.
• Work with DBAs, application teams, and data engineering and BI teams.

Requirements

• Experience with DB2 for z/OS, ZDIH, and MIPS reduction or optimization projects.
• Experience with UNIX system services, including installing patches on UNIX, and UNIX scripting.
• Experience with RACF.
• Hands-on experience with replication technologies such as IBM InfoSphere Data Replication (IIDR) or CDC.
• CDQ Replication experience (preferred).
• Knowledge of replication architecture, data flow design and change data capture concepts.
• Strong troubleshooting skills for data consistency issues and for performance and replication latency.
• Experience with JCL, TSO/ISPF and SDSF.
• Experience with mainframe batch and online environments.
• Familiarity with MQ or messaging systems (preferred).
• Familiarity with ETL and data warehousing platforms (preferred).
• Experience with monitoring tools (preferred).
• Experience with automation using REXX, Python or scripting (preferred).
• Exposure to cloud or hybrid data architectures (preferred).
• Experience with large-scale data migration or modernization programs (preferred).
• Experience with real-time data streaming architectures (preferred).

Conditions

The company does not currently require full COVID-19 vaccination, but client, customer or partner sites may require proof of vaccination under their own policies.

Employees who believe they qualify may request a medical or religious accommodation before employment starts.

The company welcomes people of all cultures, backgrounds and experiences.

Benefits

• Benefits that offer choice and support for you and your family through major life moments, wherever you are.
• Learning programs with access to industry certifications, including Microsoft, Google, Amazon and Skillsoft.
• A company-wide volunteering and giving platform to donate, start fundraisers, volunteer, and search over 2 million non-profit organizations.