Bill Ryan Email & Phone Number

• Primary DBA responsible for administration and monitoring of EMC Networker nightly backups of 17 production, 67 non-production and 14 test databases as well as 8 infrastructure databases used for Grid Control and OID. • Successfully reduced the Archive Log backup cycle from 10+hrs to under an hour. • Designed, implemented and documented the disk backup procedures to accommodate hosts without Legato media manager.• Designed, implemented and documented the disk backup procedures for 4 databases using ASM.• Disaster Recovery; Responsible for keeping scripts and documentation current for annual DR test or a DR event• Created and documented the process for creating Oracle Data Guard databases, including backup and patching policy.• Primary DBA responsible for Oracle patching of databases, Grid Control app server, Grid agents and the OID app server.• Authored numerous scripts to automate and parallelize the patching process. • Restructured the database patching model to meet business needs. • Supervised the migration of the patch procedures to Oracle Grid Control.• Provided DBA support for various vendor and home grown applications; capacity planning, space monitoring, installs and upgrade coordination, schema security setups, performance tuning as well as scripting needed to facilitate the schema refreshes across databases.

• Sole DBA responsible for maintenance, parameter tuning and patching of the Oracle databases on Sun Solaris, Dec Alpha and IBM AIX. • Successfully migrated Solaris and Dec Alpha databases from version 7x-8.0 to 8i on separate new San storage. • Re-designed and created a new backup process with rman scripts, when the netbackup catalog became corrupt. • Create capacity planning and monitors for all Oracle databases utilizing cron and windows at.• Provided DBA support for all vendor and in-house applications; maintenance, upgrades and data refreshes to the test environment.• Worked with the business analysts and management to install application upgrades and implement code changes..

• Authored and taught the SQL class for the clinical analyst staff.• Provided ongoing mentoring to business and clinical analysts for writing Oracle SQL and MS Access reports.• Provided the DBA with Sql scripting, assistance with patching & upgrades as well as ETL scripting for database conversions.

• Provided system support for the Cerner clinical laboratory computer system, including new user orientation, on site terminal setup, troubleshooting user issues and phone support.• Designed and implemented a new model for nightly backups of the ClinScan doctor’s office ordering system. (eliminating tape usage)• Designed and implemented a new model for loading data updates to the ClinScan ordering database. (eliminating site visits to over 50 offices for updates)• Created an enterprise multi user ordering application and the database, for the outpatient lab entries; replacing separate manual paper systems at 5 facilities.