Robert A. Rice

Port Orange, FL

e-mail: ad2sjh@r.postjobfree.com Phone: 734-***-****

EXPERIENCE SUMMARY

Data Engineering - Database Administration - Architecture:

** ***** ******** *********** - *racle Database Analysis, Design, Administration

15 Years PL/SQL and Oracle Web System & Web Applications Development

8 Years Oracle Enterprise Manager (OEM) Cloud Control Design, Administration

2 Years Oracle Financial & Manufacturing Applications DBA

3 Years PostgreSQL and GIS on Amazon (AWS) RDS, Aurora and on EC2 and on-prem.

Software Development:

4 Years IBM C/Set 2 Oracle Pro C Program Development

1 Years Microsoft Visual Basic / Oracle, ODBC & OO4O

2 Years Microsoft Access

4 Years dBase IV database analysis, design, development

4 Years Clipper and dBase IV Program Development

2 Years Microsoft Compiled BASIC Program Development

2 Years PHP and MySQL

Linux: Red Hat Linux, Unix, Solaris & others, HPUX, corn shell, Bash shell scripting

Tools: SQL Trace, TKPROF, Explain Plan, SQL Loader, Data Pump, UTLBSTAT/TULESTAT, SqlPlus, EMCLI,, Replication, Rman, OEM - Oracle Enterprise Manager (OEM), PGAdmin, etc..

Management - Non-Profiit Director:

10 Years Director of a 501(c)3 Non-profit providing humanitarian and mission support in Guatemala. Responsible for forming and directing a Boad of Directors, creating and complying with budgets, cost analysis, marketing analysis (social medial, donor relations, direct mail, etc..) In-Country government relations, in-country social programs, equipment procurement and management (including piloting).

Management - IT:

1 Years - Director of Technical and Customer Support group of 20 employees.

2 Years - Proprietor, Data Processing Service Bureau

Certifications:

Oracle Master DBA

TSA Ga Security Certified

AWS Cloud Practitioner Essentials Certified

AWS Storage Gateway Certified

CompTia Security+ Trained

FAA Commercial Pilot - Flight Instructor

LinkedIn: https://www.linkedin.com/in/robrice/

EDUCATION:

Associate Degree Computer Information Systems

Washtenaw Community College, Ann Arbor, MI

Certified ORACLE Master DBA, ORACLE Education Services.

ITIL Foundation Certification, General Electric, 2014

Oracle Applications System Administration (SmartClient)

Completed numerous course offerings from Oracle Education including Application and Database

Tuning and many others required to become a Certified Oracle Master (D.B.A.).

Sun Solaris Administration - Sun Education

Sun Disk Management Tools - Sun Education

TSA Ga Security Certified

AWS Storage Gateway

AWS Cloud Practitioner Essentials (first and second edition)

AWS Integrated Services

AWS Security, AWS Architecture, AWS Core Services, DynamoDB Service Primer

AWS DynamoDB, DataSync Primer, Intro to Simple Queue Services (SQS)

AWS Lambda Foundations

AWS DynamoDB for Serverless Architecture

AWS Redis to ElastiCache Migration

Prepared to obtain 8570 CompliantComptia Security+ Certification

MANY GREAT REFERENCES AVAILABLE UPON REQUEST

DETAILED IT EXPERIENCE HISTORY

Dates: 01/2021 - 09/2023

Employer: Dynamic Map Platform (Ushr)

Address: Livonia, MI

Position: Sr. Database Engineer

Responsible for AWS-based RDS and Aurora implementations of Postgres and replicated databases in a global, multi-terabyte system. Created and maintained AWS security groups (IAM), backup and recovery compliance, EC2 instances used for ETL and monitoring, S3 storage used for LIDAR staging and storage.

Coordinated ongoing database architecture improvements and version migrations including PostGIS spatial data extensions.

Designed and developed Python and PL/pgSQL procedures and functions to support Ushr's Digital Road Maps and to produce GIS Analytics. Monitored systems, analyzed database performance, improved and modified schema designs, and looked for and implemented performance enhancements. Provided query design, analysis, and optimization for developers.

Created ETL data ingestion systems to load Open Street Maps (OSM) pdf files into the PostgreSQL databases to provide QC cross-checks against production map data.

Analyzed various cost/performance metrics related to the use of different AWS database containers (Various RDS instances vs. Aurora, etc…).

Monitored AWS Databases using AWS Performance Insights to diagnose performance issues. Used AWS Cloudwatch to query log contents to search for invalid access attempts and access to specific database objects (unusual access of objects).

Participated in Agile development sessions - using Jira for development coordination. Used GIT and BitBucket to create and maintain code repositories used in both application development as well as schema version control scripts.

Developed AWS Athena queries in (Hadoop) to access the OSM World planet.openstreetmap.org database. Created a small number of Lambda functions to support AWS OSM Queries.

International, multi-regional, distributed database design and ETL including Python / Open Street Maps (OSM) Integration.

