Oracle DataBase Administrator Resume Profile Boston, MA - Hire IT People

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DataBase Administrator

Upgraded AIX, SuSe Linux and Red Hat servers to latest OS release levels supported by application vendor.
Upgraded all Oracle version to an Oracle supported level, Databases upgraded from Oracle 10g to version 11G.
Performed install of Oracle 12C on new systems, along with performing a database multiple migration to the new version.
Performed numerous application upgrades and patches to enhance application functionality and fix problems encountered. Including applying WAR files to Tom Cat servers, and pushing new applications to Citrix servers.
Assisted with the migration of 10 Oracle databases from a retiring IBM SAN to a NETAPP filer system. This also included increasing size of file systems to allow for growth.
Setup Oracle RECOVERY MANAGER environment for 12 databases replacing the older method of performing nightly exports, allowing all databases to be recovered to Point In Time of failure.
Responsible for maintaining 12 databases, 6 Production environments and 6 test-train environments.
Performed troubleshooting of database performance and connectivity related to exchanging data loads from peripheral applications.
Responsible for 2 additional virtual application servers.
Managed hardware replacement at remote location.

Confidential

Independent Database Contractor

Duplicated 16 business critical Oracle databases to new environment utilizing R-man, and NET backup on AIX LPAR virtual servers.
6 databases were over 30 Tb in size. 4 of which needed to be converted from Solaris to AIX along with Oracle version upgrade to 11G.
Registered all databases with R-man repository for backups using NET backup
Configured all databases for GRID control
Installed MS SQL Server on 10 virtual servers.
Configured Database mail for problem notifications
Configured backup schedule
Performed backups and restored 100 databases to the new environment. 4 of which exceeded 25 Tb in size

Confidential

DATABASE ADMINISTRATOR

Implemented Oracle RAC environment utilizing AIX servers as proof of concept for an application being considered for purchase.
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 TEMPLE UNIVERSITY HEALTH SYSTEM.
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 using Oracle's migration workbench.
Implemented Oracle Data Guard to create reporting environment on development server from production environment.
Migrated legacy flat file database to Oracle using SQLloader.

Confidential

Sr. PeopleSoft Technical Consultant

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 document changes made to production that will need to be addressed during next upgrade. Also used this process to document differences between various environments.

Confidential

Compaq Multiprocessor servers - MS-Windows NT Server, Win95 Clients PeopleSoft Private Sector Financials V6, SQL Server V6.X
Tuned Data Base - Indexing, Clustering, Multi-Threading, ODBC, etc.
Helped tune SQR reports, Crystal reports.
Set up Oracle Enterprise Manager, re-compiled invalid packages, knowledge transfer to apply updates, helped with sizing for new server, reviewed and corrected bid specs for new server
Reorganized and resized tablespaces and datafiles to minimize fragmentation.