Oracle Architect

Job Description

Oracle Architect JD
 

Location: London
 

Oracle Architect with extensive experience of Oracle Cloud infrastructure, EBS, Exadata & Goldengate. 
 

Key Responsibilities
 

• Define and manage integration strategies
   
• Collaborate with Leaders to understand business requirements, financial processes, and reporting needs.
   
• Build and customize user interfaces
   
• Develop and maintain PL/SQL scripts, functions, and procedures for financial data processing.
   
• Provide technical direction and mentorship to team members.
   
• Ensure compliance with accounting and audit controls during solution design.
   
• Develop and execute test plans for SIT, UAT, and cutover activities.
   
• Provide post-go-live support and troubleshoot financial integrations and reports.
   

 Required Experience & Skills
 

• Oracle DBA experience with hands‑on expertise in RAC, ASM, and Grid Infrastructure.
   
• Strong expertise in OCI architecture, governance, security, and backup management.
   
• Must have considerable experience in OCI administration including:
   
• VCN, Subnet, FastConnect, IPSEC, Security Lists, NSG, DRG, LPG/RPG, NAT, Service Gateway
   
• Tenancy management, VM creation, Load Balancer setup, backup policies
   
• Deep hands‑on experience managing OCI Object Storage and using it for database/cloud operations.
   
• Experience in database and application migration to OCI.
   
• Ability to integrate Object Storage with RMAN, DataPump, GoldenGate, and PaaS workloads.
   
• Expert in OCI Command Line Interface (CLI) for automation and bulk operations.
   
• Deep experience in Exadata administration (EXACC / EXACS‑D).
   
• Experience in Exadata migration from X7 to X11.
   
• Strong in RMAN, Data Guard, DataPump, and end‑to‑end backup/recovery workflows.
   
• Capable of performing restore, clone, and duplicate operations for database refreshes.
   
• Perform DR drills, failover/switchover, and recovery testing.
   
• Enforce TDE, network encryption, and Vault/KMS key rotation policies.
   
• Proficient in GoldenGate configuration, troubleshooting, and migration activities.
   
• Hands‑on experience in database upgrade/migration to 19c/21c.
   
• Strong SQL and performance tuning skills.
   
• Hands‑on with automation tools — Terraform, Ansible, Shell scripting, and OCI CLI.
   
• Experience with OEM 13c configuration, migration, and OCI Monitoring/APM.
   
• Experience in OEM migration.