Job Title

Oracle PL/SQL Developer

Job Location

Mississauga, Ontario

Job Description

• Strong understanding between OLTP and Batch Processing using SQL and PLSQL
• Oracle Table Indexes of all types
• Primary Key usage
• Oracle Table Partitions
• Fetch JSON data using PIVOT for unknown number of columns applying rowlocks using SELECT
• Strong written knowledge on SQL Joins
• PLSQL collections
• Deterministic functions
• Good understanding on sysrefcursor
• How to capture which program is calling Oracle PLSQL Procedure function packages
• Strong on Oracle SQL parsing SQL engine vs PLSQL engine
• PLSQL cursors
• ToDate to timestamp conversion
• Renaming table columns
• Excellent understanding of SQL execution plan inline functions
• Best approaches on implementing user defined referential constraint check using PLSQL...