DB2 DBA

* Must be authorized to work in the U.S. without sponsorship. NO 3rd-party agencies *

Senior Db2 DBA – Precisely Connect CDC

Location: Remote Contract: 3+ months, with potential for longer-term opportunity Schedule: Full-time, up to 40 hours/week Start: ASAP On-Call: Occasional on-call and weekend support required Interview: One interview with the hiring manager and technical team

Position Overview

We are seeking an experienced Senior Db2 for z/OS DBA / Precisely Connect CDC Engineer to support, administer, monitor, and troubleshoot enterprise data replication environments.

This role is approximately 80% Precisely Connect CDC and 20% traditional Db2 for z/OS DBA. The ideal candidate will have strong hands-on experience with Precisely Connect CDC (formerly SQData) and IBM Db2 for z/OS in a production environment.

Key Responsibilities

Administer and support IBM Db2 for z/OS in enterprise production environments.

Manage Precisely Connect CDC configuration, monitoring, troubleshooting, performance, and maintenance.

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, capture, publisher, and apply/target issues.

Manage CDC configuration for Db2 table additions, changes, reorganizations, and removals.

Investigate schema/DDL changes, synchronization, and data consistency issues.

Support CDC restart and recovery activities.

Analyze Db2 logging, transaction processing, commit/rollback behavior, and CDC activity to identify root causes.

Distinguish between source Db2, CDC capture, publisher/transport, and target/apply issues.

Collaborate with DBA, mainframe, application, platform, and engineering teams.

Support production incidents, including occasional on-call and weekend coverage.

Required Qualifications

Strong hands-on IBM Db2 for z/OS DBA experience in enterprise production environments.

Strong hands-on experience with Precisely Connect CDC (formerly SQData).

Strong understanding of Change Data Capture (CDC) architecture, including:

Change capture

Publisher

CDC/transaction storage

Replication/distribution

Apply processing

Source and target configuration

Experience configuring and supporting Db2 for z/OS as a CDC source.

Strong understanding of Db2 logging and transaction processing.

Understanding of commit and rollback behavior.

Proven ability to troubleshoot complex replication issues and data consistency problems.

Understanding of CDC restart/recovery concepts.

Strong analytical, troubleshooting, communication, and collaboration skills.

Ability to work independently in a production environment.

Additional Requirements

Must be available for occasional on-call and weekend support.

Ability to work up to 40 hours per week.

Must be able to work in the U.S. without sponsorship.

Ability to start ASAP is strongly preferred.

Ideal Candidate

The ideal candidate is a hands-on senior engineer with substantial production experience managing Precisely Connect CDC replication and the Db2 for z/OS expertise needed to troubleshoot issues across the entire replication pipeline.

If you have strong Db2 z/OS + Precisely Connect CDC experience and enjoy solving complex replication and data movement problems, we'd like to hear from you.