Oracle Database Administrator

Responsibilities

• Manage large-scale Oracle database estates, including TB-scale Exadata and Exadata Cloud@Customer (ExaCC) environments.
• Administer Oracle Exadata (on-premises) and ExaCC, including infrastructure and VM cluster awareness, database lifecycle operations on ExaCC, and coordination with OCI and Oracle Support for ExaCC incidents.
• Install, administer, patch, migrate, and upgrade Oracle databases across Unix and Windows platforms.
• Design and implement high-availability and disaster-recovery solutions using RAC, Data Guard, and GoldenGate on Exadata and ExaCC platforms.
• Manage ASM/ACFS disk groups across bare-metal, VM-based, Exadata, and ExaCC deployments.
• Perform RMAN backup, restore, refresh, clone, migration, and upgrade operations, including host-to-host, host-to-VM, and Exadata-to-ExaCC migrations.
• Plan and manage patching and lifecycle activities for Oracle databases, Grid Infrastructure, and Exadata/ExaCC platforms.
• Monitor Exadata and ExaCC targets through OEM, including alerting, performance metrics, and capacity tracking.
• Automate tasks with shell and PL/SQL scripts and periodically validate automation effectiveness.
• Track SLAs, prepare reports, and perform capacity planning for Exadata/ExaCC platforms.
• Prepare and maintain audit-ready SOPs for Oracle, Exadata, and ExaCC operations.
• Identify, document, and mitigate technology risks, including ExaCC platform dependencies.
• Mentor L1/L2 DBAs on Oracle, Exadata, and ExaCC operational best practices.

Requirements

• Oracle 11g/12c certification.
• Strong database administration and troubleshooting skills.
• Hands-on experience in a global customer environment.
• Database upgrade and migration experience from on-premises environments to Exadata and ExaCC.
• High-availability RAC setup and administration experience.
• Real-time disaster-recovery design, planning, setup, and administration experience.
• Expertise in database provisioning and decommissioning, including Instance, ASM, RAC, Grid Control, Data Guard, GoldenGate administration, and monitoring tools.
• OEM/OMS administration, monitoring-tool configuration, and management experience.
• Automation through scripting.
• Strong performance analysis experience with AWR, ADDM, SQL Profile, ASH, RAC Check, ExaCheck, and advisory views.
• Experience with OS, storage, network, and virtualization activities related to databases.
• Exadata and ExaCC performance optimization experience.
• Experience managing database estates across various technologies.