We provide IT Staff Augmentation Services!

Oracle Dba / Database Architect Resume

2.00/5 (Submit Your Rating)

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

We'd love your feedback!