• Expertise working with Oracle SQL and PL/SQL, including advanced concepts such as bulk collect and handling data in JSON/XML format.

• Proficient in writing and optimizing complex Oracle queries to reduce SGA/PGA/TempSpace usage.

• Skilled in storing, querying, and manipulating JSON data in Oracle database tables.

• Experienced in creating complex queries and views using JSON data.

• Expertise in optimizing performance of stored procedures and views that access JSON data.

• Proficient in documentation.

• Strong background in development and unit testing.

• Active participant in Agile development practices.

Candidate Skills and Qualifications

• Seven years of expertise with Oracle SQL and PL/SQL, including advanced concepts.

• Seven years of proficiency in writing and optimizing complex Oracle queries.

• Seven years of experience with documentation.

• Seven years of development and unit testing.

• Seven years of participation in Agile development practices.

• Four years of experience storing, querying, and manipulating JSON data in Oracle tables.

• Four years of experience creating complex queries and views using JSON data.

• Four years of optimizing performance of procedures and views accessing JSON data.

PROLIM is a leading provider of end-to-end IT, PLM and Engineering Services and Solutions for Global 1000 companies. They understand business as much as technology, and help their customers improve their profitability and efficiency by providing high value technology consulting, staffing, and project management outsourcing services.

Their IT and PLM consulting offerings include; Advisory, PLM Software/Services, Program Management, Solution Architecture Training/Staffing, Cloud Solutions, Servers/Networking, Infrastructure, ERP Practices and QA Services. Engineering services include Data Translation, CAD/CAM/CAE, Process & Product Engineering, Prototyping, and Testing/Validation within a wide range of markets and industries.