Senior Mainframe Db2 DBA – CDC/Replication

Gardner Resources Consulting, LLC; Boston (MA); On-site; USD 140,000 - 190,000; Full time

Job summary

Gardner Resources Consulting, LLC is seeking a Senior Db2 Engineer for a contract assignment in Boston. The role focuses on administering IBM Db2 for z/OS and Precisely Connect CDC, ensuring reliable replication from mainframe to cloud platforms.

You will partner with Mainframe DBA and engineering teams to monitor, troubleshoot, and optimize CDC configurations, handle failures, and maintain data integrity across targets and publishers.

Qualifications

• Strong hands-on experience administering IBM Db2 for z/OS in enterprise production environments.
• Strong hands-on experience with Precisely Connect CDC, formerly SQData.
• Understanding of CDC architecture and concepts including: change capture, publisher, CDC/transaction storage, replication/distribution, apply processing, source and target configuration.

Responsibilities

• Administer, monitor, and troubleshoot Db2 for z/OS and Precisely Connect CDC deployments.
• Collaborate with Mainframe DBA and platform engineering to ensure reliable data movement to cloud platforms.
• Configure and support Db2 z/OS as CDC source and handle start/stop operations, monitoring, and issue resolution.
• Investigate replication issues, including missing transactions, publisher failures, and data consistency problems.

Skills

Db2 for z/OS

Precisely Connect CDC

CDC architecture

Tools

Precisely Connect CDC

Job description

Our client is seeking a Senior Db2 Engineer for a contact assignment.

The Senior Db2 for z/OS DBA as a Precisely Connect CDC Engineer will be responsible for supporting, administering, monitoring, and troubleshooting Precisely Connect CDC replication solutions that replicate data from IBM Db2 for z/OS environments to cloud and distributed data platforms.

The role requires strong Db2 for z/OS database administration expertise combined with an expertise in Change Data Capture, transaction-log-based replication, mainframe infrastructure, security, and cloud integration.

The engineer will partner with Mainframe DBA, application and platform engineering teams to ensure reliable and secure movement of Db2 z/OS data to downstream cloud platforms.

Job Requirements

• Strong hands-on experience administering IBM Db2 for z/OS in enterprise production environments.
• Strong Hands-on experience with Precisely Connect CDC, formerly SQData.

Understanding of CDC architecture and concepts including:

• Change capture
• Publisher
• CDC/transaction storage
• Replication/distribution
• Apply processing
• Source and target configuration
• Experience configuring and supporting Db2 z/OS as a CDC source.
• Ability to start, stop, monitor and troubleshoot CDC components.
• Ability to troubleshoot:
• Missing transactions
• Failed replication
• Connectivity failures
• Publisher failures
• Schema or DDL changes
• Data consistency issues
• Experience managing CDC configuration when Db2 tables are added, changed, reorganized or removed.
• Strong understanding of Db2 for z/OS logging and transaction processing.
• Understanding of commit and rollback behavior.
• Ability to correlate Db2 activity with CDC replication issues.
• Ability to distinguish:
• Source Db2 problems
• Publisher/transport problems
• Target/apply problems
• Experience investigating replication synchronization and data-consistency issues.
• Understanding of CDC restart/recovery concepts.