Software Developer - Oracle Pl-sql

Talpro
  • Bangalore
  • 15-25 lakh
  • 8-10 years
  • Views
  • 16 Jan 2017

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

- Must be able to read stored procedures, functions, and triggers written in Hana and convert to their Oracle equivalent Triggers
- Must understand when to utilize BEFORE and AFTER triggers
- Must be able to write multi-action triggers
- Must know when to use statement triggers vs row triggers
- Must know when to utilize the WHEN clause
- Must know when to utilize the OF clause
- Must know when to utilize the FOLLOWS clause
- Must understand the use of PRAGMA AUTONOMOUS_TRANSACTION
- Must understand what a mutating trigger is, what causes it, and how it is corrected
- Nice to have would be the ability to write a compound trigger
- Procedures and Functions
- Must be able to build PL/SQL packages from what in Hana were separate objects
- Must understand the PL/SQL package initialization section
- Must understand when and how to use global variables and types rather than local variables and types
- Must understand when and how to utilize constants rather than variables
- Must understand overloading
- Must understand the use of PRAGMA SERIALLY_REUSABLE
- Must be fluent in array processing with BULK COLLECT, FORALL, and the LIMIT and SAVE EXCEPTION clauses
- Must be able to write dynamic SQL utilizing the DBMS_ASSERT built-in package
- Must know how to use the Oracle Database Wrap utility
- Nice to have would be the ability to profile their code with DBMS_PROFILER and/or DBMS_HPROF or another native Oracle database tool


Competencies/Skill sets for this job

Sql Oracle Database Packaging

Job Posted By

About Organisation

Talpro