Sweta Consultancy

Vadodara, Gujarat

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