Oracle Architect

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.