Oracle Database Developer Resume Cranberry, PA - Hire IT People

SUMMARY

IT professional with 9 years of industry experience and a specialization in Oracle software

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Oracle Database Developer

Confidential, Cranberry, PA

Responsibilities:

Wrote Linux Shell Scripts to ftp files, run SQL Loader and call PL/SQL stored procedures.
Wrote PL/SQL stored procedures.

Oracle Database Developer

Confidential, Pittsburgh, PA

Responsibilities:

Worked with large amounts of data in an Exadata environment to process data delivered to an external table or staging table.
Massaged the data to conform to our data warehouse standards. Aggregated data to enable ease of reporting.
Participated in code reviews, both as a reviewer and as the subject of the review, to ensure code conformed to our layout, naming conventions, syntax and logic.
Maintained scheduled job execution using Automic scheduling tool; job schedule ran 24 hours a day, 7 days a week.

Oracle Database Developer

Confidential, Pittsburgh, PA

Responsibilities:

Created PL/SQL package and triggers to migrate data from a legacy database to a database supporting web applications.
This was part of the process of migrating Confidential from Oracle Forms and Reports to a database supporting Java.
Created PL/SQL procedure to synchronize 3 Confidential databases in 3 different locations and time zones for Confidential .
The UNIX scheduling software ran this procedure daily.
The code had to be identical on all three databases for ease of maintenance.
Supported logistics customers to debug code or instructed how to use the Oracle Forms and Reports.
Support was available 24 hours a day, 7 days a week.
Created barcode labels for Confidential by using Bartender software to create the Zebra code to insert into an Oracle Form.
This was used to process returns at return centers around the country.

Database Developer (Internship)

Confidential, Latrobe, PA

Responsibilities:

Personal Computer Technician

Confidential, Pittsburgh, PA

Responsibilities:

Removed viruses & spyware from customer computers; specialized in Microsoft Windows desktop and laptop repair.

Oracle Database Developer

Confidential, Pittsburgh, PA

Responsibilities:

Utilized Oracle PL - SQL, procedures, functions, SQL, dynamic SQL, table design, performance and statement tuning and large data sets to complete tasks as required.
Created technical documents to support the software development life cycle.

Database Developer

Confidential, Pittsburgh, PA

Responsibilities:

Gathered user requirements for a women’s membership satisfaction survey.
Created the Oracle Form to enter the data, created the tables to house the data, and created the Crystal reports to use the data.
Created Oracle Forms & Microsoft Access Forms to maintain databases; Utilized Crystal Reports to monitor membership activity.