Oracle PL/SQL Developer Resume

PROFESSIONAL SUMMARY:

Over 2 years of diversified experience working in the Information Technology industry primarily as an Oracle PL/SQL developer.
Skilled at Analysis, Design, Development, Support, and Performance tuning of applications using Oracle SQL, and PL/SQL. Worked with a financial client, and implemented business driven functionality using Oracle 11g/10g for development, data conversion, and migration projects.
Excellent skills in writing PL/SQL Stored Procedures, Functions and Packages using Oracle 11g/10g.
Expertise on Ref Cursor, External Tables , Dynamic SQL, Collections and records and Exception handling .
Strong experience in Cursor management, Exception Handling, performance tuning (PL/SQL), and optimization of SQL statements using SQL Trace, Explain Plan, Indexing, and Hints.
Expertise in creating and maintaining Table Partitioning, Collections and records, Analytical functions, Materialized Views, Query Re - Write , and Transportable table spaces.
Experience in Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Datastage as ETL tool on Oracle.
Expertise skills in using the tools TOAD, SQL *Loader, Oracle SQL Developer and Oracle utilities like DBMS PIPE, UTL FILE, Exp, Imp and Data pump.
Experience with Agile practices such as Backlog Grooming, Sprint planning, Story sizing, Story Prioritizing, Standup meetings, and User Story Demos on Agile Project implementation.
Having Good understanding and experience of Object Oriented Concepts.
Wrote Queries to retrieve data in XML format from the tables.
Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP , and Exp/Import .
Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Operating Systems: Windows XP/7/Vista, UNIX, Linux

Databases: Oracle 11g/10g/9i, Sybase

Tools: Toad, SQL Developer, SQL *plus, SQL *loader, Eclipse IDE, SQL Server

Environment: UNIX, Solaris, Red Hat Linux, Windows XP/ 2007/2008/2010

Scripting: SQL, UNIX Shell Scripting, Perl and JavaScript

ETL Tools: DataStage

Languages: Oracle SQL, PL/SQL, T-SQL, Java, C, C++, Perl, and UNIX shell

Web Technologies: Java, HTML, XML, CSS, Google Search API

Source Control: Clearcase, SCCS, Git

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL Developer

Responsibilities:

Written PL/SQL Procedures, Functions, Packages, and SQL Scripts using Oracle SQL and PL/SQL.
Developed data model, PL/SQL Queries, SQL Query tuning process, and Schemas.
Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.
Experience working with Oracle CLOB, BLOB, Materialized Views, Ref Cursors, Index Organized Tables, Partitions, Objects/Collections, Execute Immediate etc.
Formulated SQL queries, functions and processes as per requirement.
Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages.
Worked with developers to repair and enhance current base of PL/SQL packages to fix testing issues.
Built new functionality and improve processing time through code optimizations and indexes.
Performed SQL and PL/SQL tuning and Application tuning using various tools like Oracle Hints, EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
Written packages, triggers, stored procedure and functions for Solvency project which involved retrieving data using FTP, scheduling through AUTOSYS, extracting and loading using ETL (DataStage) and PL/SQL.
Responsible for Unit Testing of Database PL/SQL Packages, Procedures, Functions and Database Triggers.
Defect tracking through JIRA and defect summary reporting.
Proficiency with SCCS and Clearcase version control systems.
Worked on agile and test driven environment, participated on daily scrum meeting, and discussions.

Environment: Oracle 10g/11g, SQL, PL/SQL, SQL *Loader, UNIX Shell scripts, SCCS, Clearcase, Agile and Waterfall methodologies, Windows XP, JIRA, MS Excel, Putty, notepad++ etc.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship