Oracle Developer Resume Virginia Beach, VA - Hire IT People

SUMMARY

4+ years of programming experience as an Oracle Developer PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System.
Experience with Software Development Life Cycle (SDLC) process, performing detailed analysis, collecting requirement, coding and unit testing, integration and system testing.
Experience in development of applications using Oracle 11g, SQL, PLSQL.
Experienced working in Agile Methodology and Water Fall Model.
Experience with Client interaction, adherence to client specifications, system enhancements, understanding business data flow, data relations and production system support.
Proficient working experience with SQL, PL/SQL Stored Procedures, Functions, Packages, Database triggers.
Experienced in debugging the code and Analysis the data for various reporting and analysis purpose.
Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
Tuning of SQL Queries to improve performance of a system.
Identify root causes and resolve problems related to system functionality.
Analytical and skilled in understanding business problems and develop systems that improve functionality.
Skilled in working effectively in collaborative and self - motivated environments.

TECHNICAL SKILLS

Programming Languages: SQL, PL\SQL

Web Technologies: HTML, CSS

Databases: Oracle, MS access

Operating Systems: UNIX, Windows 95/98/NT/2000/XP, Linux

Tools: Oracle 11g, PL\SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

Oracle Developer

Responsibilities:

Custom tables and new custom objects were designed as per business requirements.
Created database triggers to validate complex integrity.
PL/SQL Procedures, functions, cursors, triggers and packages were created using TOAD.
Used Control Structures like IF, CASE, FOR, and WHILE Loops for standard PL/SQL programming.
Created new database objects like Procedures, Functions, Packages, Triggers, Indexes, Views using SQL in Development and Production environment for Oracle 10g and was involved with the Performance tuning, Optimization of queries and standardization of the code.
Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
Developed Stored Procedures to include in the existing Packages and used the same to set up scheduler Jobs.
Performed Extraction, Transformation, and loading (ETL) data from various sources into Data Warehouses.
Developed SQL and PL/ SQL scripts for migration of data between databases.
Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, complex database triggers and data migration scripts.
Responsible for raising Change requests and Change schedules for Database change management using Remedy Change Management Software.
Responsible for keeping all three environments PROD, UAT and DEV in sync for phase wise production releases and DB change management.
Developed Master Detail, Detail reports using tabular and Group above reports.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL Developer.

Confidential

Database Developer

Responsibilities:

Working with users to establish and meet business needs.
Well conversant in translating business requirements into creation of database objects using Oracle Server and PL\SQL Tool.
Involved in coding, issue analysis and implementation.
Created SQL queries for back-end testing to check information is stored correctly in the database.
Tested programs and databases and made necessary modifications.
Created scripts and processes for data integration and maintenance.
Maintained the database using Procedures, Functions, Cursors and Triggers.
Testing Performance and availability of an application.
Extensively involved in writing and Executing Test cases.
Designed and Analyzed Test case design document basing on the Functional Requirement Specifications to implement through Testing process.
Involved In various Testing like Functional Testing, Regression Testing, User Acceptance Testing.
Using internal tools and aiding development team to identify bugs and improve functionality.
Participated In daily Scrum Meeting.
Proficiency at grasping new technical concepts quickly and utilizing the same in a productive manner.
Optimizing database performance and scalability.
Handled Production Issues on high priority.

Environment: Oracle 11g, Pl/SQL Developer.