About the Role
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...
Ready to Apply?
Submit your application today and take the next step in your career journey with LTM.
Apply Now