ES
PL/SQL Developer
Epsilon Solutions LTD
🇨🇦 Canada
On-site
6 months ago
- PL/SQL
- SQL
- Oracle
- JSON
- Cursor
- Angular
- Java
- Python
- Oracle Database
6 months ago
Job Type: Fulltime
Location: Mississauga ON (3-4 days onsite)
Experience Lavel Senior
Job Description
Strong understanding between OLTP and Batch Processing using SQL and PLSQL
Oracle Table Indexs all types Primary Key
Oracle Table Partitions Fetch JSON data using PIVOT unknown number of columns applying rowlocks using SELECT
Strong written knowledge on SQL Joins PLSQL collections Deterministic function 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 totimestamp Renaming table columns
Very Good understanding of SQL execution plan inline functions
Best approaches on implementing user defined referential constraint check using PLSQL
Comparing data between two identical tables and finding list of columns with unmatched values fastest method on storing and retrieval of JSON data from CLOB columns why should be use Execute Immediate Oracle PLSQL exceptions user defined as well Oracle provided
PLSQL cursor Multiple ways to pass data from Oracle PLSQL procedure to Angular or Java or Python SQL operator in any ALL
Advantage and disadvantage of using PLSQL packages good understanding on Transaction within another Transaction in Oracle
Industry certification in Oracle Database
PL/SQL Developer · Epsilon Solutions LTD