Oracle Cloud Database Administrator

Oracle DBA Job Summary The Oracle Database Administrator (Cloud) is responsible for managing, securing, and optimizing Oracle databases hosted in cloud and hybrid environments , with a strong focus on Oracle Cloud Infrastructure (OCI) . The role ensures high availability, performance, scalability, security, and cost efficiency of cloud?based database platforms supporting mission?critical applications. Key Responsibilities Cloud Database Administration (OCI?Focused) Provision, configure, and manage Oracle Databases on OCI : Oracle Autonomous Database (ATP/ADW) Database Cloud Service (DBCS) Exadata Cloud Service / Exadata Cloud@Customer Manage Single Instance, RAC, CDB/PDB architectures in cloud environments. Perform database lifecycle management: provisioning, scaling, cloning, patching, and decommissioning. Hybrid & Migration Responsibilities Support hybrid environments (on?prem + OCI). Plan and execute database migrations to the cloud using: RMAN Data Pump OCI Database Migration Service Goldengate (if applicable) Validate performance and functionality post?migration. Support cross?region and cross?tenancy architectures. High Availability, DR & Resilience Design and manage: OCI Data Guard Automated backups and recovery Cross?region disaster recovery Perform recovery testing and DR drills. Ensure compliance with RTO/RPO objectives. Manage rolling upgrades and patching with minimal downtime. Performance & Cost Optimization Monitor and tune databases using: OCI Console AWR / ADDM / ASH OCI Monitoring & Alarms Optimize: Storage (block/object) Compute shapes Licensing and resource utilization Implement cost?aware architectures and usage tracking (FinOps). Security, Compliance & Governance Implement cloud security best practices: IAM policies Network security (VCNs, NSGs, Security Lists) Encryption (TDE, OCI Vault) Manage database access controls, auditing, and separation of duties. Support compliance requirements (ISO, SOX, GDPR, etc.). Perform vulnerability remediation and security hardening. Automation & DevOps Enablement Automate database operations using: Shell scripting SQL / PL/SQL OCI CLI & SDK Terraform / Ansible Integrate database changes into CI/CD pipelines . Support Infrastructure as Code (IaC) for database provisioning. Enable self?service patterns for development teams. Monitoring, Incident & Operations Management Set up proactive monitoring, alerts, and dashboards. Troubleshoot cloud?specific issues (latency, connectivity, scaling). Participate in 24x7 on?call rotations for production support. Perform root cause analysis (RCA) and implement preventive controls. Documentation & Cross?Team Collaboration Maintain cloud architecture diagrams and operational runbooks. Work closely with: Cloud architects DevOps engineers Application teams Security and compliance teams Provide technical guidance and mentoring to junior DBAs. Required Skills & Qualifications Technical Skills Strong hands?on experience with Oracle Database (12c / 18c / 19c / 21c) Proven experience in Oracle Cloud Infrastructure (OCI) Expertise in: RMAN Data Guard ASM RAC Multitenant (CDB/PDB) SQL and PL/SQL Linux administration Database performance tuning Cloud?Specific Skills (Key Differentiators) OCI IAM, networking, and storage concepts Autonomous Database administration Cloud security and encryption Cost optimization and capacity planning in cloud IaC tools (Terraform preferred) Monitoring and logging in OCI Preferred / Nice?to?Have Skills Oracle Golden Gate Exadata Cloud Service Multi?cloud exposure (AWS RDS/Aurora, Azure SQL concepts) Kubernetes?based application understanding ITIL / SRE practices DevSecOps exposure