Tools: Postgres, GIS, AWS, Athena, PostgreSQL, SQL, PL/pgSQL, RDS, Aurora, EC2, S3, OSM, Python, ETL, PostGIS, BOTO3, etc..

Dates: 06/2019 - 01/2021

Employer: Spok Holdings, Inc.

Address: Eden Prairie, MN

Position: Sr. Oracle DBA

Oracle DBA - Administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of the company's Oracle database. As a key member of the Spok Professional Services Group, coordinated and executed on-going database migrations related to Spok applications for medical center clients all over the country from Oracle 10g and 11g to 12c databases including complex PL/SQL systems, RAC installations and related interfaces. Monitor, analyze and configure HL7 patient data integrations. Analyze, design, build and implement ETL data load scripts using SQL*Loader, Linux scripting and PL/SQL procedures.

Dates: 08/2018 - 04/2019

Employer: Barr Air Patrol and Corporate Eagle Mgmt

Address: Pontiac, Michigan

Position: Pipeline Patrol and King Air B200 First Officer

Commercial Aviation not related to Computer Information Systems.Responsible for aircraft pre-flight, staging passenger supplies and transportation as well as two-crew CRM operations as specified by the corporate SOP. Assist Pilot in flight preparation and operation of the aircraft. Conduct Pre-flight inspection to ensure all navigation, safety and operating systems are working properly. Support in take-offs and landings as directed by the Captain. Assume the responsibility and authority of the pilot if necessary during the flight. Prepare the flight plan and weight and balance forms for each flight. Communicate with ATC operations during take-off, flight and landing. Act quickly and appropriately during environmental changes and emergencies to ensure passengers safety. Responsible for scheduling and flying pipeline patrols over an area extending from south Chicago to Northern Michigan to Akron Ohio, including complex, class B, C and D airspace. Required to coordinate with on-board observer and provide orientation such as software operation, radio use navigation. Prepared patrol reports and flight schedules and planned required maintenance and inspections.

Dates: 08/2012 - 01/2018

Employer: General Electric Company

Address: Van Buren Township, Michigan

Position: Sr. Oracle DBA

Member of a small team supporting one of the world's largest Oracle Enterprise Manager installations, monitoring over 43,000 targets worldwide. Responsibilities included supporting 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 for support and education regarding the use of the system. Interfaced frequently with Oracle Support to create and monitor service requests related to technical issues and helped to plan and implement patches, 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 to reconcile data in other corporate systems. Work included extensive use of Red Hat Linux and Linux scripting.

Designed and developed a collaborative SAR (Search and Rescue) application and website called wellfindyou.com. Based on a PHP LAMP stack, this database centric application allowed users to select quadrants from a large map in order to search satellite imagery with the purpose of finding specific features (searching for a building, structure, features, etc…) Users searched 1k square areas for selected features then flag them as interesting for review by the next level examiners. The system leveraged MySQL database, PHP, Google Maps API calls in a Linux environment.

Dates: 07/2012 - 08/2012

Employer: Huron Valley Physicians Association

Address: Ann Arbor, Michigan

Position: Database Developer

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: 12/2007 - 06/2011

Employer: Great Commission Air, Inc – Ann Arbor, MI

Address: Ixcan, Guatemala

Position: Missionary Pilot and Field Operations Manager

Founder, Director and Field Manager for a small non-profit humanitarian relief organization that provided air transport for the extremely impoverished indigenous Mayan population of the Ixcan and surrounding regions of northern Guatemala. Provided leadership and direction for the board of directors and for the volunteers, worked to build relationships with partnering organizations, initiated and maintained systems for accounting, maintenance, support raising. Produced and published newsletters and articles as well as performance reports to help educate contributors about the work being accomplished. In addition, I flew the aircraft, cared for medical patients, hosted volunteer doctor teams and conducted flights into remote village airstrips, providing NGO type humanitarian relief as well as emergency air ambulance services.

Dates: 11/2006 - 12/2007

Employer: The University of Michigan Cancer Research Center

Address: Ann Arbor, Michigan

Position: Oracle Database Administrator

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 9i 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: 06/2004 - 06/2005

Employer: Great Commission Air, Inc

Address: Ann Arbor, Michigan

Position: Application Designer, DBA, Developer

Non-profit Event/Auction Tracking System and Database: 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 a MySQL database that interfaced with a PHP application allowing entry similar functionality, but with a convenient web-based interface.

Completely designed and developed a collaborative ride-share system similar to what is now UBER. This system was called EcoTransit.com. Based on a PHP LAMP stack, this database centric application allowed users to enter their location and desired destination. The system would monitor registered vehicles (drivers) within an urban area and examine the riders in those vehicles to determine which vehicle had space for another passenger and if it was going to pass by the user's location and destination. It would then assign that user to the specified vehicle. The system heavily leveraged Google Maps API to find the most efficient routes for existing vehicles and user requests. It also used a MySQL database, PHP, AJAX, JavaScript.

Dates: 03/2003 - 05/2005

Employer: Great Commission Air, Inc

Address: Ixcan Region, Guatemala

Position: Field Manager, Pilot, Director

