Oracle EBS App DBA

Job Title: Oracle EBS App DBA
Job Location: Delhi, Gurgaon ,Noida
Experiences: 8-15Years
Work Mode: Hybrid
Shift Timings- 01:30 PM - 10:30 PM IST
Job Description:
This position is for and OCI architect and On-Premise to OCI migration expert with Oracle ERP Apps Support role for day-to-day activities and integrations with sub-systems in the financial space with 8 to 15 years of experience in similar role/capacity. Securing systems with regular vulnerability patching and upkeep of ERP systems. His/her function is critical to the performance and stability of IT infrastructure hosting business critical applications and services on a 24/7/365 basis.
Oracle Cloud Infrastructure (OCI)

• Lead the migration of on-premises Oracle EBS 12.2 and Oracle Database 19c on Solaris to OCI.
• Design and implement OCI infrastructure for EBS, including provisioning and configuration of required services such as compute, storage, compartments and networking. This requires in-depth knowledge of OCI services, including VCN, Subnets, Service gateways, Compute, Block Storage, Object Storage, Networking, Oracle Cloud Autonomous Services, and others relevant to EBS infrastructure.
• Set up and administer Oracle Cloud services relevant to EBS, ensuring the architecture aligns with best practices for performance, scalability, and security.
• Handle day-to-day operational tasks within OCI, including but not limited to:
• Backup and recovery strategies.
• Database security, including encryption, access control, and auditing.
• Monitoring and performance tuning of EBS and databases.
• Patching, cloning, and applying updates to the EBS and Oracle Database environments.
• Develop and maintain scripts or automation tools for routine maintenance, backups, and other administrative tasks.
• Collaborate with internal teams to support application upgrades, disaster recovery planning, and other critical business processes.
• Ensure all systems adhere to OCI best practices for security and compliance, including implementing appropriate auditing and monitoring solutions.

Support and Maintenance of Oracle E-Business Suite (EBS) R12 Applications.

