Oracle Quality Assurance

Bryan J. Judge

**** ******* ***** **** *****: (**4) 369-

8820

Ann Arbor, Michigan 48108 Cell Phone (734) 395-

5812

E-mail: **********@***.***

CAREER SUMMARY

Strong analytical and problem solving background with 16 years of Oracle

and Life Science Applications (OLS), including system implementation,

administration and computer system validation and laboratory automation.

Extensive knowledge of Oracle Database infrastructure and administration,

and ability to prepare system maintenance plans, Standard Operating

Procedures (SOPs) and Work practices. Excellent technical communication and

planning skills including successful full system disaster recovery plan and

testing with a remote vendor SunGARD. Extensive use of debugging and

optimization tools for Oracle and PL/SQL. Have a master level in use of

tkprof for both session and system level debugging, in support of Oracle

MetaLink, issue resolution. Familiar with Oracle Clinical (OC) study setup,

and SAS data extract view creation. Collaborate well between clinical,

safety, quality assurance and information technology groups for application

patches, upgrades and customization projects.

SELECTED ACCOMPLISHMENTS

Global Application Administration

Upgraded an aging and unreliable MetaFrame XP 1.8 for Remote Data Capture

(RDC) to a new Aventail VPN and Citrix MetaFrame 4. Load balanced external

RDC users with BIGIP F5. Created application disaster restore plan, and

restored to plan at remote vendor, SunGARD: 2005 and 2007. Assisted with

the installation and validation testing Integic ePower CRFWorkmanager in OC

4.5. To reduce manual correction and rework coordinated customization for

Data Clarification Forms, between quality assurance and data management.

Supported OC on Symantec/Veritas UNIX Cluster. Qualified Symantec Backup

Exec for rapid recovery of OC4.5 at SunGARD. Loaded latest WHODrug and

MedDRA dictionaries in TMS.

Laboratory Information Management

Implemented ISO 9000 Validation on Beckman LIMS with Online approval for

Product Assay Certificate of Purity. Designed and installed HP-UX Purge and

Trap based GC/MS

Validated Ingress Reporting System for sample Chain of Custody.

PROFESSIONAL EXPERIENCE

K-Force/Thomson Reuters, 777 Eisenhower, Ann Arbor, Michigan, 48108

9/2010 to 7/2011

Senior Oracle Database Administrator

. Designed and set-up environment for 32-bit and 64-bit Oracle and 64-

bit operating system.

. Applied database patches and upgrades, and application iPatches and

upgrades.

. Handled performance tuning and application monitoring with Quest TOAD

Oracle DBA Module, and Spotlight on Oracle.

. Performed troubleshooting on Oracle databases and determined RCA (Root

Cause Analysis).

. Supported existing backups through OEM and RMAN.

. Provided 24x7 on-call support for Production.

. Downloaded UNIX Oracle exports and imported using datapump into

requested databases as necessary.

. Performed database maintenance checks and services.

. Monitored and optimized SQL where necessary.

. Managed validated system changes using ITL standards.

. Technical Environment: Oracle 11g, Oracle 10g Enterprise, Quest TOAD

9 DBA Module, Windows XP Pro, Windows Server 2003 R2, Solaris, RMAN,

ssh, FTP, Putty, Terminal Services, Remote Desktop

DBMS Consulting, Ann Arbor, Michigan, 48108

7/2008 to 9/2010

Senior Oracle Life Sciences Administrator

. Designed and set-up environment for 32-bit and 64-bit Oracle and 64-

bit operating system.

. Applied database patches and upgrades, and application iPatches and

upgrades.

. Supported 200 concurrent JDBC OC4J - J2EE container based connections

to production, training and development servers.

. Handled performance tuning and application monitoring with Quest TOAD

Oracle DBA Module.

. Performed troubleshooting on Oracle Clinical databases and determined

RCA (Root Cause Analysis).

. Implemented script to perform the following:

o Connect to remote UNIX OC box.

o Identify OC Session deadlocked.

o Send UNIX e-mail to Level 3 support staff Blocking users on the

system, to permit manual session termination.

. Supported existing backups through OEM and RMAN.

. Provided 24x7 on-call support for Production.

. Downloaded UNIX Oracle Clinical, and Sapphire LIMS exports and

imported into requested databases as necessary.

. Performed database maintenance checks and services.

