|
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
|
|
|
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
|