Oracle DBA/Architect

ROBERT C. LARSEN

**** ******* ******

Lafayette, CO 80026

Phone: 303-***-**** (Home)

Email: ***.***.******@*****.***

Areas of Strength/Qualifications Summary

Oracle Architecture/Server Knowledge (25+ years experience),

Technical Project Management and Planning,

Oracle Database Administration (DBA),

Database Design, Data Modeling,

Oracle Data Warehouse Design and Implementation,

Oracle SQL and System Performance Tuning

Professional Experience:

University of Colorado – Boulder, CO

Senior Database Architect/Database Administrator

May 2009 – September 2010

Designed, installed and configured a Database Cluster system for the Malnutrition Research Study funded by the Bill & Melinda Gates Foundation.

The cluster consists of 22 servers with 220 cores, 2 Cisco Gigabit Ethernet networks, a 8Gb Fibre Channel network, 2 Fibre Channel 12TB SAN devices and a Fibre Channel 48TB NAS system.

Installed Enterprise Linux V5.4 on all systems.

Installed Oracle 11gR2 Database Server and Oracle V11gR2 GRID

Infrastructure (Clusterware, ASM, RAC, GRID) on all database servers.

Installed and configured DNS and NFS for support of the Oracle GRID software.

Installed the Weblogic Application Server to support the use of OEM.

Developed the initial Data Model for loading DNA sequences.

Wrote PL/SQL routines to load several unusual file formats.

Achieved bulk loading speeds of 90,000 rows per second.

Miracle Software (Short-Term Contract)

Worked on-site at Presbyterian Hospital – Albuquerque, NM

Senior Data Warehouse Architect/Developer

January 2009 – May 2009

Redesigned their existing ETL process to adhere to new Federal Health Care

regulations. Oracle Warehouse Builder (OWB) was used to design the ETL and perform the nightly work flow runs.

Unison Systems, Inc. (Short-Term Contract)

Worked on-site at Department of Labor, MSHA – Lakewood, CO

Senior Data Warehouse Architect

July 2008 – October 2008

Did a major overhaul of the existing ETL system to improve efficiency and ease of use. The Oracle Data Warehouse was designed/implemented using OWB. Added error reporting (via email) to process flows.

The Oracle Data Warehouse was a migration from an existing Teradata Database. Introduced physical-level changes that allowed all existing MSHA queries to run as fast or faster than on the original Teradata environment.

Center for Advanced Engineering and Technology Education,

University of Colorado at Boulder

Instructor – Oracle University DBA Certificate Program

February 2008 - February 2010

Taught Oracle DBA Certification classes (classroom and online) for CAETE.

DHSoft (Short-Term Contract)

Worked on-site at Douglas County – Colorado

BI/DW Specialist

January 2008 – July 2008

Designed and built an Operational Data Store (ODS) to hold data extracted from

Douglas County’s Building Department software applications. The Data Source

for this effort was an Object-Based system called POSSE. The ODS was created

in Oracle v10g.

The Logical and Physical Data Design was done using Erwin. Oracle Warehouse Builder (OWB) was used to perform ETL, Data Profiling, Business Rule creation, Data Auditing, Data Cleansing and Process Workflow.

Planet Group, Inc. (Short-Term Contract)

Worked on site at Level (3) Communications LLC – Broomfield, CO

Senior Data Warehouse Architect

May 2007 – November 2007

Designed an Enterprise Data Warehouse System to track the details of Level 3’s On-Demand and Live Streaming events world-wide.

The initial Fact table was designed to hold low-level details contained in log files generated by Window’s Media Server and Adobe’s Flash Server. These log files were delivered hourly. Dimensions were created for the following Entities: Customer, Clusters, Streaming Servers, Billing Region, Media Type, Event Type, Client Geographical Location and Time.

Worked with Informatica ETL Lead to design the data flow and process flow.

