Description

You will develop and optimize complex database logic within an Agile environment.

Responsibilities

• Write complex Oracle queries and optimize them to reduce SGA, PGA, and TempSpace usage.
• Develop, store, and manipulate JSON and XML data within Oracle database tables.
• Optimize the performance of stored procedures and views that access JSON-formatted data.
• Perform unit testing and maintain technical documentation for all developments.
• Participate in Agile development cycles.

Required Skills

• 10+ years of experience with Oracle SQL and PL/SQL.
• Expertise in advanced PL/SQL concepts including Bulk Collect.
• Proficiency in handling and querying data in JSON and XML formats.
• Experience creating complex queries and views using JSON data.
• Proven ability to optimize stored procedure and view performance.
• Strong knowledge of Oracle memory management (SGA/PGA/TempSpace).
• Any Graduate degree.

Key Skills

Education

Any Gradute