Role: DB2 DBA (Precisely CDC)
Location: Remote
Duration: Through EOY with potential extension
Start Date: 2 weeks from offer
Interview Process: 1 interview
Job description:
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 SQ Data.
- 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:
- Replication latency
- Missing transactions
- Failed replication
- Connectivity failures
- Capture failures
- Publisher failures
- Apply/target 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:
Never miss an opportunity! Create an alert based on the job you applied for.