Oracle DBA

Job Description

Core DBA skills

1. Oracle database concepts

2. SQL Tuning

3. Stats pack and AWR report analysis and interpretation

4. Overall system performance tuning

5. Various backup methods and the recovery processes.

6. Oracle RAC administration and performance analysis

7. Installation experience on various Oracle database versions

8. Knowledge on code tree build and maintenance

9. Knowledge on CRS and maintenance

10. Knowledge on Oracle RDBMS patching on single node and RAC environments.

11. ASM and Data Guard

Apps DBA skills

Oracle Applications 11i/R12.1/R12.2 experience and Expertise

Installation experience on Apps 11i, 12.1 & R12.2

Knowledge in Oracle WF administration

Trouble shooting knowledge in APPS -

Middle tier (iAS, Apache), Forms and Concurrent Managers

Parallel Concurrent Process administration

Installation and configuration on Oracle iAS servers

Tuning the middle tier layers (Oracle iAS)

Oracle applications tuning

Installation and configuration of BPEL servers.

Knowledge on Database, Middle tier and Apps Upgrades

Knowledge on Application patch analysis and installation

Good knowledge on the various Application Admin utilities (ad utilities)

Cloning/Refresh of Oracle and Application environments

BPEL and SOA

Good hands on in HP-UX, Linux & Sun Solaris (Desirable)

Perl/Shell scripting (Desirable)

Knowledge in WebLogic Administration and Basic Troubleshooting required for EBS 12.