Senior Database Administrator & Architect
I am a senior database administrator and architect with sixteen years experience in production environments, the last ten as a consultant in a wide variety of projects and industries. My background includes database installation, configuration and management, physical and logical data modeling, performance tuning and security analysis. I have significant recent experience with disaster recovery and high availability implementations, data and database migrations and upgrades, and extract/transform/load (ETL) projects. In addition to my technical skills, I have excellent communicator, and have written and presented numerous papers and articles in technical journals and conferences.

Work Experience

Confidential Temecula, CA, 3/2002—Present
Principal Database Consultant responsible for project database administration and architecture. Selected clients include University of Phoenix, Orange County Transportation Authority, Intuit,Yahoo, US Army, Riverside County Sheriff, Sport Chalet, Amylin Pharmaceuticals, Golden State Water, and Network Fleet.

• At the University of Phoenix I led a team of three DBAs in the redesign of the university’s disaster recovery, high availability and data security infrastructure. This included presenting and justifying project plans based on industry best practices to executive management, working with storage and systems teams to deliver a highly scalable and resilient architecture, migrating 35 Oracle 10g and 11g RAC databases totaling 70TB to a new datacenter, configuring Data Guard and Golden Gate to manage data replication, and implementing and configuring Oracle Advanced Security features to protect sensitive student and company data. The environment included the largest implementation of the Peoplesoft Financial Aid module.
• For Attensity Group, I was responsible for assessing the database design of the company’s social media data mining product, which runs on Oracle, SQL Server, MySQL and Teradata. I was successful in improving database ETL performance benchmarks by 91%.
• I designed the physical and logical data models for the Oracle 10g RAC database and data warehouses supporting the America’s Army video game used by the US Army Office of Economic and Manpower Analysis for focusing recruiting efforts. In five years on the project I exceeded all performance and availability service level agreements (SLAs). In addition, I developed all of the supporting PL/SQL code responsible for processing game events, and detecting cheating and hacking attempts made against the game. Mining data from the tens of millions of combat simulations reveale d insights for adjusting real-world tactics for improved survival of US forces in actual combat situations.
• I manage the MySQL databases for Argentive supporting content management systems (CMS) such as Joomla and Drupal.
• At the Riverside County Sheriff’s Department I implemented Oracle 10g RAC and Data Guard for their 911 emergency call center. This included migrating existing databases from Oracle 9i and providing documentation for their internal staff.
• For Election Source, I designed the MySQL databases and PHP framework of a Software as a Service (SaaS) application used by political candidates to direct limited campaign resources to individuals who are most likely to vote. One key factor in the product’s success was an automated ETL process for extracting voter information from public records provided by state and county voting offices.
• I provided pre-sales technical services for Solix, whose data archiving technology for Oracle E-Business Suite allow companies to minimize costs via tiered storage, keeping historical data available to applications.
• At Intuit, I developed, tested and documented disaster recovery procedures for their Oracle and SQL Server databases.
• For Yahoo, I configured and administered the Oracle databases used by the FIFA World Cup Soccer e-commerce sites.

Confidential Temecula, CA, 2/2001—2/2002
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.

• Designed a highly scalable database and data warehouse to manage online surveys and reporting tools
• Installed and upgraded Oracle databases, web and application servers
• Migrated legacy data to Oracle and rewrote perl scripts as PL/SQL procedures

Confidential San Diego, CA, 1/2000—2/2001
Lead Database Administrator and supervisor for DBA team responsible for Oracle, SQL Server and Sybase databases, application and web servers.

• Administered databases for critical campaigns including Sony, DirecTV and American Express
• Configured databases and applications for high availability using replication, load balancing, and backup/recovery
• 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 administering Oracle production databases, and designing and maintaining high-availability solutions

• Developed the configuration of Oracle replication for global Navy data centers
• Tested and certified servers and databases for Y2K compliance

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
Vice President, San Diego Oracle Users Group, 
Oracle Open World 
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) 
B.S. in Physics with Math minor, 

Skills

Oracle Streams
Oracle Data Guard
GoldenGate Replication
Oracle Advanced Replication
Real Application Clusters (RAC)
Oracle Advanced Security
Oracle Label Security
Oracle Data Masking
Oracle Obfuscation Toolkit
Oracle Database Vault
SQL Loader, Data Pump
Oracle Spatial
Recovery Manager (RMAN)
Oracle Enterprise Manager (OEM)
Oracle Grid Control

Solaris, BSD
HP-UX, AIX
Oracle Unbreakable Linux
RedHat, SuSe, Ubuntu Linux
Windows
OS-X
VMWarePartitioning
Data Modeling
Logical and Physical Design
Capacity Planning
Database Security
Data Warehousing
Performance Tuning
Database Migration
Database Architecture
High Availability 
Replication
Virtualization
Service Continuity
Disaster Recovery
Extract-Transform-Load (ETL)
Application Development
Project Management
Training and Mentoring
Software as a Service (SaaS)
Service Oriented Architecture (SOA)
Sarbanes-Oxley (SOX) 
Agile Methods/Scrum
Automation Application Development
Project Management
Training and Mentoring
Software as a Service (SaaS)
Service Oriented Architecture (SOA)
Sarbanes-Oxley (SOX) 
Agile Methods/Scrum
Automation
Shell Scripting

Oracle Applications 10, 11 
SAP
Peoplesoft
Siebel CRM
iRenaissance