Description

You will develop and maintain database logic using PL/SQL.

Responsibilities

• Implement and optimize OLTP and Batch Processing using SQL and PL/SQL.
• Develop solutions to capture calling programs for Oracle PL/SQL procedures and functions.
• Design and implement data handling strategies, including JSON fetching (PIVOT) and CLOB storage/retrieval.
• Manage data integrity by implementing user-defined referential constraint checks via PL/SQL.
• Optimize query performance by analyzing and utilizing SQL execution plans.

Required Skills

• 5+ years of experience with PL/SQL and SQL.
• Strong knowledge of Oracle Database, including Table Indexes (all types), Primary Keys, and Partitioning.
• Proficiency in handling JSON data types and operations within Oracle.
• Expertise in SQL Joins, PL/SQL collections, and cursor management (sysrefcursor, PL/SQL cursors).
• Experience with data comparison between identical tables to identify unmatched values.
• Familiarity with passing data between Oracle PL/SQL procedures and external languages (Angular, Java, Python).
• Understanding of transaction management within Oracle.

Key Skills

Education

Bachelor's degree