Overview
We are seeking an experienced Data Integration Solution Architect to design and implementing a secure, scalable data integration solution to replicate a Legacy Oracle DW data feeds using HVR technology within Oracle Cloud Infrastructure (OCI).
This role sits at the intersection of data architecture, cloud engineering, and security governance, ensuring that data can be reliably transferred from source systems through the gateway into a newly designed OCI landing zone.
Key responsibilities
- Design and deliver HVR-based data integration architecture replicating the Legacy feed for SDW1, to an SDW2 landing zone
- Produce High-Level and Low-Level Designs for Data Integration aspects of the solution
- Support the OCI architect to define and implement secure landing zone architecture (OCI storage, DB, networking)
- Configure and deploy HVR target agent in OCI aligned to SDW1 setup
- Analyse data volumes, frequency, retention, and life cycle requirements
- Develop cost, capacity, and volumetric forecasts (HVR licensing, storage, infrastructure)
- Lead governance and approvals (SbD, DEAB, SOC) and prepare ATT evidence packs
- Support network connectivity enablement (eg, gateway changes, CRs)
- Oversee system testing of landing zone and integration components
- Collaborate with BDUK and stakeholders to ensure integration readiness
Key Skills and Experience
- Strong experience with Data Integration Solutions (data replication and ingestion tools)
- Proven expertise in cloud data architecture, ideally in Oracle Cloud Infrastructure (OCI)
- Experience designing data landing zones and ingestion pipelines
- Knowledge of data modelling, storage, and life cycle management
- Experience producing HLD and LLD documentation
- Understanding of secure data transfer, encryption, and network architecture
- Experience working in regulated or secure environments with governance processes
- Strong stakeholder communication and documentation skills
- Experience with defence, or government environments
- Familiarity with SbD, DEAB (AtT), SOC approvals
- Hands-on experience with Oracle Database, OCI Object Storage, and networking
- Knowledge of OCI Data Integration or Oracle AI Data Platform (AIDP)
- Experience supporting large-scale data migration or transformation programmes
- Prior experience working with BDUK or similar defence partners
Clearance: SC (at least BPSS to start and eligible to apply for MOD SC)
Travel
Hybrid role, predominantly remote, but some travel to Client site will be required (estimate routinely up to 1 day per week to London and/or the South/South East eg Bristol, with occasional multi-day workshops/meetings).