Oracle PL/SQL Developer

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 comparing data between two identical tables a...