Senior Oracle Applications & Database Administrator

We are looking for an experienced Oracle Apps & Core DBA with around 7 years of hands-on experience managing, maintaining, and troubleshooting mission-critical enterprise database environments and Oracle E-Business Suite (EBS) applications.

The ideal candidate has a strong command of Core Oracle Database Administration (26ai/19c/12c), deep expertise in Oracle E-Business Suite R12.2 administration, and a working/foundational understanding of Oracle EPM (Enterprise Performance Management) and EDM (Enterprise Data Management) architectures and integrations.

Position Overview:

Oracle EBS, Core Database, and Integrations across production and non-production enterprise tiers.

Key Responsibilities:

• Manage, maintain, and support Oracle E-Business Suite R12.2 / R12.1 environments across non-production and production tiers.
• Perform application patching using ADOP (Online Patching), AD Administration utilities, and AutoConfig.
• Execute regular database and EBS application cloning (Rapid Clone, dual-node/multi-node architectures).
• Administer, tune, and troubleshoot Concurrent Managers, Concurrent Programs, and batch schedules.
• Manage Oracle Fusion Middleware / WebLogic Server (WLS) domains, Node Managers, and managed servers powering EBS R12.2.
• Handle EBS security, user access, printer setups, and workflow configuration.
• Administer, install, configure, and upgrade Oracle Databases (12c, 19c, 26ai; standalone, Multitenant CDB/PDB).
• Configure and maintain Oracle Real Application Clusters (RAC) and Oracle ASM (Automatic Storage Management).
• Implement and manage disaster recovery (DR) solutions using Oracle Data Guard / Active Data Guard, handling failover and switchover drills.
• Design and automate robust backup and recovery strategies using RMAN, cold/hot backups, and export/import (Data Pump).
• Conduct database performance tuning: proactive analysis using AWR, ADDM, ASH, execution plan analysis, SQL tuning, and wait event resolution.
• Maintain OS-level database environments primarily running on Linux/Unix, writing shell scripts to automate routine DBA maintenance tasks.
• Possess a basic/foundational understanding of OIC architecture, integration design patterns, and connectivity models.
• Install, configure, and maintain the OIC Connectivity Agent on on-premises/cloud Linux servers to bridge Oracle EBS/Database with cloud integrations.
• Monitor integration health, database adapters, and connection pools; troubleshoot connectivity timeouts, network access (firewalls/ports), and payload failures impacting the database or EBS.
• Understand foundational architecture and data pipelines across Oracle EPM Cloud (Planning, Financial Consolidation) and Oracle EDM Cloud (Enterprise Data Management / Master Data Governance).
• Support database touchpoints, staging schemas, and automated loads (e.g., EPM Automate) connecting EBS General Ledger/financial data to EPM and EDM hierarchies.
• Collaborate with functional and technical teams to diagnose and resolve integration bottlenecks, interface errors, and connectivity drops across EBS, OIC, EPM, and EDM.
• Monitor database health, uptime, and performance metrics using Oracle Enterprise Manager (OEM / Cloud Control 13c).
• Apply quarterly database security patches (CPU/PSU/RU) and EBS security patches.
• Enforce database security standards: auditing, role-based access, transparent data encryption (TDE), and SSL/TLS setups.
• Participate in 24/7 on-call rotational support and provide Root Cause Analysis (RCA) for critical incidents.

Required Skills & Qualifications:

• Experience: Minimum 6-8 years (ideally around 7 years) of dedicated experience as an Oracle Core & Apps DBA.
• In-depth expertise in Oracle 19c/12c/26ai architecture, Multitenant (CDB/PDB).
• Hands-on experience with RAC, ASM, and Active Data Guard.
• Strong mastery of RMAN, Data Pump, and backup validation techniques.
• Proven track record in performance tuning (AWR, ASH, SQL profiles, baseline management).
• Extensive experience in Oracle EBS R12.2 deployment, administration, and patching via ADOP.
• Experience managing and troubleshooting Oracle WebLogic Server administration for EBS.
• Strong skills in Rapid Clone and multi-tier architecture configurations.
• Basic understanding of Oracle Integration Cloud (OIC): OIC Connectivity Agent setup/management, Oracle DB / EBS adapters, and integration monitoring.
• Foundational knowledge of Oracle EPM & EDM Cloud concepts (hierarchies, dimensions, CoAs, integration touchpoints with EBS).
• Proficiency in Linux/Unix command-line utilities, storage layout, kernel parameter configuration.
• Practical experience in Bash/Shell scripting for DBA task automation.

Preferred / Good To Have:

• Experience with OCI (Oracle Cloud Infrastructure), AWS, or Azure database hosting and migrations (e.g., EBS on OCI / DBCS / ExaCS).
• Working knowledge of infrastructure automation tools such as Ansible, Terraform, or Python.

Relevant Certifications:

• Oracle Certified Professional (OCP) - Database Administrator
• Oracle E-Business Suite System Administrator / Apps DBA Certification
• Oracle Cloud Infrastructure (OCI) Foundations / Architect Associate
• Oracle Cloud Platform Enterprise Integration Specialist (OIC Foundations)

Skills

Administrator, DBA, E-Business Suite, EBS, Oracle, Oracle Database