DB2 Administrator Job at Beacon Hill, Chicago, IL

  • Beacon Hill
  • Chicago, IL

Job Description

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 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:
  • 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:
  • Source Db2 problems
  • CDC capture problems
  • Publisher/transport problems
  • Target/apply problems
  • Experience investigating replication synchronization and data-consistency issues.
  • Understanding of CDC restart/recovery concepts.

Job Tags

Full time

Similar Jobs

Piedmont Healthcare

Medical Physicist Job at Piedmont Healthcare

Piedmont Healthcare is seeking a Medical Physicist to support safe, accurate radiation therapy within our patient-centered, collaborative care network. In this role, you will perform treatment planning support, dosimetry, and quality assurance for LINACs and imaging systems... 

Beacon Hill Staffing Group

Executive Assistant Job at Beacon Hill Staffing Group

 ...personal out-of-pocket and corporate card charges using Concur online expense tool. Produce general correspondence, reports, and presentations...  .... Performs additional responsibilities as assigned. Teamwork/Service Orientation: Demonstrates the ability to work... 

Geisinger

Nurse Practitioner or Physician Assistant ConvenientCare Job at Geisinger

 ...Job Summary Geisinger ConvenientCare is seeking an experienced Nurse Practitioner or Physician Assistant to join our urgent care team in Berwick, PA. Job Duties Geisinger ConvenientCare (urgent care) clinicians diagnose and treat common medical problems including... 

Heritage Resource Group

Digital Marketing Coordinator Job at Heritage Resource Group

 ...provides operational and consulting support to senior living communities across the nation. Our Corporate Marketing Department helps each community strengthen its digital presence, generate qualified leads, and support occupancy and revenue growth through measurable... 

Staff Management SMX

Warehouse Order Picker Job at Staff Management SMX

 ...helping deliver essential products to customers every day.Perks & Benefits: Casual Dress Code, Weekly paychecks, Direct Deposit or Cash Card pay options, Medical / Dental Insurance.Shifts: 1st Shift, 2nd Shift, 3rd Shift. Employment Types: Full Time. Pay Rate: $15.70 - $20...