The logical and physical design was done using Erwin. Schema creation was performed with SQL scripts. PL/SQL stored procedures were used to populate the dimensions.

Gates Corporation

Senior Oracle BI/Data Warehouse Data Architect

May 2006 – May 2007.

Project Manager for Implementing a Production Cloned Reporting Environment.

Developed custom software to identify what Oracle Tables, Stored Procedures, View Definitions and Job Information needed to be saved away every night prior to the Hardware Copy of the Production Database.

Technical Lead on the Production Data Archiving Project. Installed, setup and tested the “Applimation” Archiving software. The Archiving process went live on December, 2006. This process helped offset the 30% growth rate of data in the 1.7TB Production Database.

Developed enhancements to the Corporate Sales Data Mart. Performed Performance Tuning of sluggish Discoverer Reports. This included Oracle Server and Discoverer Parameter changes, studying Explain plans, creating indexes and conversion of B-Tree indexes to Bitmap indexes.

Westar Corporation

Senior Oracle Data Warehouse Architect/Developer (Consultant)

August 2005 – May 2006.

Designed a Proof-of-Principle (POP) Data Warehouse for the US Army Aviation & Missile Command. The Data Warehouse consisted of 2 large Star Schemas with multiple dimensions. Some of the dimensions included aircraft type, aircraft model number, aircraft serial number, aircraft part number, maintenance procedure performed, vibration types, and others.

The Data Warehouse was implemented using Oracle 10gR2 running on Red Hat Linux V3. Data Loading and Cleansing routines were written using PL/SQL Stored Procedures and Packages. Data Sources included Oracle, Microsoft SQL*Server and Flat Files.

The BI system was developed using custom Java programs, Oracle Application Server and PL/SQL packages. My main development focus for the BI system was writing several PL/SQL Procedures to retrieve data for real-time Java Graphics presentations.

After contract award, the DW team was asked to perform the Hardware Design and Acquisition of a System to support the first year of data warehouse population and testing. The final system included 36 servers running the Oracle 10gR2 Database Server, RAC and ASM. Total disk capacity was 90TB.

Sanmina/SCI Corporation

Oracle Data Warehouse Architect/Developer (Consultant)

February 2005 – August 2005.

Designed and implemented a prototype for an Oracle Corporate Sales Data Warehouse. Designed Dimensions, Fact Tables and Materialized Views. Wrote Data Loading and Cleansing logic in PL/SQL. The majority of the data sources were tables in Oracle Financials.

Johnson Controls World Services Inc., NOAA Southeast Fisheries Science Center

Oracle DBA, Data Architect, Oracle Software Developer

December 2003 – January 2005.

Oracle DBA

Installed/configured Oracle V9iR2 (V9.2) and Oracle10g (V9.4) on both

Windows 2000 and LINUX servers. Performed system monitoring and

database backups on these servers using OEM.

Data Architect/Modeler

Completed a total redesign of the Oracle Data Model of the NOAA Fisheries Scientific Database. This was done using the Oracle Designer (ERWIN-like) product. Entity Relationship diagrams were distributed throughout the NOAA Fisheries for comments and approval.

NextGen Corporation

President & Co-Founder

August 1995 to February, 2003

NextGen specialized in database design, data migration, custom software development and DBA services for the Oracle product line.

Technical Project Lead for following major software development efforts:

Progress Rail Corporation (Jun. ’99 – Jan. ’03): Helped plan and design a disaster recovery system which involved setting up a Hot Standby Database (now called DataGuard) in a separate building from their primary Oracle server. The system transmitted data over a high speed T1 line.

Progress Rail Corporation (Oct. ’01 – Oct. ’02): Performed the logical and physical database design for a Oracle V9.2 Data Warehouse that organized financial data from over 20 separate Progress Rail companies so that business intelligence could be gathered at the corporate level.

