Job Description :
Database Performance related to applications. Like reorg, stat gathering, rebuilding application objects
Proactive Monitoring related to CPU, IO and memory performance
Application related Jobs
DB links setup and troubleshooting
Application releases support and troubleshooting issues
Procedure creation and troubleshooting the PL/SQL codes
Have extensively worked on Windows server for oracle and MS-SQL databases
Ready to support after office hrs. as On-call
Able to provide support/coordinate with offshore team


Please provide few resumes who have mostly worked as Oracle Apps DBA rather than Core Oracle DBA.



Detailed JD:

ü 7+ years of working experience with Oracle Apps DBA activities

ü Perform migration and Housekeeping tasks for all Versions of Oracle Database(9i/10g/11g and higher) and Application data including releases.

ü Performance tuning related to Database and other layers affecting the general performance of the applications.

ü Implementation of Data replication in the form of Snapshots, Materialized views etc.

ü Deployment of Weekly Application patches and releases for all the application, on

ü PROD databases and also organize the backup implementation plan with respect to every release.

ü Configure and Automate CRONS to generate alerts and reports on CPU usage, User-expiry, Tablespace, Object analysing scripts,

ü AWR reports for the databases and monitor them on daily basis.

ü Identifying the areas of Automation for easier monitoring and value add.

ü Expertise in Scripting, Configuring and Scheduling Batch Jobs using Bash and Control-M.

ü Troubleshooting the incoming and outgoing files failure logs from / to external vendors and vice versa.

ü Maintaining scripting standards and Monitoring the logs and flow.

ü Experience is Monitoring, Maintaining and Job scheduling for Primary / Disaster Recovery environments.

ü Co-ordination and supporting all testing tasks and suggesting best approach based on the performance and tuning.

ü To raise CR/GRS/PM tickets based on the severity of the tasks and liaise with respective Regional teams for approvals

ü Initiate refresh/perform Post sanity configuration/checks after every refresh of production data to UAT Environments and apply the respective Data masking to maintain the audit compliance.