Manager Oracle

Bella S. Zugates

*** ***** **** ****, ******, MD, 21286

Mobile 443-***-**** Home 410-***-****

abnqye@r.postjobfree.com

Objective:

Obtain a challenging position in a PeopleSoft Administration/Oracle DBA role. Technical experience

includes Oracle 7x, 8x, 8i, 9i (Unix HP, Unix Sun, Unix AIX, NT/2000, Windows 2003/2007)

PeopleSoft 7 and 8. I am highly skilled in coordinating all aspects of delivering a project on time to meet

the goals and objectives of the client.

Technical Skills:

13+ years: SQL

6+ years: Certified oracle DBA, PL/SQL, korn shell scripting, PeopleSoft DBA

5+ years: RMAN

4+ years: UNIX HP, Unix Sun/Solaris, Shareplex (Replication Software)

5+ years: EMC, Veritas, Netbackup

2+ years: IMB AIX, Veritas Cluster

Databases:

Oracle (7x, 8, 8i, 9i), Microsoft SQL Server, Sybase, DB2

Languages:

SQL, PL/SQL, Perl, ASSEMBLER, Fortran, COBOL, COBOL II, CICS (Macro/Command Level),

BMS, IMS DB ((DL/1) Call & Command Level), OCL, JCL

Software:

RMAN, BEA Weblogic, PeopleSoft Financial (PT6, PT7, PT8), PeopleSoft HR (PT7, PT8), Quest Stat,

Quest SharePlex, TSO/ISPF, VSAM, CDB Utilities, DB2 Utilities, EASYTRIEVE, REXX, QMF,

SPUFI

Education:

Oracle Certified Professional (OCP 9i)

Bachelor of Arts - 1976

Professional Experience:

Choice Hotels International Mar 2004 Present

Sr. Database Administrator (Oracle)/PSAdmin

• Install, configure PeopleSoft Software, BEA Weblogic/PIA, PeopleSoft Process Scheduler and

Application Server.

• Performed PeopleSoft project migrations using PeopleSoft and Quest’s STAT Software

• Performed Tools Upgrade

• Responsible for 35+ Production/Development PeopleSoft HR/FIN/EPM and non-PeopleSoft

databases residing on UNIX Sun Solaris using EMC storage.

• Create databases, clone databases using RMAN clone method and OS hot backups

• Install and upgrade oracle software

• Upgrade databases utilizing upgrade method and export/import method

• Create and implement RMAN backups and OS hot backups with automated notification of backup

completion status

• Develop, implement and test disaster recoveryprocedures utilizing various approaches:

RMAN, OS hot backup and Standbydatabase

• Tune long running queries

• Install and configure Quest Central

Bella S. Zugates

803 Stags Head Road, Towson, MD, 21286

Mobile 443-***-**** Home 410-***-****

abnqye@r.postjobfree.com

BC Madison Consulting Mar 2002 Mar 2004

Independent Consultant

Client: Dorado Inc (December 2003 January 2004)

• Create hot backups procedure utilizing shell scripting. Due to space limitation on the database server

hot backup was done to a remote server using SQL/PLUS scripts and RSYNC OS command. As

part of the hot backup process, create and implement real-time backup of archived logs to the

remote location. Perl scripts are used to analyze alertSID.log and identify archived redo logs for the

remote backup.

Client: Metropolitan Police Department District of Columbia (Apr 2003 Oct 2003)

• Received FBI clearance through MPD in July 2003.

• Provide Oracle DBA support in design and development of GIS database application using ESRI

ARCSDE. The involvement includes business requirement analysis, documentation and presentation

of the suggested design to the client; physical and logical database design; space utilization; growth

projection; hardware configuration; analysis and recommendation of RAID configuration for

development/test and production environments.

• Create backup and recovery process to address development and production needs. Design,

document and implement backup process using RMAN. The process includes identification and

cleanup of old backups and logs.

• Provide Oracle DBA support in development and implementation of data replication process

between two government agencies. The project involved extraction of data from source mainframe

database and load of extracted data into temporary oracle tables using SQL Loader. The second part

of the replication process included manipulation of oracle data using PL/SQL packages which

applied business rules and requirements to the data in temporary tables and inserted/updated

permanent oracle tables. The updated data was made available to the second agency’s SQL/Server

