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 solid 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.
• 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)
📌 Software Engineer II (Bengaluru)
🏢 7-Eleven Global Solution Center – India
📍 Bengaluru