PDR Engineering (Feb. ’96 – Feb. ’02): Partnered with PDR on several GIS projects for the City of Huntsville, Madison County (AL) and the Army Corps of Engineers. Database design, creation and DBA efforts were performed by NextGen. PDR developed the GIS front-ends.

Hexcel Corporation – (Oct. ’99 – Dec. ’01): Developed a manufacturing system that coordinated the production of precursor fiber carbon spools. This included initial product selection, bar coding and tracking spools (with radio-transmitted scanners), creating production reports and interfacing with their chemical testing labs. Software products used were: Oracle Designer, Oracle Forms/Reports and the Oracle V8i Database Server.

Trico Steel (Apr. ’96 – Oct. ’00): Developed a real-time parts inventory and ordering system. Employees from over 100 PCs could locate and order parts from a Oracle database that tracked over 30,000 parts specific to the steel mill. Once an order was approved, the software system interfaced with the corporate financial system and placed an electronic purchase order. When the part was delivered, the system would place a payment request in the corporate financial system (Sybase System 10).

Oracle DBA work performed at Trico: software installation/upgrades, instance creation, tablespace creation/expansion, troubleshooting, routine system monitoring, performance monitoring and hot backups.

Instructor-Led Training (‘96-’02):

Have performed instructor-led Oracle Database Administration courses for the entire Oracle DBA certification curriculum.

Intergraph Corporation

Executive Technical Manager

October 1990 to August 1995.

Managed the Nucleus Database Software Division. The division had 4 software development departments that produced over 100 commercial products. Our organization ran QA and certified all of the commercial products. The profit center also performed first level customer support.

Annual Revenue - $12+ million.

Personnel Budget - $ 2.5 million, 50 employees.

Monitored performance reviews of all employees.

Performed direct purchasing of hardware, software, and maintenance.

Oversaw over $1 million of hardware.

Was Intergraph’s corporate liaison with Informix, Ingres, Oracle and Sybase Corporations.

Intergraph Corporation

Senior Technical Manager

February 1986 to September 1990.

Managed the design and initial implementation of RIS. This software product allowed an application to retrieve data from several different brands of databases without modification to the application code.

Managed the design and implementation of a SQL-like query language that retrieved data from Intergraph's OO (object oriented) system.

Managed the porting of Informix, Ingres and Oracle to the Intergraph Clipper platform.

Harris Computer Systems

Senior Member Technical Staff

June 1981 to January 1986.

Developed a client/server version of ORACLE using the X.25 Communication protocol. This was the first two-task relational database system commercially available on minicomputers.

Managed the porting of Oracle to the Harris Minicomputer system.

University of Central Florida

Instructor

September 1979 to May 1981

University of Central Florida

Graduate Research Assistant

September 1977 to August 1979.

Designed and developed GRASP (Graphic Specification of Software).

Education:

M.S. Computer Science

University of Central Florida, 1979.

B.S. Computer Science, Business Administration (Double Major)

Vanderbilt University, 1977

Certification:

SkillsBench Assessment - Oracle 9i Administration

Score: 3.3 (Scale of 1 - 5 where 5.0 = Best) Higher than 86% of all test takers.

Software Development Environment Experience:

Operating System Environments:

Windows 95/98/NT/2000/XP/7, MAC OS, Linux, Sun/Solaris, HP/UX, other UNIX environments and several vendor-specific proprietary operating systems.

Programming languages: ‘C’, SQL, PL/SQL, PL/1.

Databases: Oracle (25+ years experience), Informix, Ingres, Sybase, SQL Server.

Oracle Database Tools: SQL*Plus, SQL*Developer, Oracle Warehouse Builder (OWB), Oracle Enterprise Manager (OEM), Oracle (SQL Developer) Data Modeler, Oracle Discoverer, Import/Export, Data Pump, Oracle Reports, Oracle Designer, Net Configuration, PRO*C, SQL*Loader, Workflow.

References:

Furnished upon request.

Contact this candidate