Database Architect

About the Company

Mainframe DB2 Data Architect with deep expertise in logbased Change Data Capture, real-time data replication, and hybrid cloud data modernization, specializing in nonintrusive CDC designs using IBM and thirdparty tools.

About the Role

Database Migration Schema transformation of DB2/VSAM /IMS into target relational models (Oracle, PostgreSQL, SQL Server, Azure SQL) including DDL/index/view generation and VSAM field/key rationalization to normalized structures.

Responsibilities

• Data migration & reconciliation: export legacy data, scrub/mask as required, import to target, and perform roundtrip equivalence using checksums/recordlevelcomparisons; maintain referential integrity across environments.
• Data Architecture & Modelling Tools: Data integrity and balance accuracy with documented reconciliation packs for customer signoff.
• Co-existence and CDC (Sync-back to Mainframe): Experience of CDC Fundamentals, DB2-specific CDC design, High-availability CDC architectures (active-active, restartability), Log scraping and capture agents (non-intrusive CDC).

Qualifications

• CDC Tools & Products (Hands-on Expectations):
• IBM InfoSphere Data Replication (IIDR) / CDC
• IBM Db2 Data Gate for z/OS
• IBM Analytics Accelerator (CDC feeds to analytics)
• Informatica PowerExchange CDC for DB2 z/OS
• Precisely / Syncsort CDC
• Oracle GoldenGate (architectural comparison skill)
• Qlik Replicate (CDC pipelines)

Required Skills

• Integration & Modernization Skills: Integration with cloud-native analytics and BI.
• API and event-driven patterns built on CDC streams.
• Mainframe-to-cloud parallel-run migration strategies.
• Coexistence of ETL + CDC architectures.

Preferred Skills

• Experience with various CDC tools and architectures.

Pay range and compensation package

[Pay range or salary or compensation]

Equal Opportunity Statement

[Include a statement on commitment to diversity and inclusivity.]