Job Description
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
• Highly advanced team
• Project > EBS financials systems running extremely slow due to high levels of customization
• 35% of codebase customized
• Candidate must be knowledge in code optimizations
• Candidate must be from a Developer or DBA background
• Process knowledge not required
Qualifications
6m contract plus extension
Additional InformationSkills Required
- Expert knowledge of Oracle E-Business Suite and Oracle Database architecture
- Experience tuning Oracle Database parameter files (PFILE) and configuration for performance
- Ability to tune EBS application configuration files for performance troubleshooting
- In-depth SQL and PL/SQL tuning skills (code analysis, indexes, joins, hints, parallelism)
- Strong OS-level troubleshooting on Linux, Solaris, HP-UX (netstat, vmstat, truss, OSWatcher)
- Experience reading RAC logs and troubleshooting CRS/CSSD issues; use LogMiner for OS/DB performance issues
- Understand Oracle internals (library cache, waits, latches) for lock and performance troubleshooting
- Analyze EBS concurrent requests and DB jobs; create/suggest SQL profiles and indexes
- Familiarity with tuning Oracle ADF, SOA, Fusion Middleware, Fusion Applications, and WebLogic
- Experience with Oracle Database 11.2 or newer
- Proven ability in code optimizations (customized codebase)
- Background as a Developer or DBA
- Ability to create documentation, train teams, and provide 24x7 technical support
What We Do
Atria Group LLC, also operating as Atria IT, is a specialized IT staffing and consulting firm headquartered in Plano, Texas. The company provides comprehensive workforce solutions, including staffing, consulting, software development, and training services, specializing in enterprise solutions for small to medium-sized businesses. Their primary objective is to assist these enterprises in maximizing their IT resources to meet evolving technological challenges.
