Banner Image

All Services

Programming & Development Programming & Software

PL/SQL Developer

$15/hr Starting at $100

  • Expertise in Client-Server application development using Oracle 12c/19c
  • Effectively made use of Indexes, Table Partitioning, Collections, Materialized Views, Query Rewrite.
  • Created Tables, Views, Constraints, Index (B Tree and Function Based).
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Developed materialized views for data replication in distributed environments.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Partitioned large Tables using range partition technique.
  • Implemented Purging and Stat Gathering jobs.
  • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Worked extensively on Ref Cursor and Collections.
  • Expertise in Dynamic SQL, Collections and Exception handling.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

About

$15/hr Ongoing

Download Resume

  • Expertise in Client-Server application development using Oracle 12c/19c
  • Effectively made use of Indexes, Table Partitioning, Collections, Materialized Views, Query Rewrite.
  • Created Tables, Views, Constraints, Index (B Tree and Function Based).
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Developed materialized views for data replication in distributed environments.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Partitioned large Tables using range partition technique.
  • Implemented Purging and Stat Gathering jobs.
  • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Worked extensively on Ref Cursor and Collections.
  • Expertise in Dynamic SQL, Collections and Exception handling.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Skills & Expertise

OraclePL/SQLPythonSoftware DevelopmentSQL

0 Reviews

This Freelancer has not received any feedback.