Skip to content


Resume

Shad Rich

Senior Oracle Applications Database Administrator

Technical Skills

 


Operating Systems

  • UNIX: Solaris 8, 9, 10
  • Linux: Red Hat, SUSE, Ubuntu, Oracle Linux
  • Windows: 2000/XP/2003

Programming Languages

  • SQL, PL/SQL, Bash, Perl, HTML, Java, VB .NET, C


Databases

  • Oracle 8i, 9i, 10g, & 11g (Standalone and RAC)
  • SQL Server
  • MS Access


Applications

  • Oracle 11i E-Business Suite Versions 11.5.9, 11.5.10, 12.1.X
  • Modules – BEN, FIN, HR, INV, IRC, ONT, PAY, WSH, others.
  • Discoverer 10g
  • Oracle Internet Directory 10g/11g
  • MarkView for Oracle Applications
  • Cognos Financial Planning


Tools

  • Oracle SQL Developer
  • Oracle Enterprise Manager
  • Forms, Reports, Workflow Builder
  • SQL*Plus
  • Tkprof

Work Experience


03/2011-Present    Shadandy, LLC    Seattle, WA

Managing Partner, Oracle Applications DBA

  • E-Business Suite Apps DBA Consulting
  • Oracle Database Performance Tuning Consulting
  • Amazon EC2 Oracle Implementations

11/2009-03/2011     Small Remote Database Administration Company    Seattle, WA

Senior Oracle Applications DBA

  • Lead Oracle Applications DBA for all E-Business Suite Customers

2/2007-11/2009     Large Fashion Retailer    Seattle, WA

Senior Oracle Applications DBA

  • Lead Oracle Applications DBA for a production 6TB HR/FIN instance.
  • Supported and maintained 4 load-balanced forms/web nodes and 6 concurrent processing nodes that used two shared application file systems.
  • Analyzed and successfully performed HR Rollup patch upgrades for a system that supports ~40,000 employees.
  • Managed and cloned 10 full-sized development and testing environments.
  • Primary Apps DBA resource supporting project to consolidate AP systems into Oracle AP.
  • Upgraded Discoverer 4i to Discoverer 10g.
  • Performed SQL and technology stack performance tuning.
  • Patched and supported MarkView for Oracle Applications.
  • Evaluated Oracle RAC as a high availability solution and had the technology approved by an architecture approval committee.
  • Installed and supported 2-node ASM RAC cluster for Sterling Order Management.
  • Implemented and supported Oracle Enterprise Manager to monitor 200+ databases.
  • Consolidated multiple RMAN catalogs into a single instance.
  • Rotated on-call support for every production Oracle database in the enterprise.

6/2004-2/2007     Small Biotech Company     Tucson, AZ

Senior Oracle Applications DBA

  • Experience with Oracle E-Business Suite versions 11.5.9 and 11.5.10+.
  • Patched, configured, and maintained production, development, and testing instances.
  • Enhanced and maintained 11i clone procedure.
  • Enhanced and maintained 11i disaster recovery procedure.
  • Monitored and tuned iAS, Forms, Reports, and Concurrent Manager.
  • Moved the concurrent tier off the database tier and implemented the shared application tier file system to reduce patch downtime..
  • Successfully implemented iRecruitment, HR, Payroll, Benefits, OTL, MSCA, and Discoverer 10g.
  • Securely implemented iRecruitment in the DMZ using a reverse proxy and SSL.
  • Successfully upgraded Oracle Applications from 11.5.9 to 11.5.10.2.
  • Successfully upgraded Oracle Applications database from 9.2.0.5 to 10.2.0.2.
  • Aggressively worked with Oracle Support to solve open Service Requests.
  • Supported the development team and enforced change control.

Education


2002-2004     Texas Tech University                 Lubbock, TX

  • M.S.B.A., Management Information Systems


1997-1999     Texas Tech University HSC         Lubbock, TX

  • B.S., Clinical Laboratory Science

Awards


  • Company-wide Quarterly Star Award
  • IT Quarterly Star Award
  • Runner-up for Rookie of the Year Award