DB2 DBA

About the role

The Senior Db2 for z/OS DBA as a Precisely Connect CDC Engineer will spend approximately 30 hours per week working with the Precisely Connect CDC tool (formerly SQData) and the remaining 10 hours on Db2 for z/OS administration. The role involves 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. It requires strong Db2 for z/OS database administration expertise combined with 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.

Responsibilities

• Support, administer, monitor, and troubleshoot Precisely Connect CDC replication solutions.
• Configure and support Db2 for z/OS as a CDC source.
• Start, stop, monitor, and troubleshoot CDC components.
• Troubleshoot replication latency, missing transactions, failed replication, connectivity failures, capture failures, publisher failures, apply/target failures, schema or DDL changes, and data consistency issues.
• Manage CDC configuration when Db2 tables are added, changed, reorganized, or removed.
• Correlate Db2 activity with CDC replication issues.
• Distinguish source Db2 problems, CDC capture problems, publisher/transport problems, and target/apply problems.
• Investigate replication synchronization and data‑consistency issues.
• Understand and apply CDC restart/recovery concepts.

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: change capture, publisher, CDC/transaction storage, replication/distribution, apply processing, source and target configuration.
• Ability to start, stop, monitor, and troubleshoot CDC components.
• Ability to troubleshoot replication latency, missing transactions, failed replication, connectivity failures, capture failures, publisher failures, apply/target failures, schema or DDL changes, and 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, CDC capture problems, publisher/transport problems, and target/apply problems.
• Experience investigating replication synchronization and data‑consistency issues.
• Understanding of CDC restart/recovery concepts.