05 Nov
|
7-Eleven Global Solution Center – India
|
Bengaluru
05 Nov
7-Eleven Global Solution Center – India
Bengaluru
Role Description
Oracle Apps &
- Core DBA
Senior Oracle Applications &
- Database Administrator
JOB TITLE
Senior Oracle Applications &
- Database Administrator (Apps &
- Core DBA)
ROLE FOCUS
Oracle EBS
- Core Database
- Integrations
Experience Level 7+ Years
ENVIRONMENT
Production & non-production enterprise tiers
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.
- 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.
- Oracle EPM, EDM and OIC (Basic / Foundational Exposure)
Oracle Integration Cloud (OIC)
- 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.
Oracle EPM &
- EDM
- 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.
- 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.
- Solid 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)
📌 Software Engineer II - Oracle Apps & Core DBA (Bengaluru)
🏢 7-Eleven Global Solution Center – India
📍 Bengaluru