Michael McDonnell

(610) 279-8245 x12

 

____________________________________________________________________________________

 

PROFILE

Senior Database Administrator / Developer

Extensive DBA experience with Oracle databases. Projects have included: Physical database installation, configuration and daily administration; Database logical and physical architecture analysis, design and deployment; Analysis, design and development of data extraction, transformation and loading to support large and small multi-data source warehouses; Custom Unix Shell scripting used to perform database backups and daily database and system monitoring; Performance tuning for Database applications and batch data load processing. 

Principal Consultant             Aspect Consulting, Inc, Blue Bell, PA                                                   4/00-Present               

Senior Analyst/DBA. Consulting Assignments:

 

NCS Pharma R&D - Centocor., Malvern, PA (Technology Lead, Project Delivery, Oracle)                01/04-Present

·         Responsible for leading the database infrastructure used within R&D as well as coordinating with other IT / IM organizations and departments.

·         Provided database infrastructure support to the business functional area project pipeline.

·         Assist in the design, building, documenting and implementation of a SQL Server 2000 FDA Validation Installation and Operational Qualification process.

·         Extensive experience with documenting and working within validated Oracle / SQL Server environments including change control, and following QA/QC processes.

·         Shared support of 34 validated, 30 non-validated Oracle instances; 4 validated and 11 non-validated SQL Server named instances.

·         Oracle 9i OEM configuration for monitoring all Oracle databases.

·         Applications/Components supported include HP-UX, Linux, Sun, Windows NT/2000, Oracle 7.3 through 9.2 and SQL Server 2000.

·         TRAINING: Oracle Recover Manager

 

Centocor, Inc., Malvern, PA                                                                                    01/02-12/03

·         Design, code and implement backup/recovery strategy (hot, cold, import and export) on Windows Platform using Batch Shell scripts.

·         Design, code and implement database monitoring on Windows Platform using Batch shell scripts.

·         Assist in the installation and configuration of Agilent Chemstore application in a fully validated environment.

·         Assist in design, development and implementing an Oracle FDA Validation Installation and Operational Qualification process on both Windows and Unix platforms.

·         Developed and implemented Technical Operating Procedures for the installation, configuration and Backup & Recovery for SQL Server 2000.

·         Installed and configured multiple SQL Server 2000 instances to support development, staging and production application environments.

·        TRAINING:    Customized Windows 2000 Server Administration, SQL Server, PERL programming, VMWare Workstation 4 Technical Training

 

Harte Hanks, Langhorne, PA                                                                    08/01-12/01

·         Perform modifications to existing as well as create new PL/Sql procedures & packages to support consumer direct marketing.

·         Perform data extracts and formatting using existing and new PL/Sql procedures and packages.

 

Centocor, Inc., Malvern, PA                                                                                    06/01-08/01

·         Design, code and implement backup/recovery strategy (hot, cold, import and export) on Unix Platform using Korn Shell scripts.

·         Design, code and implement database monitoring on Unix Platform using Korn shell scripts.

·         Provide training, documentation and technical guidance to other Database Administrators.

·         Assist in installation and configuration of Oracle on new Unix platform.

 

Covance Periapproval Services, Inc, Radnor, PA                                                                 01/01-06/01

·         Assist in redesigning and stabilizing Unix platform, including backup/recovery, monitoring and exports.

·         Install, configure and create new databases on Unix and NT Platform including Oracle Clinical and Argus databases.

·         Design, code and implement backup and recovery strategy for NT Platform (Oracle 8i, 7.3.4).

·         Design, code and implement database monitoring on both Unix and NT platform (Oracle 8i, 7.3.4).

·         Design, code and implement database auditing on both Unix and NT platform (Oracle 8i, 7.3.4).

·         Provide training, documentation and technical guidance to junior DBA, and other IT personnel.

 

Purchasing Group, Inc. D/B/A  ICG Commerce, Jenkintown, PA                                         6/00-12/00

·         Created object types, object views, methods and procedures for use by web applications.

·         Design and write PL/SQL code to migrate data from live auction database into a historical database.

·         Wrote automated process to load data into an Oracle database using UNIX Shell scripts and SQL*Loader.

·         Identify and consolidate individual stored procedures into packages.

 

Covance Periapproval Services, Inc, Radnor, PA                                                                 11/00

·         Performed review and analysis of database deadlocks and database performance tuning.

·         Assisted in simplified code review, identifying potential deadlock and performance issues.

 

