Oracle APPs DBA Responsibilities

Major Responsibilities Oracle APPs DBA:

• Installing of Oracle Application and upgrading periodically

• Database migration to new Oracle DB

• Copy/Clone of Oracle application environment using Rapid clone

• Database Refresh

• Use Oracle Application tools for maintaining database and application like: ad patch,

admin, adctrl etc.

• Applying RDBMS patches using Opatch

• Creation of a number of database instances for development, testing and production.

• Creation and managing the Database objects and schemas

• Managing 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.

• Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.

• Application user creation / responsibilities assignment

• Knowledge / worked in the RAC environments