Be at the heart of actionFly remote-controlled drones into enemy territory to gather vital information.

Apply Now

Data Architect – Mainframe Migration & Modernization

Avance Consulting
Greater London
1 day ago
Create job alert

The Role

As a – Mainframe Data Architect, you will be responsible for moving critical data off the mainframe with zero surprises. Design CDC, land it right, model it right, cut over cleanly.

Your responsibilities:

• Design and implement CDC pipelines using IBM CDC tools or equivalents, including subscription management, bookmarks, and replay strategies.

• Translate Db2 schemas to Aurora PostgreSQL, including logical and physical data modelling, referential integrity, and denormalization decisions.

• Build integration pipelines from Db2 to Aurora via Kafka/S3, ensuring idempotency, ordering, and reliable delivery semantics.

• Handle complex data encoding transformations, such as EBCDIC to UTF-8 and packed decimal conversions, with validation test suites.

• Utilize migration tooling for schema conversion and downstream analytics (Glue, Athena, Redshift), with infrastructure-as-code (Terraform) and CI/CD (GitLab).

• Plan and execute cutovers with dual-run validation, reconciliation, rollback strategies, and data governance controls (masking, encryption, IAM).

• Develop observability dashboards for lag, throughput, error rates, and cost using CloudWatch/Grafana, with operational runbooks and alerting.

• Ensure data quality through pre-migration validation tests and reconciliation against golden sources.

• Apply domain-driven design principles to model bounded contexts and aggregate roots.

• Architect event-driven systems using CDC as event streams, with replay and orchestration patterns

Your Profile

Essential skills/knowledge/experience:

• Change Data Capture: CDC design and operations (IBM, Precisely, or equivalent); subscription management, bookmarks, replay, backfill.

• Db2 & z/OS knowledge: Db2 catalog, z/OS fundamentals, batch windows, performance considerations.

• Relational modelling: PostgreSQL/Aurora data modelling; normalization, indexing, partitioning; OLTP vs. analytics trade-offs.

• Integration patterns: Kafka/ hands-on, CDC-to-target pipelines, UPSERT/MERGE logic; Python/SQL; strong troubleshooting.

• Data quality mindset: Write validation tests before migration; golden-source reconciliation.

• Logical data modelling: Entity-relationship diagrams, normalization (1NF through Boyce-Codd/BCNF), denormalization trade-offs; identify functional dependencies and anomalies.

• Physical data modelling: Table design, partitioning strategies, indexes; SCD types; dimensional vs. transactional schemas; storage patterns for OLTP vs. analytics.

• Normalization & design: Normalize to 3NF/BCNF for transactional systems; understand when to denormalize for queries; trade-offs between 3NF, Data Vault, and star schemas.

• Domain-Driven Design: Bounded contexts and subdomains; aggregates and aggregate roots; entities vs. value objects; repository patterns; ubiquitous language.

• Event-driven architecture: Domain events and contracts; CDC as event streams; idempotency and replay patterns; mapping Db2 transactions to event-driven architectures; saga orchestration.

• CQRS patterns: Command/query separation; event sourcing and state reconstruction; eventual consistency, when CQRS is justified for mainframe migration vs. overkill.

• Database internals: Index structures (B-tree, bitmap, etc.), query planning, partitioning strategies; how Db2 vs. PostgreSQL differ in storage and execution.

• Data quality & validation: Designing test suites for schema conformance; referential integrity checks; sampling and reconciliation strategies.

Desirable skills/knowledge/experience:

• IBM zDIH patterns, zIIP tuning.

• COBOL copybook/VSAM ingestion experience.

Related Jobs

View all jobs

Technical Architect (Data)

Senior Manager, AI & Data Solution Architect, TC UKI

Solution Architect

Solutions Architect

Technical Architect

Senior Solutions Architect

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Cyber Security Recruitment Trends 2025 (UK): What Job Seekers Must Know About Today’s Hiring Process

Summary: UK cyber security hiring has shifted from title‑led CV screens to capability‑driven assessments that emphasise incident readiness, cloud & identity security, detection engineering, governance/risk/compliance (GRC), measurable MTTR/coverage gains & secure‑by‑default engineering. This guide explains what’s changed, what to expect in interviews, & how to prepare—especially for SOC analysts, detection engineers, blue/purple teamers, penetration testers, cloud security engineers, DFIR, AppSec, GRC & security architecture. Who this is for: SOC & detection engineers, security operations leads, DFIR analysts, penetration testers/red teamers, purple teamers, AppSec/DevSecOps engineers, security architects, cloud security engineers, identity/IAM engineers, vulnerability managers, GRC/compliance specialists, product security & security programme managers targeting roles in the UK.

Why Cyber Security Careers in the UK Are Becoming More Multidisciplinary

Cyber security used to be viewed primarily as a technical discipline: firewalls, encryption, intrusion detection, penetration testing. In the UK today, it’s far broader. Organisations now face complex legal frameworks, ethical dilemmas, human-behaviour risks, communication challenges & usability hurdles. This shift means cyber security careers are becoming more multidisciplinary. From protecting NHS patient records to defending financial services, securing supply chains & safeguarding national infrastructure, cyber security now touches every sector. Employers increasingly want professionals who understand law, ethics, psychology, linguistics & design alongside traditional technical skills. In this article, we’ll explore why UK cyber security careers are expanding in this way, how these five disciplines shape the profession, and what job-seekers & employers need to know to thrive in this new landscape.

Cyber Security Team Structures Explained: Who Does What in a Modern Cyber Security Department

Cyber security has become a top priority for UK organisations of all sizes. From small businesses to financial institutions, healthcare providers, and government bodies, the risk of cyber attack is now a constant concern. Threats are more sophisticated, regulations more demanding, and customers more aware of data privacy than ever before. But defending against cyber threats isn’t simply about having the right tools — it’s about having the right team. A modern cyber security department relies on clearly defined roles and responsibilities to ensure that defences are proactive, incidents are managed swiftly, and compliance is maintained. This article explains the structure of a modern cyber security team, the roles you’ll typically find within it, how they collaborate, and what skills, qualifications, and salaries are expected in the UK job market.