Title: Oracle APPS DBA

Location: Hoboken, NJ

Duration: Perm (GC/USC/GC_EAD)

Customer: Marsh

Salary: 110K-120K

Taleo: 18894

Key Skills: Database Administration 10g, 11g & 12c, SQL Tuning, Oracle E-Business Suite with its architecture 11i & R12. 10GAS (Portal & OID ), 10GAS (Discoverer)

JOB DESCRIPTION:

Unix

• Good Knowledge of UNIX Usage (Linux and Solaris ).

• Good Knowledge of UNIX Operating System with understanding of Kernel parameters and Volumes ( NAS & SAN ) and File Systems.

• Basic knowledge of testing the network and URLS with commands like nslookup, lsof ,,, etc.

• Unix Shell Scripting.

 Database

• Good Knowledge of Database Administration 10g,11g & 12c

• Hands on Experience in Oracle RAC (Real Application Cluster) with ASM

• Monitoring Sessions

• Tuning SQLs

• Performance tuning of database and improving init.ora parameters

• Tablespaces and data files on raw devices and file systems including stripping and mirroring.

• Understanding to read and interpret the alert log files, output of tkprof and AWRR reports.

• Hands on Experience in upgrading database 10g to 12c.

• Hands on Experience in DR setup and maintaining along with Oracle Data guard

 E-Business Suite

• Full Understanding of the E-Business Suite with its architecture 11i & R12.

• Hands on experience in Installation and maintenance of E-business 11i & R12 environment.

• Trouble shooting, Monitoring, Performance tuning of  E-business Application Servers.

• Full Understanding of all processes of the E-Business suite with thier individual configuration files and log files and to trouble shoot issues with each component.

• Forms server

• Report Server

• Concurrent Managers

• Apache Servers

• Manage and Administer E-Business Users.

• Understand and administer menus, responsibilities, Functions.

• Hands on Experience in EBS Upgrade 11i to R12

• Worked in EBS production support 24 x 7 model

• Hands on experience in ERP application cloning, patching and troubleshooting concurrent manager's issues,

   Hands on experience in Revenue  Management & Billing(RM&B).

 10GAS (Portal & OID )

• Full Understanding of the Portal and OID Installation and Services.

• To Configure the Single-SignOn.

• To Administer all services of the OID and Portal Installations.

• To Understand and interpret logs and trace files.

• To Register the OID with the E-Business suite and trouble shoot of any issues.                                                                                                                                                                                                       Weblogic Server Administration.

 10GAS (Discoverer)

• Full Understanding of the Discoverer Installation and its services.

• To understand and debug report running issues.

• To Integrate Discoverer with the E-Business Suite and to trouble shoot issues.

 Worked on Single Sign-On & Mark view applications.