24 Sep
|
Exacore IT Solutions
|
Thrissur
24 Sep
Exacore IT Solutions
Thrissur
Experience
3+ years of relevant experience in Oracle Applications Database Administration.
Job Summary
We are looking for an experienced Oracle Apps DBA with 3+ years of experience in implementing, administering, maintaining, upgrading, and troubleshooting Oracle E-Business Suite (EBS) environments. The candidate should have hands-on experience with EBS R12.1.3 and R12.2.x, Oracle Database administration, RAC environments, application cloning, online patching, Disaster Recovery (DR), and performance tuning.
1. Oracle EBS Administration
· Install, configure, administer, and maintain Oracle E-Business Suite R12.1.3 and R12.2.x environments. · Manage EBS application and database tiers across development, testing, UAT, and production environments.
· Perform routine application administration, monitoring, and troubleshooting.
· Manage Forms, OAF, WebLogic, Apache/OHS, and Concurrent Processing services.
· Manage users, responsibilities, profile options, and application security.
1. Cloning and Environment Management
· Perform EBS application-tier and database-tier cloning activities. · Execute production-to-test and production-to-development refreshes.
1. Patching and Maintenance
· Perform EBS patching using ADOP and AD Administration utilities. · Apply AD, TXK, application, database, Forms, Reports, WebLogic, and technology-stack patches as required.
· Perform OPatch activities, investigate patch conflicts, and monitor patch logs.
· Apply critical security patches and maintain environments according to approved maintenance plans.
1. Oracle EBS Upgrade
· Participate in EBS upgrades, including upgrades from R12.1.3 to R12.2.x. · Coordinate with functional, development, infrastructure, and application teams.
· Troubleshoot technical issues encountered during upgrade and migration activities.
1. Oracle Database Administration
· Administer Oracle databases, including Oracle 11g, 12c,19c and 26AI. · Monitor database availability, tablespaces, datafiles, archive logs, and space utilization.
· Perform database startup, shutdown, and routine maintenance activities.
· Monitor database alerts, logs, and performance-related issues.
· Manage database users, privileges, invalid objects, and basic performance troubleshooting.
· Support backup and recovery activities using RMAN and established recovery procedures.
1. Oracle RAC Administration
· Support Oracle Real Application Clusters (RAC) environments hosting Oracle EBS databases. · Monitor RAC database instances, services, and cluster availability.
· Perform basic RAC administration and troubleshooting using srvctl, crsctl, and SQL*Plus, as applicable.
· Troubleshoot RAC instance, service, listener, and connectivity issues.
· Coordinate with infrastructure and storage teams to investigate cluster, network, and shared-storage issues.
· Support planned RAC maintenance and understand load balancing, failover, and high-availability concepts.
1. Disaster Recovery (DR) and Business Continuity
· Support implementation, maintenance, and validation of Oracle EBS Disaster Recovery environments. · Participate in DR planning, DR drills, and failover/failback activities.
· Support database DR configurations using Oracle Data Guard, where applicable.
· Monitor Data Guard synchronization, redo transport, and apply status.
· Assist in validating database and application-tier readiness at the DR site.
· Coordinate with infrastructure, network, storage, and application teams during DR testing and recovery.
· Maintain DR runbooks, recovery procedures, validation checklists, and implementation documentation.
· Understand RTO and RPO requirements and support activities aligned with approved DR procedures.
1. Middleware and Security Integration
· Administer and troubleshoot Oracle Fusion Middleware components used by EBS. · Support WebLogic, Forms, Reports, OHS, and related application services.
· Support integration with Oracle Internet Directory (OID), Oracle Access Manager (OAM), and Single Sign-On (SSO).
· Troubleshoot authentication, login, Forms launch, and middleware connectivity issues.
· Perform configuration and validation activities following middleware patching or maintenance.
1. Concurrent Processing and Application Support
· Monitor and troubleshoot concurrent managers, concurrent requests, and request sets. · Investigate pending, running, warning, and error requests.
· Troubleshoot manager startup failures and long-running requests.
· Support migration and deployment of RDF, RTF, FMB, and XML files.
· Coordinate with functional and development teams to resolve application issues.
1. Production Support and Documentation
· Provide L2/L3 technical support for Oracle EBS production environments. · Participate in planned maintenance, month-end activities, patching, cloning, upgrades, and DR exercises.
· Perform root-cause analysis and document incident resolutions.
· Follow change management, incident management, and escalation procedures.
· Prepare technical documentation, implementation and rollback plans, DR runbooks, and status reports.
· Coordinate with customers and cross-functional teams to ensure timely issue resolution.
Required Technical Skills
Oracle Applications
Oracle EBS R12.1.3 and R12.2.x
EBS Administration
ADADMIN, ADOP, AutoConfig, context files, cloning
Patching
AD/TXK patches, application patches, OPatch, technology-stack patching
Database
Oracle 11g, 12c, and 19c; database administration
Oracle RAC
RAC architecture, instance and service monitoring, basic RAC troubleshooting
Disaster Recovery
DR concepts, DR drills, failover/failback support, Data Guard fundamentals
Backup and Recovery
RMAN backup and recovery fundamentals
Middleware
WebLogic, Forms, Reports, OHS, Fusion Middleware
Security
OID, OAM, SSO integration and troubleshooting
Concurrent Processing
Concurrent managers, requests, and request sets
Operating Systems
Linux/Unix; Windows exposure,IBM AIX
Troubleshooting
EBS login, Forms, concurrent processing, patching, cloning, connectivity, RAC, and DR issues
Documentation
Technical procedures, RCA, change records, DR runbooks, and status reports
Preferred Qualifications
· Experience supporting development, test, UAT, and production EBS environments.
· Hands-on experience with EBS upgrades and online patching.
· Experience supporting Oracle RAC databases and high-availability configurations.
· Exposure to Oracle Data Guard and database DR exercises.
· Experience working with customers in a production-support environment.
· Knowledge of Oracle Cloud Infrastructure (OCI) or other cloud-hosted EBS environments.
· Oracle EBS or Oracle Database certifications are an advantage.
Key Competencies
· Strong troubleshooting and analytical skills.
· Ability to work independently during planned maintenance and production incidents.
· Valuable communication and customer-handling skills.
· Ability to coordinate with functional, development, infrastructure, network, and database teams.
Strong documentation, ownership, and problem-solving abilities
Work Location: In person
📌 ORACLE APPS DBA (Thrissur)
🏢 Exacore IT Solutions
📍 Thrissur