Oracle Database Administrator

Oracle Database Reliability Engineer will be supporting mission-critical Oracle database environments across on-prem, Exadata , and multicloud platforms (AWS, Azure, GCP).

Also responsible for driving automation of day-to-day DBA tasks, enabling multi-cloud database operations and migrations, and ensuring cost-effective and secure environments.

The role provides opportunities to work with Oracle PaaS/IaaS services, qualify and adopt new database technologies, and implement CI/CD pipelines to automate deployments.

As part of this role, you will Collaborate with SMEs, Cloud Infrastructure, and Self-Service Enabling teams to bring enhancements and automation to database operations.

Roles & Responsibilities:

Database Reliability Operations:

• Provide day-to-day administration, monitoring, and support for Oracle databases (19c/21c and above).
• Improve service qualification and database lifecycle management through automation at an enterprise scale.
• Ensure compliance with security standards by performing vulnerability scanning, timely patching, and upgrades.
• Work on AI-driven insights to improve observability, reliability, and proactive incident prevention.
• Manage database performance tuning, backup/recovery (RMAN, Data Guard), patching, and upgrades.
• Ensure database availability, resiliency, and security compliance 24/7/365.

Automation & Innovation

• Develop scripts/tools (Python, Shell, Ansible, Terraform, or similar) to automate repetitive DBA tasks (patching, health checks, provisioning, monitoring).
• Implement AIOps practices for proactive issue detection, anomaly detection, and predictive alerting.

Multicloud & Database Modernization

• Support and administer Oracle workloads across on-premises, Exadata Cloud at Customer (ExaCC), and public cloud platforms (OCI, AWS RDS/Aurora, Azure, GCP Cloud).
• Participate in database migrations to cloud (lift-and-shift, re-platforming, or modernization to PDBs/multitenant).
• Assist with database replication, DR solutions, and cross-cloud failover planning.

Collaboration & Continuous Improvement

• Work closely with operations, application, and cloud engineering teams to deliver reliable database services.
• Drive innovation through automation, monitoring, and AI-driven solutions to reduce manual efforts.
• Document best practices, runbooks, and operational procedures.

Required Skills & Experience:

Database Installation & Configuration

• Install, configure, and maintain Oracle Database (12c, 19c, 21c).
• Configure Oracle Grid Infrastructure and ASM (Automatic Storage Management).
• Manage multitenant architecture (CDB/PDB creation, cloning, unplug/plug, consolidation).

User & Security Management

• Create and manage database users, roles, and privileges.
• Implement fine-grained access control, VPD, and Database Vault.
• Knowledge of auditing, TDE (Transparent Data Encryption), and database security best practices.

Backup & Recovery

• Proficient with RMAN for backups, restores, and recovery.
• Implement incremental, full, and image backups.
• Perform point-in-time recovery, tablespace recovery, and cross-platform backups.
• Knowledge of Flashback technologies.

Performance Tuning & Optimization

• Diagnose performance issues using AWR, ASH, ADDM, and SQL Tuning Advisor.
• SQL query tuning and optimizer statistics management.
• Memory management (SGA, PGA tuning).
• Troubleshooting, locking, latching, and wait events.

High Availability (HA)

• Oracle RAC (Real Application Clusters) administration.
• Clusterware installation, configuration, and troubleshooting.
• Oracle ASM disk groups management for RAC and standalone environments.

Disaster Recovery (DR)

• Oracle Data Guard (Physical, Logical, Snapshot standby) configuration and management.
• Active Data Guard for read-only workload offloading.
• Switchover, failover, and role transition testing.
• DR strategy planning and execution in hybrid/multicloud environments.

Patching & Upgrades

• Apply PSU/RU patches, DB upgrades, and patchset installation.
• Experience with Database Migration Assistant (DBUA) and manual upgrade processes.
• Exposure to Exadata patching cycles.

Storage & Space Management

• Tablespace and datafile management.
• Partitioning strategies for large tables.
• Monitoring growth trends and capacity planning.

Monitoring & Troubleshooting

• Proficiency with Oracle Enterprise Manager (OEM/24ai) for monitoring and aler