Founder, Director and Field Manager for a small non-profit humanitarian relief organization that provided air transport for the extremely impoverished indigenous Mayan population of the Ixcan and surrounding regions of northern Guatemala. Provided leadership and direction for the board of directors and for the volunteers, worked to build relationships with partnering organizations, initiated and maintained systems for accounting, maintenance, support raising. Produced and published newsletters and articles as well as performance reports to help educate contributors about the work being accomplished. In addition, I flew the aircraft, cared for medical patients, hosted volunteer doctor teams and conducted flights into remote village airstrips, providing NGO type humanitarian relief as well as emergency air ambulance services.

Dates: 02/2001 - 08/2001

Employer: Remote Area Medical

Address: Guyana, South America

Position: Pilot, Humanitarian Relief Project

Provided aviation services (Pilot of Cessna U206) a medical service NGO in Southern Guyana and Eastern Guatemala. Provided air medical evacuation to the poor sick and injured, medical supplies and transportation for volunteer doctors serving in those regions.

Dates: 10/2001 - 03/2003

Employer: Jackson Seat

Address: Jackson, MI

Position: 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). 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: 02/2001 - 08/2001

Employer: Remote Area Medical

Address: Guyana, South America

Position: Humanitarian Relief Pilot

Provided aviation services (Pilot of Cessna U206) for this medical service NGO in southern Guyana and eastern Guatemala. Provided air medical evacuation to the poor sick and injured, medical supplies and transportation for volunteer doctors serving in those regions.

Dates: 04/2000 - 08/2000

Employer: DTE Energy - Detroit, MI

Address: Oracle ERP Consultant

Position: 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 HP UX 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: 12/1998 - 04/2000

Employer: Sun Microsystems

Address: Palo Alto, CA

Position: Oracle DBA and Consultant

Performed routine maintenance and instance duplication of Oracle ERP applications system for Sun Micro-Electronics in Santa Clara, CA. Activities included instance and application 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. Participated in part of the upgrade effort of one of the largest Oracle applications installations in the United States. This ERP implementation at Sun Microsystems was part of the "Sun on Sun" project used to prove-out Sun and Oracle software on Sun hardware platforms.

Dates: 10/1997 - 09/1998

Employer: Inca Computer Builders

Address: Bloomfield, MI

Position: Oracle Financials DBA and Database Administrator

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). Responsible for maintaining, updating and upgrading Oracle Financial and Manufacturing applications. Including applying periodic patches using adpatch, upgrading to the new version (16.0 to 16.1) and using adrelink to relink applications. Responsible for installing and maintaining Oracle applications client software on a Windows 95 platform using Oracle software manager. Installed and configured several installations of Oracle Webserver 3.0x for intranet and public internet access to web applications written in PL/SQL. Assisted in the design and development of web applications that use data from Oracle Inventory and Manufacturing modules, BOM tables, price/cost tables and Order Entry customer interface tables.

Dates: 09/1991 - 04/1997

Employer: Ford Motor Company

Address: Dearborn, Michigan

Position: Oracle DBA, Database Analyst and Developer

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. Extensive use of Pro*C to design and develop an ETL to digest automotive diagnostic logs collected at assembly plants into an Oracle data warehouse I also designed and developed to support the Web Based pl/sql interface.

Performed logical and physical database design. Developed applications and administered twenty-one production databases for Ford Motor Company's FACTS Reporting System in all North American assembly plants. Installed and upgraded ORACLE enterprise server and workstation software.

Software development included the design, coding, testing, implementation and maintenance of a system of programs written in both Microsoft C and IBM C/Set2 using Oracle's Pro*C interface to the Oracle RDBMS. Created version control and release procedures that incorporate the Polytron Version Control System.

Data Engineering and Logical Data Modeling Experience Summary:

Regarding my experience as a "Logical DBA"; My introduction to Oracle was at Ford Motor, where I worked with several different departments, including Industrial Engineering, Cost Accounting and Engine Diagnostics. In all of these positions, I was tasked with designing the Oracle database that would be used by applications that I also designed and wrote. The logical database design phase of these projects included extensive client interfacing to collect and document requirements and the business rules related to them. The databases I designed included consideration of data relationships (enforced by referential integrity constraints), business rules, sometimes enforced by primary key or restriction constraints, ranges and triggers, etc... I was always intimately involved in the development of access paths for data and query statements and the indexes required to efficiently support them. Producing normalized data models that efficiently and effectively translates a client's needs into a fully formed and functioning system is an extremely creative process and one that I really enjoy. I understand, and apply "Standard Normal Form", with regard to data (normalization) and have used modeling tools, such as Oracle SQL*Designer, to help model, document and implement database systems. I am proficient at generating entity relationship diagrams and data flow diagrams. My experience with database design and development spans over 15 years and includes an intimate knowledge of many commercial fields including: Finance, Engineering, Bioinformatics, Geographic Information Systems and more. I have extensive experience with Oracle, PL/SQL, SQL, PostGres, Python and much more.

Contact this candidate