• 8 to 10 years technical experience in pl/sql & sql performance tuning to optimize database performance, troubleshoot slow queries, and enhance overall system efficiency.
• very strong experience in the following sql optimization tools:
• candidate should be expert in developing stored procedures and packages along with strong experience sql and pl/sql.
• perform sql and pl/sql tuning and application tuning using various tools like explain plan, sql*trace, tkprof and autotrace.
• ability to analyze execution plans and suggest performance improvements.
• optimize pl/sql stored procedures, functions, triggers, and packages to minimize execution time and resource consumption.
• strong understanding of database architecture, memory management, and caching techniques.
• very strong knowledge/experience in debug/troubleshoot performance issues and fine-tune stored procedures, functions, and ad-hoc sql code to enhance query execution speed.
• oracle ebusiness applications, experience in implementation and customization for the following modules in oracle ebusiness applications suite: oracle purchasing, sourcing, iprocurement, inventory and oracle order management.
• proficient in analyzing and optimizing complex sql queries.
• very strong experience in the oracle api and ricew elements.
• should have experience in integration of ebs with other systems.
• demonstrates strong knowledge of concepts and theories in own discipline.
• perceived internally and externally as technically knowledgeable in the specific modules assigned.
• demonstrates ability to teach others the technical and functional knowledge and skills needed to achieve results at the optimum level of performance.
• demonstrate ability to provide technical solution to technical team after discussion with functional team