Oracle DBA Role - EBS Database - IT

Oracle DBA (EBS)

Oracle Apps DBA ROLES AND RESPONSIBILITIES:

Alert Monitoring

- Ticket Monitoring

- Business E-Mail Monitoring

- OEM Alert Monitoring and Action - L1

- EOC Support and Presence L1

- Resolve tickets of L1 (Provide Logs, User Password change, User Creation, Execute SQL and share output, startup and shutdown instances, Patching Development instances) ; Oracle SR Follow-up

- Attend Team Meetings

- Prod Health Check

- Development instance health Check

- Simple Development instance Maintenance

- Take lead and ownership in Complex issues

- Technically Lead/ Contribute to Fairly complex Project like ASM Migration, Database Re-org, Automation, etc.)

- Production instance maintenance (Simple and Complex both)

- execute complex project which has documentation in place

- Resolve long running and fairly complex issues like

- Performance tuning L1 (Use COE, Copy and implement SQL Plan, Ability to take traces)

- Lead and contribute to EOC

- OEM Alert Monitoring and Action - L2 and Repeating L1 alerts to fix root Cause

- Resolve tickets of L2 (Passwd change activity on Dev instances, Multiple patch application on Dev instances, UC4 issues, Patch Analysis

- (Database, Grid upgrade, ASM to Non-ASM, Cloning Non-RAC instances, etc.)

- Troubleshoot L1 and L2 type issues (Why Program is failing, enhancement to Dev instance health check, Enhancement to prod daily health check,

- Specific Objectives like Change Ticket mgt, Documentation Owner Experience Desired:

REQUIRED SKILLS AND EXPERIENCE:

The Oracle Apps DBA will be responsible for managing the performance of Oracle Application and databases.

- Installation, configuration, upgrading, administrating, monitoring, troubleshooting, Patching of Oracle EBS.

- Supporting EBS 12.2 Application and 11g

- Working on the ticketing system and tool on production/development EBS Database/Application issues.

- Coordination with Oracle, Application Support team, Unix/Linux/storage, and other Application interface teams.

- Perform Patching, cloning, taking backups, managing archives and regular maintenance activities

- Reviewing code running in the system and provide recommendations to tune the SQL, PL/SQL code.

- Review AWR reports on a regular basis and providing recommendations

- Proactively Reviewing Wait Events in the system and providing recommendations accordingly.