Oracle Dba / Database Architect Resume
Sandy, UT
Oracle DBA / Database Architect (22 years)
Oracle Financials and E-Business Suite DBA (8 years)
SQL / PL-SQL Programmer / Tuning / Oracle Forms (22 years)
PostgreSql / MySql / MS SQL Server DBA (4 years)
UNIX and Linux Administration / Scripting (22 years)
Data Warehouse Architect / ETL (7 years)
Business Objects / Crystal Reports (5 years)
Platforms: Red Hat Linux, SUSE Linux, HP-UX, AIX, Sun/Solaris, VM, MS Windows, MS SQL Server, PCs
Databases:Oracle 5b / 6 / 7 / 8 / 8i / 9i / 9i RAC / 10g / 11g, SQL Server, PostgreSql, MySql
Programming: SQL, PL/SQL, PostgreSql, MySql, T-Sql, Shell scripting, AWK, PERL, ERD, ETL
Certification:
Oracle Certified Professional Exam completed in SQL and PL/SQL
Oracle 7 DBA Masters and Oracle Applications Masters; 23 Oracle classes
Applications:
Oracle Enterprise Manager, SQL Developer, Toad, Quest Spotlight, RMan, Oracle Replication/Streams, Data Guard, Oracle e-Business Suite 10.7 / 11i, Visio ERD, ERwin, SAP Business Objects Data Services Data Warehouse 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, Adobe Dreamweaver, Photoshop, Word Perfect, Word, Excel, Access, YaST, KDE, Gnome, Excel Data Analysis, Graphic Design, SCRUM, Agile, others
Team and Management Skills:
Extensive analytical, research, writing, mentoring, and presentation skills; Ph.D. in administration
EMPLOYMENT SUMMARY
Confidential, Sandy, UT; Confidential, So. Jordan, UT September 2010 – August 2012 Contract MySQL DBA / Oracle DBA / Data Architect / Product Developer
- Convert SQL Server and Oracle databases to MySql and Postgres databases
- Designed and developed prototype software to help political candidates win elections
- 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, administered, patched Linux servers and virtual management setup (KVM)
- Designed corporate Crystal Reports templates with logos, disclaimers and SQL data formats
Confidential, Orem UT October 2008 - September 2010
Senior Oracle DBA / SQL Server DBA, Oracle Financials DBA
Data Warehouse Architect and Implementation
- Evaluated options, planned, presented and implemented complex data warehouse
- Participated in Agile, SCRUM project management and development
- Designed data warehouse using SAP Business Objects Data Services and PL/SQL
- Maintained/supported Oracle Financials and application performance
- Monitored and tuned databases using Enterprise Manager and Quest Spotlight
- Developed/maintained database security policies for international organization
- Responsible for performance, tuning, design, security and refactoring all SQL and PL/SQL
- Served as Oracle 10g and SQL Server 2005-8 DBA
- Mentored and coached team members
- Installed Business Object XI and provided support for Business Objects 6 and XI
- Taught staff SQL and troubleshot and optimized Business Objects Universes
- Backed up and restored Oracle databases using RMAN, Linux commands, etc.
- Linux and UNIX administration, patching, security patching and scripting
- Converted Oracle databases on HP to Linux and VM Ware
- Assist developers in SQL query development and tuning
Confidential, Orem UT March 2005 - October 2008
Contract Oracle DBA for Symantec and General Electric
- Setup / supported Oracle Streams and Data Guard
- Installed and patched SUSE Linux and served as Linux System Administrator
- Responsible for performance, tuning, design, security and refactoring all SQL and PL/SQL
- Served as Oracle 10g DBA and mentored and coached team members
- Converted Windows Oracle 8 databases to SUSE Linux Oracle 10g, including ASM
- Setup Oracle 10g replication between databases located in Utah and India
- Installed Business Object XI and provided support for Business Objects 6 and XI
- Backup, restored, designed and tuned Oracle databases
- Designed and maintain data warehouse using Ab Initio
- 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 UT October 1997 - February 2005 Senior Applications Database Administrator
- Installation and configure Oracle 10g and 11g instances on Solaris, HP-UX and Linux
- Installation and Configuration Oracle Financials 11i and e-Business Suite
- Backup and recovery of Oracle databases using RMAN and cold backups
- Monitoring of Oracle servers, tuning, capacity and space management
- 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
- Provide/maintain tools and utilities for developers and the Oracle DBA group
- Write and modify overnight batch scripts; Installed and Supported 9i RAC
- Establish and maintain backup and recovery policies and procedures
- Setup and maintain documentation and standards, user access and security
- Work as part of a team to provide 7x24 worldwide support for Oracle clients
- Interface with Oracle technical support and provide technical support
- Manage Concurrent Managers and Forms/Reports Servers
- Configure and manage web servers, Apache and middleware
- Designed and implemented in-house system using Data Warehouse Builder and Forms
Confidential, HAFB, Ogden, SLC, Utah September 1989 – October 1997
Contract Oracle DBA / Contract Software Developer
- Responsible for performance, tuning, design, security and refactoring all SQL and PL/SQL
- Served as Oracle DBA and mentored and coached team members
- Maintained AIX servers, Oracle databases, supported health systems programmers
- Provided support for 3M health systems software development projects
- Conducted classes at hospitals regarding 3M health systems implementation
- Provide database support/connectivity for Java programmers
- Developed Minuteman Missile PC-based portable maintenance system
- Developed Integrated Geographical and Oracle Database system for Forest Service
- Member of Oracle Forms Development/Testing team for IRS software auditing systems
- Managed software development contracts, taught user seminars in several states
- Developed and published PC employment multiplier statistics systems
- Sun/Solaris UNIX administration and scripting
EDUCATION AND TRAINING
INFORMATION TECHNOLOGY CERTIFICATION
- Completed/passed Oracle Certification Exam for SQL-PL/SQL
- Completed Masters: Oracle Applications Masters Extension for DBAs
- Completed Oracle 7 Masters: Oracle Database Administrator
LINUX AND UNIX CLASSES
- Red Hat Linux System Administration
- RS6000/AIX (Unix) System Administration
- RS6000/AIX (Unix) Advanced System Administration
ETL (Data Warehouse) CLASSES
- SAP Business Objects Data Services Data Warehouse Development and Admin.
- Ab Initio Data Warehouse Development and Administration
- Oracle Discoverer for End Users
- Oracle Discoverer Administration
- Database Design for Oracle Warehouses
- Implementing Oracle Applications Data Warehouse
ORACLE DBA, DATABASE DESIGN, SQL, FORMS
- Oracle Designer: Design and Generate Web Server Applications
- Oracle Designer 2000: Analysis, Design, and Generation
- Oracle 8i Scalable
- Oracle Performance Tuning Workshop
- Oracle 8: New Features
- Database Administration II
- Advanced SQL-PL/SQL
- Oracle Forms 4.0
- ArcInfo GIS (Geographic Information Systems--using Oracle databases)
- Oracle Case Method Entity Relationship Modeling
- Oracle Case Method Tasks and Deliverables (1992)
FORMAL EDUCATION
Ph.D., Management-Public Administration/Political Science
M.A., Management-Public Administration/Political Science
B.S., Political Science, Minor Economics/Geography