Brief:

· Min : 5+ Yrs exp as an Oracle Apps DBA

· Managing / Administering Oracle EBS (R 12.2) and Database (R 12.x) .

· Administration, Configuration, Upgrades and Patching of Oracle Applications products (Release 12.2)

· Planning, Preparation and Execution of Production systems - Isolate and troubleshoot issues related to various Oracle Application Products, Databases and underlying Operation systems and other Infrastructure components.

· Oracle Database administration experience, including performance tuning and monitoring, SQL, and PL/SQL

· Experience with Database optimizer, including optimizer parameters, parsing mechanism and how optimizer influences in controlling, stabilizing execution plans

· Experience managing and configuring SOA.

· Analyze and Troubleshoot SQL queries and provides performance improvement recommendations.

· High Availability - Real Applications Clusters (RAC) and Data Guard - Architecture implementation, Installation, Configuration and Administration.

· WebLogic Server Administration experience - Troubleshoot, analyze logs and heap/core dumps.

· Experience in Oracle Enterprise Manager (Release12c) Configuring AMP, WLS Management packs

· Linux / Unix experience with the knowledge and ability to perform in all of the basic Unix management skills of the OS and the Storage Layer.

· Experience in Oracle PaaS and IaaS Configuration and maintenance.





Roles and Responsibilities Of Oracle APPS DBA

· Installation, configuration and upgrading of Oracle server software and related products.

· Starting and Stopping the application

· Monitoring the application related products like oacore,oafm apache etc.

· Bouncing apache,oacore,oafm if needed

· Establish and maintain backup and recovery policies and procedures.

· Take care of the Database design and implementation.

· Implement and maintain database security (create and maintain users and roles, assign privileges).

· Work as part of a team and provide 24×7 support when required

· Perform general technical trouble shooting and give consultation to development teams.

· Interface with Oracle Corporation for technical support.

· Patch Management and Version Control.

· Perform database tuning and performance monitoring.

· Perform application tuning and performance monitoring.

· Cloning DEV and TEST from PROD.



Prerequisites for Learning Oracle APPS DBA

· Good Knowledge in OS like Linux, IBM(UIX), Windows etc.as oracle software will be installed on these OS’s.

· Good Knowledge in SQL and PL/SQL.

· Very good understanding of Oracle core database architecture and concepts

· Knowledge on Concurrent managers



Daily activities are performed by the “Oracle Apps DBA” is mention below: –



· Answering support calls

· Logging/updating support tickets

· Monitoring alerts

· Code Migration Support to Functional Consultants

· Handling tickets raised by functional/technical/business users

· Handling Alerts raised by alert monitoring system from Database and applications

· Tablespace Reorg Activities to improve the performance/to reclaim the unused space

· Schema Reorg Activities to improve the performance

· Patch Analysis where there is a patch needs to be applied

· Patch Application as per schedule

· Cloning as per schedules

· Backups and issues related to them

· Query response time and other Performance Issues

· Work with Oracle Support by raising SRs on several issues

· Monitoring Standby Databases and resolve respective issues

· Regular database maintenance activities (tablespace management, datapump, purging logfiles……)

· Work on issues which L2 couldn’t fix

· New Environments Build/Setups

· Designing Backup/Recovery policies

· Installing new Application environments

· Post-Installation Tasks of New environments

· Integrating E-Business Suite with other environments such as (SOA)

· Work on integration issues

· Work on Cluster setups for both applications and databases

· Work on DMZ setups to E-Business Suite

· Work on Standby site setups for both applications and databases

· Interact with Network/OS teams on network setups and load balancer setups.

· Work on Parallel Concurrent Processing (PCP) Setups

· Fail-over capabilities testing of E-Business Suite and database

· Design Cloning strategies.

· Work on design related issues.

· Attend Client Meetings to understand their expectations.

· Involve in Business User Meetings to understand their expectations.

· Design E-Business Suite Architecture with failover/failback capabilities.

· Design Clustering capabilities of E-Business Suite and databases.

· Design High availability of E-Business Suite and databases.

· Design hardware/capacity sizing.

· Fix any architectural related issues.


If your profile matches the requirement, please fill the below detail along with an updated profile of yours and send it to

Technical expertise:

Total Exp:

Job details

• Share
• See all ads from this advertiser