Mainframe DB2 CDC Database Administrator

Job Summary

In this role, you will play a key part in administering and supporting Mainframe DB2 and CDC environments, managing database operations, configuring and maintaining CDC replication solutions, ensuring data integrity, optimizing system performance, troubleshooting replication issues, and supporting high-availability data replication across enterprise platforms.

Responsibilities

• Administer and support IBM Db2 for z/OS databases in a large-scale mainframe environment.
• Configure, monitor, and maintain CDC (Change Data Capture) replication solutions to enable real-time data movement across platforms.
• Ensure data integrity, consistency, and availability throughout replication and database operations.
• Monitor and optimize Db2 and CDC performance, identifying and resolving system bottlenecks and replication latency issues.
• Troubleshoot and resolve database, replication, and connectivity incidents to meet service level objectives.
• Perform database maintenance activities, including backup, recovery, migration, upgrades, and patch management.
• Support high availability and disaster recovery strategies for mission-critical Db2 environments.

Who You Are

You're good at what you do and possess the required experience to prove it. However, equally as important - you have a growth mindset; keen to drive your own personal and professional development. You are customer-focused - someone who prioritizes customer success in their work. And finally, you're open and borderless - naturally inclusive in how you work with others.

Required Technical and Professional Expertise

• 8+ years of experience in administering and supporting Mainframe z/OS, IBM DB2, and IMS databases, including database structure administration, utility management, performance optimization, and database maintenance activities across enterprise environments.
• Analyze and troubleshoot IMS and DB2 batch job failures, ensuring timely resolution and root cause identification.
• Perform DB2 and IMS structure backfill, database refreshes, and recovery activities across non-production and production environments.
• Execute tablespace and index reorganizations, space reclamation, performance tuning, and capacity management initiatives.
• Review and optimize SQL queries and access paths, improving database performance and reducing resource consumption.
• Create and manage change tickets, supporting end-to-end implementation from development through production deployment.
• Monitor DB2/IMS health check jobs, tablespace status, database objects, and perform object alterations using DB2 commands as required.
• Support IMS administration activities including DBD changes, ACBGEN, DELGEN, AUTOGEN, DBRC registration, backup/recovery, reporting, documentation, and knowledge transfer initiatives.

Preferred Technical and Professional Experience

• 3+ years of experience in MF DB2 CDC Database Administration with expertise in IBM IIDR/Change Data Capture (CDC), replication monitoring, subscription management, and troubleshooting replication issues.
• Hands-on experience in monitoring and maintaining CDA subscriptions, performing subscription refreshes, schema modifications, and ensuring seamless data synchronization between source and target databases.
• Proficient in creating replication SQLs for DB2 tables, managing TOAD Oracle environments, and developing IMS structural queries for Kafka-based data replication.
• Strong Enterprise Linux administration skills with proven ability to create and maintain technical documentation for installations, upgrades, operational procedures, and support processes.
• Excellent analytical, problem-solving, and communication skills with the ability to logically diagnose and resolve complex replication and database-related issues.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.