We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Jersey City, NJ

SUMMARY

  • Around 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS).
  • Expertise in database design and development on client/server applications using Oracle 11g/10g/9i/8i, SQL, and PL/SQL
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing and maintenance with timely delivery.
  • Worked extensively on Stored Procedures, Triggers, Functions and Packages.
  • Experience with Data flow diagrams, Entity relation modeling and design techniques.
  • Involved in creating database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL plus.
  • Involved in data loading using PL/SQL and SQL Loader.
  • Good experience in writing UNIX shell.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Involved in Performance tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • Expertise in working with built - in packages like DBMS LOB, DBMS SQL, DBMS SHEDULER, DBMS DDL, UTL FILE
  • Experience in working with different operating systems like Windows,UNIX and Linux.
  • Ability to work independently and adapt quickly to new and emerging technologies.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle, MS SQL Server & MYSQL

Scripting: UNIX Shell Scripting

Languages: SQL, PLSQL, CORE JAVA, J2EE, UNIX, C & C++.

Tools: SQL Developer, TOAD, SQL plus, PUTTY, WINSCP.

Data Modeling: Erwin 7.3, SQL Developer, Toad.

Markup Languages: JavaScript, HTML, XML, CSS.

Operating Systems: Windows, UNIX, Linux.

Ticketing Tools: BMC Remedy, JIRA.

Version Control: CVS, SVN, Clear Case & GitHub

Software Methodologies: Agile & Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Oracle PL/SQL Developer

Responsibilities:

  • Responsible for Analysis, Design, Coding, Debugging and testing the processes/programs that are necessary to extract data from Operational Databases, transforming and cleaning the data and loading it to data ware house.
  • Worked in an Agile Environment and participated in requirement gathering.
  • Involved in both front-end and back-end development using simple and complex SQL/PLSQL like Stored Procedures/Functions/Package/Triggers, Collections & REF Cursors as per Business Requirements.
  • Analyzed and designed relational databases using ER Studio and Erwin Data Model Tool.
  • Creation of database objects like tables, views, synonyms, materialized views using Oracle tools like PL/SQL developer.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
  • Created Database links to connect to remote databases and to be able to pull data, perform joins to manipulate the data.
  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • As the project deals with huge amount of usage data, Partitioned tables to enhance the performance, manageability, availability and eliminate the down time on frequently used usage related tables.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Involved in creating unix shell scripting.
  • Involved in performance tuning using tools like EXPLAIN PLAN, SQL*TRACE & TKPROF.

Environment: Oracle Database 11g, PL/SQL, SQL, TOAD, Erwin, Unix shell scripts and XML.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Worked in an Agile Environment and participated in requirement gathering, analysis and design.
  • Designed Logical and physical data models for BN database schemas using Erwin.
  • Worked on the bulk uploading of huge amounts of statistical data to the database.
  • Wrote loader scripts using SQL Loader/External tables to load large tables.
  • Responsible for developing and modifying several PL/SQL packages procedures, functions, views and triggers using PL/SQL to effectively in corporate Business rules.
  • Involved in writing the database triggers to furnish the audit details.
  • Involved in creating complex views that require complex joins.
  • Creating and modifying several Unix Shell scripts according to the changing needs of the project and client requirements.
  • Developed SQL queries to provide reports to business team.
  • Involved in Extraction, Transformation and Loading (ETL) of the data in the table for Oracle database.
  • Worked on SQL Loader to extract data from flat files obtained from various sources using standard packages like UTL FILE & DMBS SQL.
  • Scheduled the Jobs for loading data using DBMS SCHEDULER.
  • Optimized/Tuned SQL/PLSQL by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes to improve database response time and performance for several applications.
  • Debugging Procedures & Functions and improving the performance of application.

Environment: Oracle 11g, SQL, PL/SQL, SQL LOADER, Erwin and Unix Shell Scripts.

Hire Now