SUMMARY:

• ORACLE 7X - 11G Performed oracle upgrades of all servers including widows and AIX (L-pared).
• Set up R-man backup - recovery systems as both stand alone and as part of CommVault enterprise backup - recovery system.
• Tuned all oracle instances at the database, storage, and sql level. Made heavy use of TKPROF to identify problem statements.
• Implemented Dataguard to set up a reporting server.
• Performed numerous database refreshes, usually 2+ per week, utilizing both Datapump and R-man.
• Used SQLLoader to to load data into archival data from legacy system being discontinued.
• Set up RAC as proof of concept on AIX servers.
• Utilized OEM to monitor and help tune database instances.
• Utilized Datapump to move tuning enhancements between databases. Also used OEM to schedule Oracle jobs. Set up health checks and reports using OEM,
• PeopleSoft 7 - 9.X Both FINancials and HCM environments.
• PeopleSoft - PeopleTools Upgrades: Instrumental team member of all upgrade projects.
• Performed database backups as indicated by Upgrade Assistant. Modified database memory parameters to accommodate long running processes, often put tables in parallel mode to facilitate loading, modified scripts that could be run in parallel, and ran directly on the server. Ran numerous DataMover scripts as part of the upgrade project. Built temporary indexes as needed for performance issues
• Utilized Application Developer to find and modify PeopleDode that was identified as performance issue. Performed numerous traces on Application Server to identify performance issues.
• Used Process Monitor to identify process scheduler jobs that were going to error. Modified Application Engine to add hints to use specific indexes.

PROFESSIONAL EXPERIENCE:

Confidential

DATABASE ADMINISTRATOR

Responsibilities:

• Implemented Oracle Internet File System with Oracle 9I, used to store policies & procedures for the entire health system.
• Designed Disaster Recovery Program with twice yearly testing of each system to comply with external auditing requirements
• Also provided complete step by step documentation along with check off list that could be followed by someone only familiar with Oracle in event that DBA was not available due to disaster, vacation, etc.
• Performed twice yearly disaster recovery tests at external recovery site.
• Completed installation & upgrades to PeopleSoft databases and applications serving 13 hospitals served by Confidential .
• Managed over 20 environments to support both FINancial and HR services across the entire health system of 5,000 users.
• Performed cross platform migration of FIN environments from Digital True64 Unix environment to AIX platform along with a database version upgrade .
• Performed cross platform and database conversion from Sybase on HP-UX platform to Oracle on AIX.
• Implemented Oracle Data Guard to create reporting environment on development server from production environment.
• Migrated legacy flat file database to Oracle using SQLloader.

Sr. PeopleSoft Technical Consultant

Confidential, Boston, MA

Responsibilities:

• Performed on-going database tuning, identified tables that would benefit from Oracle parallel query option. Modified Application Engine to perform a complete rollback on error. Worked extensively with explain plans generated from cobol pgms, sqr reports, application engine pgms, nvisions to optimize use of indexes.
• Conducted class for sqr programmers - How to structure programs that make the best use of indexes.
• Participated in upgrade project from Oracle 7.3 to 8.0
• Helped troubleshoot and correct problems associated with E.D.I.
• Performed extensive compare reporting to doccumment changes made to production that will need to be addressed during next upgrade.
• Also used this process to document differences between various environments.

Confidential, Pasadena, CA

Database Administrator / Unix System Administrator

Responsibilities:

• Computerized Maintenance Management System.
• System is designed to handle both reactive and proactive maintenance for two plants, as well as all underground infrastructures throughout the city.
• Managed the requirement definition, request for proposal, vendor selection and implementation of the Confidential .
• Used ERwin data modeler to create schema's .
• Laboratory Information System (LIMS) - replacement - to handle multiple laboratories, and multiple plants.
• Managed the requirement definition, proposal, and vendor selection.
• Responsibilities included requirement definition, request for proposal, vendor selection, and implementation of LIMS.
• In conjunction with Engineering Department, managed requirement definition, request for proposal to have graphical information converted into a GIS coverage, link all attribute data to each piece of infrastructure.
• To include the digitization of all underground infrastructures that are water related.
• Used ERwin datamodeler to reconcile schema's between differing systems.
• Migrated existing databases from Informix to Ingress using native Informix tools. This was also cross platform
• Migrated existing Ingress databases to Oracle, using standard Ingres tools. This migration was also cross platform.