-
Looking to contribute my knowledge and skills in a school that offers a genuine opportunity for career progression
- Oracle PL/SQL Developer/Production support in Analysis, Design and Implementation of business Applications using the Oracle Relational Database Management systems (RDBMS)
- Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
- Excellent conceptual knowledge of Oracle 10g/11g, PL/SQL and SQL, Unix Shell scripting.
- Experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor.
- Experience sequences, Joins, Explain Plan, Indexing, Hints, Bulk Collect, Creation of global temporary tables and table partitioning.
- Extreme Use of exception handling methods along with Pragma Exception_init in order to associate our own created exception names.
- Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance.
Expertise in loading data from legacy systems using SQL*Loader