Oracle Database Administrator / DB Architect / SQL / PL/SQL (17 years)
UNIX and Linux Administrator for Databases and Applications (17 years)
Oracle Forms / Oracle Financials and E-Business Suite DBA (8 years)
Data Warehouse Developer &Project Manager / SAP Data Services (4 years)
PostgesSQL Database Administrator & Developer / pSQL / PL/pgSQL (2 years)

Platforms:
Red Hat Linux, SUSE Linux,Ubuntu, HP-UX, AIX, Sun/Solaris, PCs, KVM,
MS Windows thru Windows 7, MS SQL Server, VM Ware

Databases:
Oracle 7 / 8 / 8i / 9i / 9i RAC / 10g / 11g, SQL Server, PostgreSql, MySql

Programming:
SQL, PL/SQL, pSQL, PL/pgSQL, MySql, T-Sql, Shell script, AWK, ERD, ETL, HTML,
Apex, Oracle Forms and Reports, Java stored procedures in Oracle database

Certification:
Oracle Certified Professional Exam completed in SQL and PL/SQL (1999)
Oracle 7 DBA Masters &Oracle Apps Masters; 28 Oracle,Linux & ETL classes (1992 -2009)

Applications::
Oracle Enterprise Manager, SQL Developer, Toad, Quest Spotlight, RMan, Replication, Data Guard, Oracle e-Business Suite 10.7 / 11i,Visio ERD, ERwin,SAP Business Objects Data Services / Data Integrator, ETL,Oracle Data Warehouse Builder,Crystal Reports, Business Objects 6 / XI, Ab Initio Data Warehouse ETL, Oracle Data Modeler (Designer), Oracle Forms/Reports 6i / 9i /10g, Workflow, Oracle 9iAS, Oracle WebLogic,Visio, Power Point, AdobeDreamweaver, Photoshop, WordPerfect, Word, Excel, Access, YaST,KDE, Gnome, Excel Data Analysis, Graphic Design, SCRUM, Agile, Java DBA Support Programmer, PeopleSoft, Apex

Team and Management Skills:
Extensive analytical, research, writing, mentoring, and presentation skills; Ph.D. in administration

EMPLOYMENT SUMMARY

Confidential,
PeopleSoft DBA PeopleSoft DBA and Product Developer

• Created pSQL and PL/pgSQL election swing voter data calculation programs
• Created SQL and PL/SQL election data swing voter data calculation programs
• Converted Oracle databases to PostgresSQL databases
• Set up and maintained PostgresSQL backup replication of election databases
• Collected and formatted historical election data from five states for prototype election system
• Submitted finished prototype to Washington D.C. interest groups for use in future elections
• Installed and tested Ubuntu and RedHat Linux configurations compared to SUSE Linux
• Used YaST, KDE, Gnome, KVM and command line to install Linux, patches and features
• Designed Crystal Reports templates, forms, logos, graphs and data
• Contract Oracle DBA and PeopleSoft DBA for Boise State University, Idaho
• Contract conversion ofSQL Server databases to MySql databases

Confidential,
Orem UT October 2008 - September 2010
Senior Oracle DBA/SQL Server DBA, Oracle Financials DBA
Data Warehouse Architectand Implementation

• Served as Oracle 10g and SQL Server 2005-8 DBA for natural health marketing company
• Designed data warehouse using SAP Business Objects Data Services and PL/SQL
• Evaluated, improved, modified and maintained existing PL/SQL data loading programs
• Served as Project Director fordesign and implemented complex data warehouse
• Designed, wrote and implemented complex retail sales data loading system using PL/SQL
• Assist developers and report writers in SQL query development and tuning
• Responsible for performance, tuning, design, security and refactoring all SQL and PL/SQL
• Maintained/supported Oracle Financials and application performance
• Installed Business Object XI and provided support for Business Objects 6 and XI
• Taught staff SQL and troubleshot and optimized Business Objects Universes
• Linux and UNIX administration, backup, RMan, patching, security patching and scripting
• Converted Oracle databases on HP to Linux and VM Ware

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

• Senior Oracle 10g Data Warehouse DBA for General Electric Money credit card company
• Installed SUSE Linux and served as Linux System Administrator for Symantec (TekSystems)
• Responsible for performance, tuning, design, security and refactoring all SQL and PL/SQL
• Converted Windows Oracle 8 databases to SUSE Linux Oracle 10g
• Setup Data Guard replication between databases located in Utah and India for Symantec
• Installed Business Object XI and support Business Objects 6 and XI for GE Money
• Migrated data and databases from legacy systems to Oracle on HP
• Linux and UNIX administration and scripting
• Assist developers in SQL query development and tuning

Confidential,
Redwood Shore CA / Salt Lake City UTOctober 1997 - February 2005Senior Applications Database Administrator, Oracle Forms Developer / Support

• Project Director for Oracle Forms and Apex in-house management system development
• Senior Oracle Applications DBA on10g and 11g instances on Solaris, HP-UX and Linux
• Contract Oracle DBA and PeopleSoft DBA for Oracle client---Northern Arizona University
• Implemented and trained staff for using this Oracle Forms Oracle Education management system
• Supported Oracle Forms use in Oracle e-Business Suite for Oracle Education and clients
• Manage Concurrent Managers and Forms/Reports Servers
• Installation and Configuration Oracle Financials 11i and e-Business Suite
• Cloned Oracle Financials and e-Business Suite for Oracle Education
• Conducted frequent data loading to prepare production servers and backups
• Apply Oracle software upgrades and patches using the Oracle ad* utilities
• Apply UNIX, Linux, middleware and client upgrades and patches

Confidential,
Murray, UT October 1995 – October 1997 Oracle DBA, AIX Administrator, Java DBA Support Programmer

• Serve as DBA including maintaining Java stored procedures for programmers in database
• Serve as sole Oracle DBA and AIX administrator for code development and testing
• Test and advise Java developers of impact of Java code on database performance
• Design Oracle databases to meet health information system needs
• Backup and recovery of Oracle databases using RMAN and cold backups
• Monitor Oracle servers, tuning, capacity and space management
• Install, upgrade and patch databases and AIX servers

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., Management-Public Administration/ Confidential,

Specialization: Political and Economic Theory / Statistics
M.A., Management-Public Administration/ Confidential,

International Relations Certificate, Confidential,

B.S., Political Science, Minor Economics/ Confidential,