Oracle APPS DBA
Hoboken, NJ
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.
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.
Key Skills:
- Unix, Database Administration 10g,11g & 12c, SQL Tuning, Oracle E-Business Suite with its architecture 11i & R12. 10GAS (Portal & OID ), 10GAS (Discoverer)