. Monitored and optimized SQL where necessary.

. Managed validated system changes using ITL standards.

. Technical Environment: Oracle 10g Enterprise, Quest TOAD 9 DBA

Module, Windows XP Pro, Windows Server 2003 R2, Solaris, RMAN, ssh,

FTP, Putty, Terminal Services, Remote Desktop

UNITED HEALTH/INGENIX/STATPROBE, Ann Arbor, Michigan, 48108

5/5/2003 to 7/2008

Oracle DBA and Clinical Systems Architect

. Designed and set-up environment for 32-bit and 64-bit Oracle and 64-

bit operating system.

. Supported 80 concurrent JDBC OC4J - J2EE container based connections

to production, training and development servers.

. Designed and implemented Oracle Clinical backup and restore

procedures.

. Applied database patches and upgrades, and application iPatches and

upgrades.

. Implemented development, validation and production Northrop Grumman

ePower CRF Workmanager.

. Performed server trend analysis and stats pack for forecasting and

capacity planning.

. Provided 24x7 on-call support for Production.

. Performed database maintenance checks and services.

. Monitored and optimized SQL where necessary.

. Performed Disaster Recovery, at SunGard and supported 14 Windows

Servers and 4 UNIX Servers.

. Technical Environment: Oracle 9i Enterprise, ePower, Quest TOAD 8 DBA

Module, Windows XP Pro, Windows Server 2003 R2, Solaris, RMAN, ssh,

FTP, Putty, Terminal Services, Remote Desktop

PFIZER GLOBAL-RESEARCH & DEVELOPMENT, Ann Arbor, Michigan, 48105

5/1/1995 to 5/1/2003

Global Infrastructure Lead

. Applied database patches and upgrades, and application iPatches and

upgrades.

. Performed database maintenance checks and services.

. Monitored programs to reduce running time.

. Monitored and optimized SQL where necessary.

. Supported 180 concurrent Oracle Forms, Reports, Discoverer connections

to production, training and development servers.

. Supported 9 Windows Servers, 3 Digital VAX Servers and 4 UNIX Servers.

. Technical Environment: Oracle 9i Enterprise, Quest TOAD, Windows XP

Pro, Windows NT, Solaris, Digital VAX, HP-UX, RMAN, FTP, Terminal

Services, Remote Desktop

BAYER/MOBAY, Baytown Texas 77520

5/1/1988 to 5/1/1995

Beckman LIMS Team Lead

. Designed and set-up environment for 32-bit Oracle and 32-bit operating

system.

. Designed and implemented Beckman backup and restore procedures

. Designed and implemented RGen Report improvements and chain of custody

distribution.

. Documented all problems found and the solutions.

. Implemented ISO 9000 Validation for Beckman LIMS.

. Performed database maintenance checks and services.

. Monitored programs to reduce running time.

. Supported 4 Windows Servers, 6 Digital VAX Servers and 3 HP-UX

Servers.

. Technical Environment: Oracle 7 and 8i Enterprise, Windows 95,

Windows NT, Digital VAX Solaris, HP-UX, FTP, Terminal Services, X-

Terminal

EDUCATION

M.S. Applied Physics, 1993

University of Houston, Clearlake, Texas

Concentrated on GC-MS based analytical standardization, and sub-part per

million election capture detectors (ECD).

B.S. Chemistry, 1988 Wayne State University, Detroit, Michigan

Concentrated on advanced Instrumental Analysis. One-year undergraduate work

with Stanley Kirschner, optical rotation in complexes of Ethylenediamine

with Cobalt, and dropping mercury electrode simulation using Apple

Macintosh based LABVIEW.

Other Relevant Training

TMS Advanced Dictionary Loading and customization (BioPharm)

Intro to and Advanced PQ/SQL (Troy, Michigan)

Oracle Database Administration (Troy, Michigan)

HP-UX System Administration (Farmington, Michigan)

Dale Carnegie Human Relations Graduate Assistant

Presentations

Installation and Performance Tuning of Oracle Clinical 3.1.1, A&CM Focus

Group, Oracle Clinical Users Group - Paris 1999.

Keywords

DBA, Oracle Remote Data Capture, Oracle Clinical, Oracle Thesaurus

Management System, ARISg, ePower, architect, analyst, optimization, special

projects, structured query language

Contact this candidate