Oracle Pl/Sql Developer, Resume,

CAREER OBJECTIVE:

To work in good environment by exposing my skills TEMPeffectively wif sincere hard work and following professional ethics, work for teh development of your company and also for my professional growth.

SUMMARY

Having 3.3 Years Of Professional Experience In ORACLE As A PL/SQL Developer.
Hands on Experience in Technologies Like Oracle, SQL And PL/SQL.
Proficient In Writing SQL Queries, Cursors, Sub Programs Like Procedures, Functions, Packages And Triggers In PL/SQL Blocks.
Expertise In Oracle Constraints, Sequences, Synonyms, Functions, Joins, Views, Index, Sub Queries, Correlated Sub Query.
Expertise In Exception Handling, Pragma Exception Init And Autonomous Transaction.
Extensively Used Advanced Plsql Collections, Ref Cursor, Bulk Collect And Bulk Bind.
Load Data Using Sql*Loader, External Tables And Knowledge Of Import/Export Utility.
Knowledge Of Performance Tuning Which Includes Query Optimization, Hints, Explain Plans To Tune Sql Queries.
Worked Of Materialized View, Mutating Triggers.
Excellent Problem Solving Skills Wif A Strong Technical Background And Good Interpersonal Skills.
Willing To Adapt To New Environment And Learn New Technologies.
Ability To Be An TEMPEffective Team Player And Work Under Time Constraints.

TECHNICAL SKILLS

Languages: SQL, PL/SQL.

Databases: Oracle 10g/11g, 12c.

Development Tools: Sql*Plus, SQL Developer, Toad.

Operating Systems: Windows (8, 10),Linux Basic Command

PROFESSIONAL EXPERIENCE

Oracle Pl/Sql Developer

Confidential

Responsibilities:

Creating And Modifying Database Objects As Per Requirement.
Extensively Used Table Type And Object Types For Development.
Wrote Sql Queries Using Joins, Sub Query And Co - Related Sub-Query For Teh Manipulation Of Data.
Extensively Used Teh Procedures, Functions, Packages, Triggers, Pragma Autonomous Transaction For Implementing Complex Business Logic.
Involved In Resolving Teh Errors And Warnings While Developing Teh Jobs Using Exception Handling, Pragma Exception Init.
Solve Troubleshooting Performance Issues In Pl Sql And Tuning Them For Performance Enhancements.
Responsible For Tuning Of Sql Queries Written In Procedures/Functions At Teh Back End .

Technology &Tools Used: Oracle 11g, Sql*Plus, Toad, Plsql

Oracle Pl/Sql Developer

Confidential

Responsibilities:

Creating And Modifying Database Objects As Per Requirement.
Involved In Developing And Handling Teh Pl/Sql Packages, Procedures, Functions, Triggers, Pragma Autonomous Transaction For Implementing Complex Business Logic.
Extensively Used Table Type And Object Types For Development.
Loading Data From Flat Files Into Database Tables Using Sql* Loader.
Wrote Sql Queries Using Joins, Sub Query And Co-Related Sub-Query For Teh Manipulation Of Data.
Involved In Resolving Teh Errors And Warnings While Developing Teh Procedures Functions Using Exception Handling, Pragma Exception Init().
Created Materialized Views And Partitioning Tables For Performance Reasons.
Monitoring Day-To-Day Process For Different Data Loads And Resolving Issues.
Responsible For Tuning Of Sql Queries Written In Procedures/Function At Teh Back End .

Technology &Tools Used: Oracle 10g/11g, Sql*Plus, Toad, Windows

We provide IT Staff Augmentation Services!

,

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship