We provide IT Staff Augmentation Services!

Oracle Dba / Architect Resume

5.00/5 (Submit Your Rating)

INTRODUCTION 
Applicant has been an Oracle DBA for over ten years, including seven years experience in data warehouse development and management. He worked for Oracle Corporation for over seven years, serving Oracle clients and Oracle Education instructors remotely from his home in Sandy, Utah and at Oracle HQ in California. He has taken 33 DBA and Data Warehouse classes and was awarded an Oracle Masters in Database Administration in 1996. In addition to high level expertise in database and data warehouse architecture, he is expert in the use of many tools and applications. He studied statistics as part of his Ph.D. training and worked as a research administrator and labor market economist before becoming an Oracle DBA, enhancing his technical expertise and ability to intuitively provide users data in the best and most expedient formats. He has been programming with SQL and PL/SQL for over ten years, performing and tutoring staff to perform queries as well as developing complex PL/SQL programs. For example, he designed and wrote a system for identifying the exact location of swing voters by precinct, and he wrote a complex distributor tree system for a multi-level marketing company. He passed the Oracle SQL-PL/SQL certification exam in 1999. He is also a UNIX/Linux administrator.

Oracle DBA / Architect (7, 8i, 9i, 10g, 11g) [10+ years] 
SQL / PL/SQL / UNIX / Linux (Red Hat, SUSE) [10+ years] 
Data Warehouse & ETL Project Manager [7+ years] 
Applications and Tools 
Oracle Enterprise Manager / Grid Control, SQL Developer, Forms / Reports, emctl, emca, RAC 9i. ASM, Rman, exp/imp/data pump, AWR, ADDM, tkprof, lsnrctl, Data Guard, replication, optimizer, Data Modeler (ERD), Discoverer,and views (materialized); Linux / UNIX kernel, Crystal Reports, SAP BO Data Services (ETL), Business Objects, Abinitio (ETL),Visio ERD, ERWin (ERD), Toad (including ERD); Informatica Designer, Workflow Manager, Workflow Monitor, and Metadata Repository; Windows Office applications, Adobe software, and many more

Confidential, Sandy, UT; Boise State U., Boise, ID September 2010 – Present Oracle DBA / Architect / Oracle Developer

  • Tuned, cloned and monitored Oracle databases using Oracle Grid Control OEM 11g
  • Served as 11g and 10g Oracle DBA and PeopleSoft DBA for Boise State University, Idaho
  • Created SQL and PL/SQL election data swing voter programs for Property Rights LLC
  • Set up servers and converted databases from Oracle and SQL Server to Postgres and MySQL
  • Designed Crystal reports, product descriptions and technical documents for distribution
  • Served as 11g Oracle DBA and Linux Administrator for election data from five states

Confidential, Orem UT October 2008 - September 2010 Oracle DBA / Architect / ETL Project Manager

  • Served as Oracle 10g and SQL Server 2005-8 DBA for natural health multi-level marketing
  • Wrote procedures and ERDs to combine data from many formats into tables and databases
  • Designed data warehouse using PL/SQL and Business Objects Data Services / Integrator
  • Installed Business Object XI and provided SQL support for Business Objects 6 and XI
  • Taught classes on SQL best practices and mentored the building of SQL BO Universes

Confidential, Orem UT / Murray UT March 2005 - October 2008 
Senior Oracle Data Warehouse DBA (as consultant with TekSystems and then as GE direct hire)

  • Served as Oracle 10g Data Warehouse DBA for General Electric credit card company
  • Wrote and supported infrastructure, designs and repositories for Abinitio ETL and Informatica
  • Installed Business Object XI and provided SQL support for Business Objects for GE
  • Setup Data Guard replication between databases located in Utah and India for Symantec
  • Served as SUSE Linux administrator and Oracle DBA for Symantec and taught staff Linux

Confidential, Redwood Shore CA / Salt Lake City UT October 1997 - February 2005 Senior Oracle Applications DBA

  • Tuned, cloned and monitored Oracle databases using Oracle Grid Control OEM 11g
  • Served as Oracle Applications DBA on 10g and 11g instances on Solaris, HP-UX and Linux
  • Installed, configured Oracle Financials 11i and e-Business Suite for Oracle Education classes
  • Directed project for Oracle Forms and Data Warehouse management system development
  • Implemented and trained staff for using Forms and ETL Oracle Education management system
  • Supported 10.7 and 11i Oracle e-Business Suite for Oracle Education and client (General Motors)
  • Served as Oracle DBA and PeopleSoft DBA for Oracle client (Northern Arizona University)
  • Employment history prior to 1997 available upon request

EDUCATION AND TRAINING 

INFORMATION TECHNOLOGY CERTIFICATION

  • Completed/passed Oracle Certification Exam for SQL-PL/SQL (1999)
  • Completed Masters: Oracle Applications Masters Extension for DBAs (1998)
  • Completed Oracle 7 Masters: Oracle Database Administrator (1996)

LINUX AND UNIX CLASSES

  • Red Hat Linux System Administration (2003)
  • RS6000/AIX (Unix) System Administration (1995)
  • RS6000/AIX (Unix) Advanced System Administration (1995)

ETL (Data Warehouse) CLASSES

  • SAP Business Objects Data Services Data Warehouse Development and Admin. (2009)
  • Ab Initio Data Warehouse Development and Administration (2006)
  • Oracle Discoverer for End Users (1999)
  • Oracle Discoverer Administration (1999)
  • Database Design for Oracle Warehouses (1999)
  • Implementing Oracle Applications Data Warehouse (1999)

ORACLE DBA, DATABASE DESIGN, SQL, FORMS

  • Oracle ODS: Forms Design and Generate Web Server Applications (1999)
  • Oracle ODS: Designer / Forms Analysis, Design, and Generation (1999)
  • Oracle Application Server Administration / Forms Server and Middleware (1999)
  • Oracle 8i Scalable (1999)
  • Oracle Performance Tuning Workshop (1998)
  • Oracle 8: New Features (1997)
  • Database Administration II (1996)
  • Advanced SQL-PL/SQL (1995)
  • Oracle Forms 4.0 (1994)
  • ArcInfo GIS (Geographic Information Systems--using Oracle databases) (1993)
  • Oracle Case Method Entity Relationship Modeling (1992)
  • Oracle Case Method Tasks and Deliverables (1992)

ORACLE APPLICATIONS CLASSES

  • Oracle Financials Functional Foundation (2001)
  • Oracle Enterprise Portal, WebDB, Workflow, Document Manager (2000)
  • Oracle Financials Database Administration Seminar for Instructors (1999)
  • Oracle Financials Flexfields (1998)
  • Oracle Financials Alerts (1998)
  • Oracle Financials Administration (1998)
  • Oracle Financials Technical Foundation (1998)

FORMAL EDUCATION 
Ph.D., Public Administration / Statistics (minor), 
M.A., Public Administration / Political Science, 
International Relations Certificate, 
B.S., Political Science / Economics (minor),

We'd love your feedback!