Russ Industries, Inc, New Jersey                                                               10/00

·         Designed and developed database model; coded and implemented migration of all MS Access data into Oracle database used by Web Search Engine.

·         Utilized database triggers, SQL*Loader, Unix shell scripting and complex indexing for minimizing search times.

 

Andersen Consulting/DuPont Pharmaceutical, Wilmington, DE                                           6/00

·         Provided performance tuning for data extracts from third party database into an Oracle database.

·         Performed PL/SQL Code reviews, suggested several improvements to simplify code, decrease future maintenance, and improve execution time.

·         Worked with client DBA to configure Oracle Parallel Query Option.

 

             Teleflex Marine, Inc., Limerick, PA                                                                    4/00-6/00

·         Designed and implemented Oracle Express Data Warehouse utilizing Windows NT 4.0, Oracle 8i, Express 6.3.0.1 and Oracle Sales Analyzer 6.3.

·         Installed and configured Oracle Express Software and Oracle 8.1.5 RDBMS software.

·         Designed and developed OLAP Data Model.

·         Identified data fact and dimension mapping from legacy data store to new OLAP configured schema.

·         Designed / Created Oracle database to store warehouse data loaded from HP9000 MANMAN system.

·         Coded and automated weekly extract from legacy system to new OLAP warehouse utilizing batch files, SQL scripts and SQL*Loader.

·         Provided user training and support.

 

Database Administrator Andersen Consulting, Client AstraZeneca, Wayne, PA                          11/95 – 4/00

Primarily supported VLDBs, OLAP, Data Warehouse databases within Marketing and Sales.

 

·         Supported Sales data warehouse with growth in excess of 300%; current size 700+G.

·         Assisted in design, development & implementation of data refresh process for Oracle Express Data Cube.

·         Designed new and integrated existing databases through two mergers, including HW/SW upgrades.

·         Designed, new Data Warehouse and assisted with migrating from Oracle Express to Microstrategy.

·         Design, code, and automate UNIX shell script to monitor alert log, and gather shutdown statistics.

·         Insure Data Warehouse data interfaces (Compass, SMaRT, SCI) are correct, and meet user specifications.

·         Monitor databases for growth, performance and availability; Performed SW upgrades.

·         Identify and resolve issues relating to performance.

·         Implement new Oracle features to help increase performance, and maintain Technical support contract.

·         Performed analysis determining space requirements and optimal disk layout for Oracle RDMBS.

·         Responsible for Database migration during HW/Server upgrades.

·         Primary contact in M&S for IT integration, HW migrations, enhancements or application changes.

·         Assisted with Ad-Hoc data reporting and analysis.

 

HP (9000/800- V/T/K Classes) - HP-UX 10.x/11, EMC Storage Devices, Oracle 7/8, Oracle Express Server 5.x/6.1, OSA 1.5, RAA/RAM, Microstrategy 5.6/6.0, Shell scripting, C, Pro*C, SQL*PLUS, Embedded SQL, PL/SQL, OEM, Space Manager, SQLab & SQL Tuner, Autosys, MS Office Suite

 

Programmer/Analyst    Andersen Consulting, Client Astra Merck, Wayne PA                                        12/94 - 11/95

Supporting end users; Data loading, implementation and validation for several Marketing and Sales applications.

 

·         Responsible for loading and validating sales data into several applications.

·         Document and implement user requirements for new functionality.

·         Support end user Ad-Hoc data reporting and analysis.

·         Assist end users with MS Office Suite.

·         Primary contact to IMS America regarding data modifications, enhancements.

·         Interview applicants for positions in BPM organization.

 

HP (9000/800) - HP-UX 9/10.x, Oracle 7, UNIX shell scripting, C, Pro*C, SQL*PLUS, Embedded SQL, PL/SQL, MS Office Suite, InfoQuery

 

Programmer/Analyst    PRC Inc.  Bala Cynwyd PA                                                 7/90 - 11/94

 

·         Design, code and implement software used to support Department of Defense contracts.

·         Install, configure and support Sybase RDBMS software, including site installs, and upgrades.

·         Maintained Secret and Top Secret Security clearance.

 

Sun, UNIX, Sybase, UNIX shell scripting, C, Pro*C, ISQL, Embedded SQL, Stored Procedures.

 

Member of International Who’s Who of Information Technologies since 1999

 

Education

University of Scranton, BS Spring 1990; Major: Computer Information Systems, Minor in English