TECHNICAL SKILLS:

Technical: Oracle 8i/9i/10g/11g RAC, ASM, OEM11, OEM12c, DataGuard Toad, SQL Developer Linux, Unix (HP - UX), Unix and Linux shell scripting IBM Rational Clear Case, GIT source code manager Worked specifically with Oracle 11g and RAC, Toad 11, and OEM12c when upgrading a data warehouse to Oracle 11.2.0.2. Monitoring of the warehouse processes and performance and tuning of individual queries was performed using Toad, OEM and Oracle-provided packages and procedures (ASH, AWR, ADDM).

WORK EXPERIENCE:

Confidential

Oracle Senior DBA

Responsibilities:

• Creation, Modification and Support of data and data structures to support custom Java applications within Confidential
• Managed performance tuning of components within the LensCrafters Order Processing systems as in-store systems were being converted to new Oracle 11g RAC databases communicating to a central database. Performed the design, coding and testing of modifications to Oracle procedures associated with the features on LensCrafters.com. All of this required direct interface with business partners in order to get these database changes approved, scheduled, executed and tested.

Confidential

Oracle Senior DBA

Responsibilities:

• Installation, configuration and upgrading of Oracle server software and related products.
• Contract assignment at GE Aviation. Created and managed a new Vitality Program for GE Aircraft Engines to upgrade their Oracle databases and remain current when applying Critical Patch Updates on all of their eligible databases. I had to interface directly with business partners in order to get these database changes approved, scheduled, executed and tested.

Confidential

Oracle Senior Application DBA

Responsibilities:

• Maintained development, QA and Production databases.
• Identified, tested and resolved complex database issues.
• Participated in the 24x7 production support on-call rotation.

Confidential

Oracle Senior Application DBA

Responsibilities:

• Maintained development, QA and Production databases. Oracle 11g RAC ASM and DataGuard.
• Identified, tested and resolved complex database issues.
• Performed Oracle SQL, database tuning and performance monitoring using OEM12c and Toad.
• Performance tuning in the RAC environment with Oracle Grid 12c monitoring
• OEM12c and RMAN backup/restore of Oracle 11g RAC ASM databases.
• Implemented and maintained database security.
• Suggested the setting of certain tuning parameters in the databases and monitored for the impact as the parameters were adjusted.
• Participated in the 24x7 production support on-call rotation.

Confidential

Oracle Application DBA

Responsibilities:

• Identified, tested and resolved complex database issues.
• Performed Oracle SQL, database tuning and performance monitoring using OEM and Toad.
• Suggested the setting of certain tuning parameters in the databases and monitored for the impact as the parameters were adjusted.

Confidential

Project Manager/Oracle System DBA

Responsibilities:

• Created and implemented data models, database structure design and backup & recovery processes for Development, QA and Production databases. Used OEM, RMAN and shell scripts to implement database backups.
• Established and maintained sound Backup and Recovery policies and procedures for all applications.
• Performance tuning in the RAC environment with Oracle Grid 10g monitoring
• OEM and RMAN backup/restore of RAC databases.
• Defined, recommended and developed database standards and procedures.
• Identified, tested and resolved complex database issues.
• Performed Oracle SQL, database tuning and performance monitoring in RAC and non-RAC environments using OEM and Toad.
• Implemented and maintained database security.
• Suggested the setting of certain tuning parameters in the databases and monitored for the impact as the parameters were adjusted.

Confidential

Oracle Application DBA/Oracle System DBA

Responsibilities:

• Created and implemented data models, database structure design and backup & recovery processes for Development, QA and Production databases. Used OEM, RMAN and Unix shell scripts to implement database backups.
• Established and maintained sound Backup and Recovery policies and procedures for all applications.
• Performance tuning in database environments with Oracle Grid monitoring
• OEM and RMAN backup/restore of RAC and non-RAC databases.
• Defined, recommended and developed database standards and procedures.
• Identified, tested and resolved complex database issues.
• Performed Oracle SQL, database tuning and performance monitoring using OEM and Toad.
• Implemented and maintained database security.
• Suggested the setting of certain tuning parameters in the databases and monitored for the impact as the parameters were adjusted.
• Participated in the 24x7 production support on-call rotation.

Confidential

Project Manager/Application Developer

Responsibilities:

• Project manager and technical leader for Customer Business Development reporting system.
• Completely redesigned the application using Visual Basic, MS Access, and a file transfer connection to Lotus Notes.

Confidential

Application Developer

Responsibilities:

• Member of team which performed rewrite of the original P&G order, shipping and billing system. Started as a COBOL/DB2/CICS application designer/programmer. Moved to the project technical support team as development support manager and DB2 DBA. Ended the assignment as the production technical support specialist and performance manager.

Confidential

Staff Consultant

Responsibilities:

• Worked as designer/programmer for several companies, including Procter & Gamble.