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@CustomerManage 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 cloudusing: RMANData PumpOCI Database Migration ServiceGoldengate (if applicable)Validate performance and functionality post migration.Support cross region and cross tenancy architectures. High Availability, DR & Resilience Design and manage: OCI Data GuardAutomated backups and recoveryCross region disaster recoveryPerform 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 ConsoleAWR / ADDM / ASHOCI Monitoring & AlarmsOptimize: Storage (block/object)Compute shapesLicensing and resource utilizationImplement cost aware architectures and usage tracking (FinOps).Security, Compliance & Governance Implement cloud security best practices: IAM policiesNetwork 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 scriptingSQL / PL/SQLOCI CLI & SDKTerraform / AnsibleIntegrate 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 architectsDevOps engineersApplication teamsSecurity and compliance teamsProvide 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: RMANData GuardASMRACMultitenant (CDB/PDB)SQL and PL/SQLLinux administrationDatabase performance tuningCloud Specific Skills (Key Differentiators) OCI IAM, networking, and storage conceptsAutonomous Database administrationCloud security and encryptionCost optimization and capacity planning in cloudIaC tools (Terraform preferred)Monitoring and logging in OCIPreferred / Nice to Have Skills Oracle Golden GateExadata Cloud ServiceMulti cloud exposure (AWS RDS/Aurora, Azure SQL concepts)Kubernetes based application understa .