• Daily support and management of Oracle E-business Suite Application support activities.
• Monitoring and Trouble-shooting issues related to E-Business Suite Application Servers and services.
• Troubleshooting issues related Apache, oacore, oafm, oc4j, Forms services and apps login through SSO.
• Monitoring the Work Flow mailer and notification queues and fix if any issues/delay in processing the WF notifications.
• Handling Configuration changes of E-Business R12 environment- Autoconfig, template customization and Localizations.
• Administration and management of Oracle E-Business suite using AD utilities that includes adadmin activities for Application objects compilation and re-linking.
• Monitoring the Concurrent Managers status and managing the operations like starting, stopping the concurrent managers, re-schedule the requests and purging the concurrent requests historical data.
• Managing Concurrent queues and Parallel Concurrent Processing.
• Administration and Management of EBS External applications like iSupplier Module on DMZ.
• Monitoring, Diagnostics and Troubleshooting application using OAM (Oracle Applications Manager).
• Pro-actively work with Prod Support Team, Project Teams to provide planning and ongoing support for Application Life cycle management.
• Analysing the Log Files, Thread Dumps and JVM Dumps.
• Incident Management & Technical Assistance including Production and Performance diagnostics, technology assessments and troubleshooting day-to-day issues.
• Liaise with Performance Testing Team to identify any performance related issues during UAT phase.
• Java upgrades on EBS Application Servers and involve in Browser testing for Java desktop updates.
• Weekend Bounce, Maintenance and on-call Support for Production changes.
• Sanity testing of EBS Technology Stack components on regular basis.
• Perform Annual DR Tests.
• Month End Processing Hyper Care Support- tracking and reporting in doubt sessions, monitoring processing queues for long running requests, memory and space utilization.
• Creating Severity TARs/SR and conduct OWC sessions with Oracle support to resolve issues.
• EBS R12 Cloning / Refreshes
• Cloning Oracle E-Business Suite Application from Prod to Non-Prod Environments using Rapid and manual clone process.
• Multi Node to Multi Node, Multi Node to Single node and adding additional Application nodes if required.
• Weekly/Adhoc Copy Prod and Break Fix environment refreshes from Production.
• Post clone / refresh setups- SSO configuration & steps related to EBS integrated Applications.
• Applying Oracle E-Business Suite Application patches
• Applying Oracle E-Business Suite Application patches using adpatch, adop and OPatch options.
• Performing Oracle Application Pre-patch analysis (Patch Wizard), Pre-config Analysis for Quarterly PSU, Security vulnerabilities and other required patches.
• Applying patches on Oracle EBS Tech Stack and Oracle Application Server binaries (for Application Tier Forms and Reports).
• Applying Bug Fixes, Data fixes and other Oracle recommended patches (One-off, Mini Pack, and Family Pack).
• Applying Language and Localization specific patches as per business requirement.
• Application Code Migrations
• EBS Application Code Migrations from Development to QA, UAT and Production Instances.
• Coordinate and work with Release/Change Management teams for deployments, Outages and code migrations across Prod and Non-Prod Environments.
• Release Non-Disruptive, Disruptive Migrations across Non-Prod and Prod Environments.
• Form Compilations, deployment of customized reports and JSP Compilations.
• Performance Tuning
• Application tuning like OPP JVM memory usage. Troubleshoot java out of memory errors.
• Tuning of concurrent managers - Managing Concurrent queues and adjust process count based on load.
• Tuning Output Post Processor (OPP) to Improve Performance.
• Analysing Oracle Apps Dictionary Tables for High Performance
• Gather Schema Statistics Using FND_STATS in EBS.
• WF performance tuning.
• Security and Compliance
• Track Security Certificate expirations and request new certificates for EBS Applications.
• Installing and maintaining Supplier Certs to access Supplier Sites.
• Product Jar signing for Oracle E-Business Suite.
• Work on Web Security tools- LDAP Server, SSL Certificates and user authentication.
• Track and remediate Security Vulnerabilities , apply Critical Security Patch updates for EBS Applications
• Quarterly Password Changes for EBS Administrative Accounts and adhere to SOX policies.
• Generation of SOX Audit reports having all details of changes implemented on Prod Environments and sharing with Application Owners for required approvals.
• Work with D&T external Audit team and provide required EBS Application changes evidence for Audit related Queries.

Integration Support

• Support Oracle WebLogic for any integrations with Oracle E-Business Suite
• Support OAM /OID integration with EBS for SSO.
• Support OAAM for External EBS iSupplier Multifactor Authentication.
• Support Oracle Webcenter Integration - MMC EBS AP Imaging Solution.
• Support Kofax Markview integration for CONS EBS AP Imaging Solution.
• Support OIM integration for Quarterly certification and Identity Governance.
• Support Unitask Output Redirector for Printing Solution.
• Support SMTP/IMAP for Email/File transfer - GlobalScape.
• Support Vertex for Tax calculation and integration with EBS.
• Support Synchro for Tax calculation (Brazil).
• Support PGP Encryption for Workday File transfer and Bank interfaces.
• MISC Support
• Liaise with MGTI UNIX Server Ops for Monthly/Quarterly Patching Cycle Updates and Administration tasks on Solaris and Linux Servers.
• Liaise with MGTI Windows Server Ops for Monthly/Quarterly Patching Cycle Update and Administration tasks on Windows Servers.
• Liaise with MGTI Storage Team on Space requests, File system Backups and Year-End Special Backups.
• Liaise with MGTI Network Team on Firewall Port Opening Requests, Load Balancers, And Virtual Ips.
• Liaise with MGTI DCops for Monitoring and alert suppression.
• Coordinate and work with multiple MGTI Teams for Annual DR Tests.

Required Skills:

