DB2 Administrator

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 RequirementsStrong 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 capturePublisherCDC/transaction storageReplication/distributionApply processingSource and target configurationExperience configuring and supporting Db2 z/OS as a CDC source.Ability to start, stop, monitor and troubleshoot CDC components.Ability to troubleshoot:Replication latencyMissing transactionsFailed replicationConnectivity failuresCapture failuresPublisher failuresApply/target failuresSchema or DDL changesData consistency issuesExperience 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 problemsCDC capture problemsPublisher/transport problemsTarget/apply problemsExperience investigating replication synchronization and data-consistency issues.Understanding of CDC restart/recovery concepts.