Oracle Quality Assurance

Brian H. Blades

Flemington, NJ ***** (H) 908-***-****

********@*******.*** (C) 732-***-****

SENIOR ORACLE DATABASE ADMINISTRATOR (DBA)

Oracle DBA with over 10 years experience with implementation, maintenance

and performance of Oracle databases in a UNIX environment and more than 5

years of experience installing and maintaining Oracle E-Business Suite

projects. Monitors applications, diagnoses and resolves performance issues,

reviews and optimizes application deployment documentation and proposed

Standard Operating Procedures (SOPs), and implements changes with possible

SOX implications or critical time constraints. Collaborates with colleagues

to evaluate alternative solutions to customer issues, provides direction to

formal project teams comprised of functional application users, developers

and senior management, and responds to developer and user impromptu

inquiries.

COMPENTENCIES

Oracle 7, 8i, 9i, 10g SQL Data pump

Oracle Case PL/SQL ITIL

ERWIN tkprof ITSM

ER Design Methodology SQLNAV OFA

UNIX RMAN OEM

HP-UX PVCS Remedy

ksh Advanced Queuing (AQ) TAF

EXPERIENCE

Merck & Co., Inc. 2000 to Present

Client-Facing Oracle Database Administrator, Whitehouse Station, NJ

Led DBA team managing finance, human resources, and research applications.

Responsible for implementation, maintenance, security, performance, and SOX

compliance of a significant portion of 1,500 databases.

. Identified changes to optimize SQL performance of a chemical structure

analysis system that established response time service level agreement

and reduced query completion time from 5 minutes to seconds.

. Improved performance of the financial accounting book close application

from 8 hours to 30 minutes to meet timing targets.

. Enhanced performance of the financial accounting book close application

to meet monthly schedule following data feed change from JD Edwards

system to new SAP system that increased data volume.

. Managed creation of upgraded (Oracle 10g) test and production databases

for shared data repository application concurrent with critical

conversion to new Hire-to-Retire system.

. Improved performance of shared data repository application to support

additional feeds with resources made available by SQL tuning and

environment modifications.

. Implemented the Oracle E-Business Suite employed by capital management

application to manage projects with a single global instance.

. Instituted SOX controls for critical financial databases; successfully

passed annual SOX audits for several years.

. Designed an environment to support TIBCO Information Integration Services

(TIIS) feeds to new SAP system and to provide a development framework for

new services.

. Diagnosed and resolved SQL performance problems in PeopleSoft databases

using outlines and hints.

AT&T (Contractor) 1999 to 1999

Oracle Database Administrator, Bedminster, NJ

. Provided Oracle DBA services in both development and test environments.

. Installed development, test, and production databases.

. Implemented backup and recovery procedures.

. Supported Quest tools for SQL tuning and development.

. Certified software for Y2K use.

Oracle Financials Database Administrator, Piscataway, NJ

. Provided services as an Oracle Financials (version 10.7 - 16.1 GUI)

database administrator.

. Diagnosed and documented problems and ensured conformity to center of

excellence standards.

Merrill Lynch (Contractor) 1998 to 1999

Oracle Financials Database Administrator, New York City, NY

. Monitored production Oracle Financials databases on Sun UNIX platforms to

ensure smooth operation and maximize throughput.

. Observed user sessions and jobs.

. Reviewed daily reports on concurrent processing and disk space

consumption.

. Created and sized new objects in development and quality assurance

databases.

. Collaborated with developers to tune SQL associated with customized

views.

AT&T 1994 to 1998

Oracle Financials Database Administrator, Piscataway, NJ

. Setup the Fixed Assets and General Ledger products in the Oracle

Applications databases.

. Installed and configured Oracle 7.1 for the Electronic Information

Factory project.

. Designed and developed databases using Oracle Case for the AT&T

Healthcare Group.

EDUCATION

Bachelor of Arts, Linguistics. Computer Science minor.

State University of New York, Stony Brook, NY

Contact this candidate