Oracle PL/SQL Developer

Sweta Consultancy

• 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

• Experience

  8 - 10 Years

• No. of Openings

  10

• Education

  B.Tech

• Role

  Oracle PLSQL Developer

• Industry Type

  IT-Hardware & Networking / IT-Software / Software Services

• Gender

  [ Male / Female ]

• Job Country

  India

• Type of Job

  Full Time

• Work Location Type

  Work from Home