processes for insert/update of the target database. The process was designed/coded to send a text

message to the DBA team’s cell phone in case of error in the process.

Client: Hewlett Packard (Mar 2002 Dec 2002)

• Provide Oracle DBA/PSAdmin support in migration of 40+ PeopleSoft E-Center clients from

Solaris to HP-UX; installed and configured PeopleSoft HRMS/FIN (8.16.00) in 2, 3 and 4-tier

environments.

• Provide issue resolution during migration. The Issue resolution involved identification of the

problem areas, as network, database or application problem; scheduling and coordinating resolution

implementation with appropriate teams; informing clients on the process resolution

Sylvan Learning Center Nov 2001 Mar 2002

Manager, Database Administration

• Responsible primarilyfor the establishment and execution of backup/disaster recoveryprocedures

and tuning of Oracle and MS SQL environments in support of PeopleSoft Financials web-based

applications.

Bella S. Zugates

803 Stags Head Road, Towson, MD, 21286

Mobile 443-***-**** Home 410-***-****

abnqye@r.postjobfree.com

Provided technical mentoring and leadership to a team of Oracle/MS SQL Server DBAs and

•

PeopleSoft Administrators.

E stablished and implemented standards, procedures, and delivery of projects to internal corporate

•

clients.

USinternetworking, Inc. Jan 1999 - Nov 2001

Manager, Database Administration (Oracle/SqlServer)

• Hands-on manager of database administration/ implementation team.

• Responsibilities included the implementation and upgrade of PeopleSoft software, configuration of

Process Scheduler, and installation/configuration of the PeopleSoft Application Server.

• Performed database backup and recovery, performance analysis, standards definition and execution for

Oracle (UNIX and WindowsNT) and MS SQL Server environments.

Database Administrator (Oracle)

• Responsible for database support along with disaster and backup recoveryof USi’s largest PeopleSoft

Financial and data warehouse client whose environment consisted of three separate configurations -

production, reporting, and development.

• Responsible for ensuring high availabilityof the production environment; consistencyand functionality

between the production environment and the disaster recoverysite.

• Implemented and maintained database replication using Quest software and failover using Veritas

cluster between production and disaster recoveryenvironment to ensure high availabilityof the

production environment.

First National Bank of Maryland Feb 1993 - Dec 1998

Database Administrator (Oracle)

• Responsible for the creation and maintenance of multiple databases for PeopleSoft HR application

system residing on UNIX AIX.

• Responsible for ensuring the recoverabilityof databases bydesigning and implementing backup

procedures for client-server based applications.

• Developed, implemented and tested disaster recoveryprocedures with the remote site.

• Upgraded Oracle software from x to Y and developed scripts to export/import data, examine space

utilization, analyze and improve performance.

• Provided technical support for PeopleSoft development staff.

Database Administrator (SYBASE/SQL Server)

• Provided technical support for a customer profitabilitysystem (CRISP) which utilized MS SQL

database.

• Responsible for creating and maintaining numerous development and production database

environments.

• Developed and implemented backup/recoveryprocedures.

Database Administrator (DB2)

• Provided technical support for the bank's various applications.

• Responsible for the installation and upgrade of DB2 system; creation and modification of tables;

establishment of backup/recoveryprocedures.

• Worked closelywith developers to ensure efficient access to DB2 tables.

Bella S. Zugates

803 Stags Head Road, Towson, MD, 21286

Mobile 443-***-**** Home 410-***-****

abnqye@r.postjobfree.com

Additional experience includes analyzing and improving performance, installing third partymonitors

•

(INSIGHT), recovering DB2 System for contingency testing, loading, recovering and reorganizing

tables, and responding to DB2 audit finding.

State of Maryland, Judicial Information Systems (JIS) Sep 1983 Feb 1993

Database Administrator (DB2)

• Played a leading role in the development of a newCourt Automated Indexing System (CAIS) for the

Circuit Courts of Maryland; designed and implemented a test environment using storage groups and a

production environment requiring user defined VSAM files.

Senior Programmer Analyst Specialist

• Led project development efforts including task identification, prioritization, scheduling and

management reporting.

• Designed and programmed an on-line CICS/batch system providing the Criminal Court jurypool

selection, notices, subpoenas and statistical reporting using IMS/DB as the database.

Contact this candidate