Robert A. Rice

*** ******** **., ******, ********, 48131

Phone: 734-***-**** email: ac8irr@r.postjobfree.com

Secret Security Clearance Capable

EXPERIENCE SUMMARY (Years):

** ****** ******** ********, Design, Administration 8 Years Oracle Enterprise Manager (OEM) Cloud Control Design, Administration 8 Years Oracle Web System & Web Applications Development 6 Years Unix, Solaris & others, HPUX, corn shell, Shell Scripting 6 Years SQL Trace, TKPROF, Explain Plan, Sql Loader, UTLBSTAT/TULESTAT, SqlPlus, EMCLI 4 Years IBM C/Set 2 Oracle Pro C Program Development 2 Years Oracle Financial & Manufacturing Applications DBA 2 Years Microsoft C# Oracle Pro C Program Development 2 Years Microsoft ACCESS

2 Years MySQL and PHP

1 Years Director of Technical and Customer Support DETAILED EXPERIENCE HISTORY

Dates: Aug 2012 - January 2018

Employer: General Electric Company - Van Buren Township, MI Title: Database Engineer: Oracle Enterprise Manager 11g, 12c, 13c Member of a small team supporting one of the world's largest Oracle Enterprise Manager installations, monitoring over 43,000 targets worldwide. My responsibilities included supported the underlying Oracle RDBMS, OEM Weblogic Server, Dynamic Groups, Metric Extensions, Metric Collections, Notification Groups, Metric Templates as well as constant interactions with Database Teams that needed support and education regarding the use of the system. I interfaced frequently with Oracle Support to create and monitor service requests related to problem issues and helped to plan and implement patches and updates and upgrades i.e. 11g to 12c to 13c. My role included extensive use of EMCLI, SQL and PL/SQL. I developed a set of specialized PL/SQL programs used to extract OEM repository data and for transfer to other corporate systems. Dates: July 2012 - Aug 2012

Employer: Huron Valley Physicians Association – Ann Arbor, MI Title: Software Development

Temporary support and software development including installation and configuration of PostGresSQL on VMWare Linux. Installation and configuration of Drupal CMS and training on Drupal 7. Perl program development. Complex SQL structure analysis and medical data interpretation. ETL, including integration of HL7 Medical Data Format raw file analysis and loading procedures.

Dates: November 2006 – December 2007

Employer: The University of Michigan Cancer Research Center Project: Genetic Database Oncomine

Title: Database Administrator

Tools: Oracle, OEM, Unix, Windows

Designed and developed Oracle database and application components to support the University of Michigan Cancer Research Center’s Oncomine (http://www.oncomine.org/) system. Windows 2000 Server, Oracle version 9 and 10g. Also installed and configured Oracle Enterprise Manager (OEM) in order to provide ongoing, remote database support using the OEM intelligent agent, event monitor and paging system. Implementation of hot backups using RMAN with jobs scheduled via OEM. Conducted performance tuning operations making significant improvements in database system performance. Dates: June 2004 – June 2005

Employer: Great Commission Air, Inc – Ann Arbor, MI Project: Non-profit Event/Auction Tracking System and Database Title: Designer, DBA, Developer

Tools: PHP, MySQL, MS Access, Linux, Windows

Designed and developed a database and application to collect and track registrations for non-profit events (Golf Outings and Auctions). This system was first developed with MS Access and provided a method to collect detailed information related to donated items for auction. The system was expanded to allow for the tracking of bids at auction and the recording of payment for said items. It also provided several accounting reports for close-out accounting activities. This system was later re-designed using MySQL database that interfaced with a PHP application allowing entry similar functionality, but with a convenient web-based interface. Dates: October 2001 – March 2003

Employer: Small Manufacturer, Jackson, MI

Project: Oracle DBA and Migration

Title: Oracle DBA

Provided Oracle DBA services and analysis for the purpose of migrating several Oracle databases from a Novell Platform using Oracle 8.0.4 to Windows 2000 (NT) on a Compaq Proliant server using Oracle 8i (8.1.7). Also installed and configured Oracle Enterprise Manager (OEM) in order to provide ongoing, remote database support using the OEM intelligent agent, event monitor and paging system. Implementation of hot backups using RMAN with jobs scheduled via OEM. Conducted performance tuning operations making significant improvements in database system performance. Later upgraded this client to 9i. Dates: April 2000 - August 2000

Employer: DTE Energy - Detroit, MI

Project: Oracle ERP Consultant

Title: Oracle Database Administrator

Oracle Database Administrator for DTE’s Electric Choice development repository. Responsibilities included maintenance of several development Oracle database instances, structure version control, logical design using Oracle 8 on an HPUX platform. Extensive interaction with the application design team required to assist with translation of application object model to a more conventional relational representation within Oracle. Dates: December 1998 - April 2000

Employer: Sun Microsystems – Palo Alto, CA

Project: Oracle Financials and Applications Migration Title: Oracle Consultant

Oracle ERP applications system installation and migration for Sun Micro-Electronics in Santa Clara, CA. Activities included instance and applications migrations for integrated systems testing and use of ChainLink version control software. Maintenance of a specialized web based performance monitoring system designed to collect performance and lock wait statistics of several Oracle applications systems. Oracle technical support as a member of a large team of consultants for W.W. Grainger. Systems used included clustered Sun E10K with Oracle and SAP. Activities included acting as a resource for technical issues, documenting system parameters, and helping to re-create the production site at Sun's research labs in Palo-Alto, CA.

Dates: October 1997 to September 1998

Employer: Inca Computer Builders – Bloomfield, MI

Project: Oracle Database Administrator, Sun Solaris, Oracle Financials Environment Title: Database Administrator, Applications

Installed, configured and administered Oracle RDBMS (Relational Database Management System) for use with Oracle Financial and Manufacturing applications version 10.7 (smart client 16 and 16.1). Employer: Ford Motor Company

Project: Oracle WebServer & Data Warehousing Application Title: Database Analyst, Administrator and Developer Installed and configured Oracle WebSystem version 2.x on an IBM 320 Server running under Microsoft Windows NT version 3.51. Created database objects; tables, resource profiles and PL/SQL as required during development of this new HTML, Oracle based reporting system. The system accesses multiple remote databases

(see prior project) via SQL*NET using remote database links and table snapshots. Security developed as part of the application restricts report (HTML) generation to authorized users of specific reports. HTML reports generated are stored in the database and made available to users via browsers. This system was enthusiastically welcomed by the engineering community at this company as a means of examining information used to improve the quality of the manufacturing processes. Used Oracle Designer 2000 to document and maintain the database structures.

EDUCATION

Washtenaw Community College, Ann Arbor, MI - Associate's Degree Computer Information Systems Liberty University - Business Administration, Lynchburg, VA (Attended - No degree) Certified ORACLE Master, Version 7 Database Administration, ORACLE Education Services. Sun Solaris Administration - Sun Education

Sun Disk Management Tools - Sun Education

Oracle Applications System Administration (SmartClient) Completed numerous course offering from Oracle Education including Application and Database Tuning and many others required to become a Certified Oracle Master (D.B.A.). Numerous other software tool seminars, courses and training programs. PROFESSIONAL ASSOCIATIONS

International Oracle User's Group (Americas).

Oracle Applications User's Group

Midwest Oracle User's Group.

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate