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 handson 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 handson 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 / EXACSD).
  
• Experience in Exadata migration from X7 to X11.
  
• Strong in RMAN Data Guard DataPump and endtoend 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.
  
• Handson experience in database upgrade/migration to 19c/21c.
  
• Strong SQL and performance tuning skills.
  
• Handson with automation tools Terraform Ansible Shell scripting and OCI CLI.
  
• Experience with OEM 13c configuration migration and OCI Monitoring/APM.
  
• Experience in OEM migration.