Description

Oracle PL/SQL Developer with 5+ years of experience.

Responsibilities

• Design and optimize complex SQL and PL/SQL code for OLTP and batch processing.
• Manage Oracle table partitions, indexes, and primary keys for performance.
• Parse and retrieve JSON data from CLOB columns using PIVOT and dynamic columns.
• Analyze SQL execution plans and tune queries using rowlocks and join strategies.
• Implement user-defined referential constraints and deterministic functions.

Required Skills

• Strong proficiency in Oracle PL/SQL and SQL.
• Experience with SQL joins, cursors, and sysrefcursor.
• Knowledge of PL/SQL collections and exception handling.
• Ability to capture calling programs using EXECUTE IMMEDIATE.
• Understanding of SQL vs. PL/SQL engine parsing.
• Skills in comparing data between identical tables to find unmatched columns.
• Experience with TO_DATE and TO_TIMESTAMP conversions.

Preferred Skills

• Familiarity with ANSI-SQL and dimensional data modeling.
• Experience with Oracle Data Integrator (ODI) and QlikView.
• Knowledge of passing data to Angular, Java, or Python.

Key Skills

Education

Any Gradute