|
Job
Description:
|
|
Client
is seeking a high-energy, clear-thinking, scientific oriented and
knowledgeable Oracle Applications Performance tuning specialist to support
our existing enterprise environment. The successful candidate will come up
with performance tuning strategy, train the developers and the database
administrators on tuning techniques, create documentation and provide 24x7
technical support.
Candidate should be expert in the following areas:
• Excellent knowledge in Oracle Application Ebiz Suite and Oracle Database
architecture in depth.
• Knowledge in tuning Oracle Database PFILE / Configuration files that helps
in Performance improvement.
• Knowledge in Tuning Application configuration files for Ebiz Suite
Performance troubleshooting.
• In Depth knowledge in SQL & PL/SQL tuning – Analyzing Codes / Indexes /
Joins / Hints / Parallelism
• Excellent understanding in OS (Linux/Solaris/HP-UX) level commands and
applying those in Performance Troubleshooting (NETSTAT / VMSTAT / TRUSS / OS
Level CRS failure messages )
• Reading RAC log files for troubleshooting crs / cssd related logs.
(OSWATHCER / Log Miner ) for OS level performance issues.
• Understanding the functioning of Library Cache / Waits / Latches in Oracle
Databases for troubleshooting Locks / Performance in Oracle DB
• Analyzing Ebiz Suite application Concurrent Requests / Database Jobs and
create/suggest proper SQL Profile / Index in case of Performance gain.
• Good understanding of tuning Oracle software like ADF, SOA, Fusion MW,
Fusion Apps, WebLogic.
• New position > workload increase because of new EBS financials systems
• Performance tuning: App, DB, middleware-fusion, and OS levels
• 80% DB and 20% App, middleware, OS skill set
• Oracle DB > 11.2 version
• Performance Testing Team: 6 team members
o Highly advanced team
• Project > EBS financials systems running extremely slow due to high
levels of customization
o 35% of codebase customized
o Candidate must be knowledge in code optimizations
• Candidate must be from a Developer or DBA background
• Process knowledge not required
|