• Proven experience in migrating on-premises Oracle EBS 12.2 and Oracle Database 19c (Solaris) to OCI.
• In-depth knowledge of OCI services, including Compute, Block Storage, Object Storage, Networking, Oracle Cloud Autonomous Services, and others relevant to EBS infrastructure.
• Expertise in managing and administering Oracle EBS in a cloud environment.
• Strong hands-on experience with backup, recovery, patching, and cloning of Oracle EBS and databases in OCI.
• Familiarity with Oracle database security, auditing, and monitoring practices.
• Experience with automation tools such as Ansible, Terraform, or OCI-specific automation capabilities.
• Ability to troubleshoot and resolve issues related to EBS and database environments in OCI.
• Excellent communication skills and ability to work in a collaborative team environment.
• Full Understanding of the Oracle E-Business Suite R12 architecture and processes with their individual configuration files & log files to trouble shoot issues with each component.
• Hands on experience in Maintenance and Configuration of E-business R12 environment.
• Troubleshooting, Monitoring, Performance tuning of E-business Application Servers and services.
• Hands on experience in supporting EBS Financial Modules like AP, AR and GL Products.
• Sound Knowledge on troubleshooting issues related to Apache, oacore, oafm, oc4j, Forms services and apps login through SSO.
• Expertise in Application Cloning using Rapid Clone Utility/manual cloning and troubleshooting post clone issues
• Cloning Oracle E-Business Suite Application from Prod to Non-Prod, Multi Node to Multi Node, Multi Node to single node and adding additional Application nodes. "
• Configure and manage Parallel Concurrent Processing.
• Configure PGP Encryption, SSH Keys exchange for File transfers and Bank interfaces.
• Hands on experience in configuring and supporting EBS Multi-node architecture for High availability.
• Configuration of Workflow Mailers and Troubleshooting workflow notification mailer issues.
• Hands on experience in WebLogic Installation and configuration, Administration and Performance tuning.
• Configuration and monitoring EBS Application through OEM.
• Enabling SSL or TLS in Oracle E-Business Suite Release 12 and import the security certificates.
• Performing Oracle Application Pre-patch analysis (Using Patch Wizard in Oracle Applications Manager), Pre-config Analysis for Quarterly PSU and other required patches.
• Applying Oracle E-Business Suite Application patches (PSU, One-off, Mini Pack, Family Pack) using adpatch options.
• Proficient in Administration and management of Oracle E-Business suite using AD and FND utilities that include adadmin, adconfig, adpatch, adlicmgr, adsplice, adident, adctrl, adsplice, FNDCPASS, FNDLOAD, FRMCMP etc.
• Monitoring the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data,
• Tuning of concurrent managers and monitoring of the concurrent manager operations. "
• Involve in automation of jobs through Shell scripts and schedule them using Crontab and Autosys to run at regular intervals.

Soft skills

• OAM /OID integration with EBS for SSO.
• Oracle Webcenter Integration - EBS AP Imaging Solution.
• Kofax Markview integration - EBS AP Imaging Solution.
• OAAM for External EBS iSupplier Multifactor Authentication.
• OIM integration with EBS for Quarterly certification and Identity Governance.
• Unitask Output Redirector for Printing Solution.
• SMTP/IMAP for Email/File transfer - GlobalScape.
• Vertex for Tax calculation and integration with EBS.
• Synchro for Tax calculation (Brazil).
• OCI certification (e.g., Oracle Cloud Infrastructure Architect or Oracle Cloud Infrastructure Operations).
• Experience with hybrid cloud environments or other cloud providers.
• Familiarity with DevOps practices and CI/CD pipelines for Oracle workloads.
• Candidates must be flexible in terms of working hours due to the nature of the role
• Candidate is expected to work in 24X7 shifts (on a rotational basis)
• Weekends work duty is required whenever requests arise
• Proven ability to deliver on aggressive targets.

Desired Skills:

• Typically 6 to 8 years of experience With Oracle EBS, WebLogic Middleware and Single Sign On Administration

Education:

• B.Tech/M.Tech/MCA