Software Engineer II - Oracle Apps & Core DBA

Senior Oracle Applications & Database Administrator

Position Overview

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.

Key Responsibilities 1. Oracle Apps DBA Administration (E-Business Suite)

- 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.

2. Core Oracle Database Administration

- 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.

3. Oracle EPM, EDM and OIC (Basic / Foundational Exposure)

- 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.

4. Monitoring, Security & Compliance

- 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.

Core 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).

Apps DBA

- 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.

OIC, EPM & EDM Exposure

- 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).

OS & Scripting

- 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)