We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

5.00/5 (Submit Your Rating)

OBJECTIVES

  • To seek a competitive and challenging career opportunity in IT Firm, that utilizes my skills and knowledge and at the same time provides challenging opportunities for learning and growth.

SUMMARY

  • Having 3+ years of IT experience in the field of oracle in pl/sql development.
  • Main responsibilities include understanding of client requirements & develop solutions.
  • Experience on pl/sql programming in Oracle 10g/11g relational and object relational database.
  • Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers, cursor, bulk collect using SQL and PL/SQL with OOPS concept.
  • Working on Oracle OLAP and hands on experience in SQL tuning/Re - writing SQLs in an alternate better way.
  • Written SQL queries for DML operations, Sub queries, JOIN and queries optimization.
  • Effectively made use ofTable Functions, Indexes, Collections, Analytical functions.
  • Create the objects like tables, synonyms, sequences and views.
  • Experience on SQL *PLUS, TOAD tools.
  • Knowledge on UNIX.
  • Ability to be an effective team player and work under time constraints.

TECHNICAL SKILLS

Operating System: Windows 98/NT/2000, Linux.

Language: SQL, PL/SQL.

RDBMS: ORACLE.

TOOLS: SQL * PLUS, TOAD.

PROFESSIONAL EXPERIENCE

Confidential

PL/SQL Developer

Responsibilities:

  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Created PL/SQL stored procedures, functions and packages.
  • Creating of new tables, views, queries for new enhancement in the application using TOAD.
  • Retrieving data set in bulk using pl/sql tables.
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad and SQL* plus.
  • Extensively used bulk collection in PL/SQL objects for improving the performing.
  • Created records, tables, collections (nested tables and arrays) for improving Query performance.
  • Identify suitable business scenario in the existing application and suggest/implement back end procedure implementation.
  • Must be very comfortable in generating/understanding query plan and identify deficiency in query execution, suggesting, implementing changes for better performance.
  • Hands on experience in SQL tuning/Re-writing SQLs in an alternate better way and queries optimization.

Confidential

PL/SQL Developer

Responsibilities:

  • DML operation on tables, views, procedures and packages using oracle tools like Toad and SQL* plus.
  • Working with Unix OS and shell scripting.
  • Identify performance bottlenecks in PLSQL procedure and eliminate by alternate implementation.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Extensively used bulk collection in PL/SQL objects for improving the performing.
  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Used Bulk Collections for better performance and easy retrieval of data.
  • Created records, collections (nested tables and arrays) for improving Query performance.
  • Good knowledge in Analytical Functions and Notification,FUNCTION,PROCEDURE,PACKAGE,OOPS

We'd love your feedback!