SQL Developer Resume

Executive Summary

7+ years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Management of projects using Oracle (Sql, PL/SQL).
5 years of experience working with Oracle 8i/9i/10g including PL/SQL programming.
Solid experience in translating business requirements into creation of Database Objects.
Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects – Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
Prepared BRS (Business Requirement Specifications) document that gives the detailed

Technical Skills

Operating System

Databases Environments

MS Windows 2000/NT/XP/NT & VISTA, MS DOS and UNIX

Oracle 8i, 9i (9.2.0.5, 9.2.0.6), 10g, 11g

Professional Experience
Confidential, Boston, MA Jan’2011 –TillDate
Oracle PL/SQL Developer,

Responsibilities:

Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
Used SQL loader to load the data from the files provided by the interfacing applications.
Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functionsas part of Project/Application requirements.
Created partitioned tables and partitioned indexes to improve the performance of the applications.
Designed, developed and customized forms by using Oracle Forms 6i and Reports 6i.
Wrote PL/SQL Database triggers to implement the business rules in the application.
Created external tables to handle huge volumes of data which is not used frequently.
Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making.
Implemented all modules logic by using Triggers and Integrity Constraints.
Good understanding of database objects and ability to triage issues.
Involved in PL/SQL code review and modification for the development of new requirements.
Created materialized views required for the application.

Environment:
C, C++, UNIX Shell Scripting, Forms , PL/SQL, Oracle 10g,11g.

Confidential,NJ March’2009 – Dec’2010
Oracle PL/SQL Developer,

Responsibilities:

Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
Involved in Unit Testing Stored Procedures and Functions.
Created Materialized Views and partitioning tables for performance reasons.
Worked on various backend Procedures and Functions using PL/SQL..
Troubleshooted performance issues and bugs within packages, forms, and reports using dbms_output, Forms debugger, explain plan.
Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
Development of C modules for activation, deactivation and modification of these plans in Clarify Front End
Created SQL*Loader scripts to load data into the temporary staging tables.
Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
Used TOAD, PL/SQL developer tools for faster application design and developments
Developed procedures using Dynamic SQL..
Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
Created Materialized Views and partitioning tables for performance reasons.
Resolving the issues on priority basis.
Responsible for Analyzing and Implementing the Change Requests .
Involved in handling the changes in compiling scripts according to the database changes.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship