• Sixteen years production database administration experience with Oracle, ten years with MS SQL Server
• Supported multiple application database environments, including Oracle Financial and Manufacturing applications, PeopleSoft HR, Financial, CRM and Campus Solutions modules and SAP Business Intelligence (BI) systems
• Engineered and implemented disaster recovery and service continuity solutions for the world's largest university
• Designed and deployed databases used for e-commerce, data mining, manufacturing and emergency services

A seasoned database administrator, author, instructor and presenter, with extensive experience with Oracle and Microsoft SQL Server. A skilled communicator able to deliver solutions based on a thorough understanding of business needs. Adept at maximizing the performance of high transaction, multiple terabyte databases and data warehouse environments.

Work Experience

Confidential, Murrieta, CA, 3/2002 - Present
Principal Consultant and CEO responsible for database administration and consulting at multiple clients, including:
Confidential, Phoenix, AZ: Designed disaster recovery and service continuity solutions for Oracle databases utilizing RAC, ASM, DataGuard, GoldenGate through implementation of standards and best practices

• Prepared and presented recommendations for deployment of Oracle 10g and 11g databases
• Worked with storage and network engineering teams to develop highly available, resilient database configurations
• Reconfigured existing Oracle databases to new, optimized configurations and demonstrated failover capabilities
• Migrated databases supporting PeopleSoft HCM and the world's largest PeopleSoft Campus Solutions implementation
• Consolidated the Oracle Grid Control/OEM environment to improve management of the database environment

Confidential, Orange, CA: Migrated Oracle data warehouse and software.

• Migrated Oracle databases and Oracle Warehouse Builder from HP-UX to Linux
• Implemented best practices and standards and delivered documentation for in-house staff to follow
• Assisted business units in deploying and utilizing Oracle Spacial (GIS) in their data mining applications

Confidential, Palo Alto, CA: Optimize multiple database platforms supporting a complex data mining product

• Tune query performance of databases running on Oracle 11g and SQL Server 2008
• Support sales staff during client engagement and advise customer DBA teams to optimize product performance
• Improved database ETL performance, instrumental towards securing product sales and support contracts

Confidential, San Dimas, CA: Implement Oracle Utilities and Business Intelligence Applications on HP-UX

• Install and configure Oracle 11g database and Oracle CC & B and BI applications
• Manage data migrations from initial tests through production go-live

Confidential, Riverside, CA: Install and configure Oracle 11g RAC to support a 911 emergency call center

• Install and configure Oracle ASM, Clusterware, RAC and Oracle 11g databases on Linux
• Upgrade and migrate existing Oracle 9i and 10g databases to the RAC environment
• Provide documentation for in-house database administrators for RAC management

Confidential, La Cañada, CA: Manage Oracle 11g databases used by SAP Business Intelligence applications

• Install, configure and manage Oracle 11g databases and SAP application environment
• Provide ongoing performance tuning of Oracle/SAP systems in test, QA and production
• Administer Oracle 10g and 11g databases supporting PeopleSoft 9.0/9.1 Human Capital Management applications
• Configure and test backups and disaster recovery procedures, including GoldenGate and Oracle Data Guard

Confidential, San Diego, CA: Manage multiple Oracle and SQL Server databases on Windows

• Manage the Oracle database environment supporting PeopleSoft version 8.4 HR, CRM and Financial modules
• Optimize Oracle8i clinical and scientific databases and SQL Server databases and publications
• Responsible for backup and recovery of all production and development Oracle and SQL Server databases
• Configure SQL Server merge replication supporting CRM applications with over 60 remote databases

Confidential, Industry, CA: Manage Oracle10g databases supporting iRen Financial and Manufacturing applications

• Design and test off-site disaster recovery for critical databases using RMAN, DataGuard and Serviceguard
• Tune performance on Oracle and SQL Server databases to improve application response
• Implement custom summary views for use BusinessObjects

Confidential, Weston, VA: Design and deploy Oracle10g RAC.

• Install and configure Oracle10g RAC and standby configuration for high availability
• Redesign application database used to support end-user gameplay of the "Americas Army" game
• Create data warehouse for collection and reporting of game statistics and player demographics and habits

Confidential, San Diego, CA: Develop a disaster recovery implementation for Oracle and SQL Server databases.

• Develop test scenarios to verify techniques and technology to satisfy business needs of data recovery
• Perform, document and validate results of recovery testing using production simulations
• Lead and advise database assets on project scope and requirements
• Test and validate recovery procedures for PeopleSoft, Oracle Financials and other application databases

Confidential, San Diego, CA: Set up and administer production databases used by FIFA World Cup Soccer e-commerce sites.

• Perform capacity planning and performance tuning of Oracle9i databases
• Set up and confirm the functionality of backup and recovery procedures using Oracle RMAN
• Write, test and deploy shell scripts to automatically monitor statistics and perform maintenance
• Optimize databases and network resources to operate with Intershop Efinity applications

Senior Oracle Database Administrator for production and development databases, responsible for creating the database and data warehouse environment and building the company's e-commerce initiatives.

• Installed and upgraded Oracle8i and Oracle9i databases and Oracle9iAS application servers
• Designed a highly scalable database and data warehouse to manage online surveys and reporting tools
• Migrated legacy data to Oracle and rewrote perl scripts as PL/SQL procedures
• Established and verified backup and recovery of Oracle9i databases using Oracle RMAN

Confidential, San Diego, CA, 1/2000 - 2/2001
Database Administrator and supervisor three DBAs responsible for SQL Server and Sybase databases, Cold Fusion applications and Netscape web servers.

• Configured databases and applications for high availability using replication, load balancing, and backup/recovery
• Administered databases for critical campaigns including Sony, DirecTV and American Express
• Managed group resources and assigned tasks and projects to administrators
• Provided training courses for administrators and developers

Confidential, San Diego, CA, 4/1999 - 1/2000
Consulting Database and System Administrator responsible for establishing and maintaining high-availability solutions for databases up to 1.5 terabytes, and guaranteeing 100% availability of data despite server, hardware or network failure.

• Developed the configuration of Oracle replication for global Navy data centers
• Monitored and proactively addressed database performance using scheduled shell scripts
• Tested and certified servers and databases for Y2K compliance

Skills

ERP Suites
SAP BI/NetWeaver 7
Peoplesoft 8, 9
Siebel 7.5, 7.7
iRenaissance
Oracle Applications 10, 11

Operating Systems
Solaris, BSD
HP-UX, AIX
Oracle Unbreakable Linux
RedHat, SuSe, Ubuntu Linux
Windows
OS-X

Tools
SQL Loader, Data Pump
Oracle Spatial
Recovery Manager (RMAN)
Oracle Enterprise Manager (OEM)
Oracle Warehouse Builder (OWB)
SQL Server Enterprise Manager
TOAD

Database Concepts
OLTP
Partitioning
Data Modeling
Logical Design
Physical Design
Capacity Planning
Database Security
Data Warehousing
Performance Tuning

Database Concepts
High Availability
Clustering
Replication
Virtualization
Service Continuity
Disaster Recovery
Extract-Transform-Load (ETL)
Service Oriented Architecture (SOA)

Database Skills
Oracle Streams
Oracle Data Guard
GoldenGate Replication
Oracle Advanced Replication
Real Application Clusters (RAC)
Automated Storage Management (ASM)
Oracle Migration Workbench
SQL Server Cluster Database
Automation

Languages
SQL, PL/SQL, Transact SQL (T-SQL)
Shell Scripting

Specialized Skills
Database Design
Database Migration
Database Architecture
Sarbanes-Oxley (SOX)
Agile Methods/Scrum

Featured Publications
Article, Battling Growth and Staying Compliant through Oracle Application Archiving, published in the October 2005 (premiere) issue OraTips magazine
Presenter, Data Archiving Best Practices, at North Central Oracle Applications Users Group, February 2005
Presenter, Archiving Case Study, at Oracle Open World, December 2005
Presenter, Archive, Access, Audit, at the meeting of the Southwest Regional Oracle Applications Users Group, November 2004
Article, Introduction to Oracle Recovery Manager Backups, published in the August 2004 SysAdmin magazine
Developed Oracle DBA certification tests used on the ITSkillTest.com web site to evaluate job candidates' proficiency in basic and advanced aspects of Oracle database administration, SQL and PL/SQL
Author and presenter of Understanding Oracle MRP Processing at the meetings of the 1999 European Oracle Applications Users Group, Spring 1999, Spring 1998 and Spring 1997 Oracle Applications Users Group, and International Oracle Users Week '97
Article, Revising the Revision in Oracle Inventory and Engineering, published in the October 1998 OAUG Insight
Article, Defining Item Relationships in Oracle, published in the July 1998 OAUG Insight
Article, 'Must Have' MRP Alerts (Parts I and II) published in the July and October 1997 OAUG Insight
Author of programming technique published in the Fall 1991 FOCUS Systems Journal Encyclopedia

Education and Affiliations

International Oracle Users Week
VP Marketing & Executive Board Member, Boy Scouts of America/California Inland Empire Council
Oracle Applications Users Group
European Oracle Applications Users Group
Oracle DBA Masters Certification
RACF (Resource Access Control Facility) Security Expo
Information Builders Top Gun School
B.S. in Physics with Math minor