PROFESSIONAL
SUMMARY:
Over 18 years US experience as an Oracle Apps (E-Business Suite) Database Administrator.

Extensive experience in the installation, implementation, and maintenance of
ORACLE RDBMS and ORACLE EBS (E Business Suite) Application systems in its full life cycle

Extensive experience in upgrading ORACLE RDBMS and ORACLE EBS(E- Business Suite) Applications from older versions to its most current releases.

TECHNICAL
SUMMARY:
Installation and maintenance of ORACLE RDBMS versions 6, 7.02, 7.05,
7.1.3, 7.1.4, 7.3.3, 7.3.4, 8.0.4, 8.0.5, 8.0.6, 8.1.7 (8i), 9i, 9i RAC, 10gr2,
10.2.0.4, 10.2.0.5, 11gR1 & 11gR2 ( 11.1.0.7, 11.2.0.1, 11.2.0.2 )

Installation and maintenance of ORACLE ERP Applications releases 9.4,
10.3, 10.5, 10.7, 11.02, 11.03, ORACLE E-Business Suite release 11.5.3,
11.5.6, 11.5.8, 11.5.9, 11.5.10 CU2, R12 (12.1.1 & 12.1.3 ) OAS 8i, 9i 10gAS ( 10.1.2 ), (10.1.2 ), (10.1.3 ), Oracle Discoverer 10.1.2.2, 11g Oracle Weblogic 10.1.3.x, Fusion Middleware 11.1.3.x,
( Oracle application servers 10.1.2.3 which includes Oracle Developer 10i and
Oracle application server 10.1.3.5 which includes Oracle HTTP server for EBS R12), Oracle Maintenance Wizard 2.19, Data Migration Assistant for
Unicode ( DMU )

Worked extensively on the ORACLE RDBMS and ORACLE EBS Apps on
Platforms such as HP-UX 9, 10, 11, Sun Solaris 2.5, 2.6, 7, 8, 9, 10, IBM
RS6000 AIX 4.2, 4.3, 5.1, Windows 2003, NT, Linux Red Hat EL 3,4,5.

Good working knowledge of Oracle DBA tools such as SQLPLUS, PLSQL,
SQLDBA, Oracle Enterprise Manager ( Grid Control ),
UTLESTAT/UTLBSTAT, Explain Plan, TKPROF, Shell Scripting,
EXPORT/IMPORT, TSReorg, ARIS Dfrag, Sqlloader, backup/recovery,
performance tuning.

Extensively involved in ERP Application Administration tools and Utilities
such as AOL, Concurrent Manager, ADPATCH, ADSPLICE, ADCTRL, ADADMIN, Sysadmin application responsibility functions,
Rapid Clone(cloning Oracle Apps r11Ii and r12),
and Application core DBA product problem resolution.

WORK
EXPERIENCE:
Confidential,Jan 2012 – Present
Senior Oracle Apps DBA ( consultant ) Jan 2012 - Present

to UTF8 then to AL32UTF8 using DMU ( Data Migration Assistant for
Unicode ).

applications release 12.1.3 including patch bundle application to the
10.1.2.3 tools middleware and applying the 10.1.3.5 patchset to the 10G
application server ( RHEL 5.7 platform )

issues.

for the Oracle Applications upgrade.

Confidential,Oct 2010 – Dec 2011
Senior Oracle Apps DBA ( consultant )

Confidential,Feb 2010 – Sept 2010
Senior Oracle Applications DBA ( consultant )

system running on a 10.2.0.4_64 bit Oracle Database to Oracle E-Business 12i ( 12.1.1 ) running on an 11gR2_64 bit ( 11.2.0.1 ) Oracle Database on RHEL 5 update 3.

upgrading the Oracle Applications 11.5.10.2 first, (applying interop
patches To the 10.2.0.4 RDBMS_ORACLE_HOME ) to 12.1.1. After the
upgrade of the application to 12.1.1, upgraded the Oracle Database to
11gR2_64bit.

requests with Oracle Support

system ( before the upgrade )

Confidential,Jan 2008 - Dec 2009
Senior Oracle Apps 11i Database Administrator ( consultant )

environment on a linux 3 Hugemem (2.4.21-57.ELhugemem) platform and
9.2.0.6 ( upgraded to 9.2.0.8 ) release of the RDBMS ( oracle 9i ).

Service Request ( TAR ) resolution with Oracle Support ( including Sev 1
TARS ), developer support, user connectivity issue resolution, printing resolution, and patch application ( adpatch , opatch ).

( 10g AS ) 10.1.2.2 - APPS mode EUL on DEV, QA, and PROD environments.

rapid clone ( adcfgclone.pl ) – shared APPLTOP.

concurrent programs, custom menus, Descriptive flexfileds, Value sets,
report files ( RDF ), custom forms ( fmb and fmx ), and pl/sql code.

Confidential,April 2007 – Nov 2007
Pasadena CA
Senior Oracle Apps DBA ( consultant )

applications 11i ( 11.5.10 CU2 ) and Oracle 10gr2 environment running
on Sun solaris 9 and 10 platforms ( on E10k, E15K and T2000 hardware ).

running various other applications such as CONCUR as well as databases
running applications that interfaced with Oracle Apps such as KRONOS with JBOSS running as its application server.

Windows 2003 with the management console running on Sun solaris 9. Configured Grid control plugins such as Weblogic 8.0.

Oracle Application modules ( eg. Financials Family Pack G, HR, PA )
And performed patch applications on a test database and documented
All problem resolutions encountered during the patch application.

and update procedure.

- provided user and developer DBA support including resolution of Oracle
Service Requests ( TAR ) with OWS ( oracle worldwide support ).

Confidential,Jan 2003 – Mar 2007 Inglewood CA
Senior Oracle Apps DBA ( Consultant )

supported the infrastructure of the implementation of the Financial
modules – GL, AP, FA on Oracle RDBMS 8i

platform to Linux Red Hat 3.0 on HP Proliant hardware running a 3 node
9i RAC configuration.

Inventory module on release 11.0.3 to Oracle E-Business Suite
Release 11.5.9 on a 9i RAC configuration ( Oracle 9.2.0.5 RDBMS ).

environments on a 9i RAC configuration, for the implementation of
the Order Management module on 11.5.9 for U.S., and Canada.

feature – secondary node defined for concurrent managers ).

application and administration, capacity planning ( free space and growth ),
functional problems resolution, technical problem resolution ( reports and
forms ), Cloning the production environment to TEST and QA using Rapid
Clone ( cloning to RAC and non RAC environments ), Interface problem
Resolution ( interfaces to SQL server databases and HP-3000 Image database interfaces to Oracle E-Business 11.5.9 Apps environment, SGA
Resizing ( from 1.75G to 2.7G for each RAC DB ), implementation of Huge TLB ( huge memory pages ) and Huge Kernel for Linux 3.0.

Confidential,Aug 2001 – Sep 2002 Long Beach CA
Senior Oracle Apps DBA ( Consultant )

7.3.5 RDBMS and Oracle Fin/Mfg 10.7 character to Oracle 8i ( 8.1.7 )
and Oracle Fin/Mfg 11i ( 11.5.4 ) on an IBM RS6000 AIX ( 4.3.3 )
platform.

environments ( instances DEV and TEST ), configuration of Apps and
web servers, cloning ( adclone ) and working with developers in the
migration and testing of custom code.

on problems related to the upgrade as well as the application of
patches to resolve problems.

Confidential,September 1999 – July 2001 Inglewood CA
Senior Oracle Database Admin. ( Consultant )

Support ) Release 11.0.3 for Spanish ( E – language code ) and
Portuguese ( PT – language code ) on an existing Oracle Apps
( Fin/Mfg ) release 11.0.3 English ( base language ) installation.
( Platform - HP9000 N Class running HPUX 11.0 )

and Oracle Fin/Mfg release 11.03 on a 24X7 operating environment which
involved performance tuning and monitoring, tablespace and extent
management, and concurrent manager/web/Apps server troubleshooting
and management.

analysis, troubleshooting, and resolution to Application functionality problems such as Forms/Reports, AOL, and Apps Sysadmin issues
including acquisition of patches from OWWS, application to test and
production.

EMC\'s symmetrics application which involves BCV ( Business
Continuing Volume ) split on the entire production environment and
mounting the BCVs on the test box for backups.

Confidential,July 2000 - Sept 2000 Pasadena CA
Senior Oracle Apps DBA ( Consultant )

release 11.0.2 to 11.0.3 on a Sun solaris 2.6 platform.

and Oracle Self Service Web Apps as part of the upgrade process.

included the application of the post 11.0.3 upgrade MRC mini-pack,
Euro Enhancements mini-pack, and the latest MRC Micro-pack; validation
Of the APPS schema; support for post conversion testing.

Organizations ( Multi – Org )
- provided post upgrade and post conversion technical support.


Confidential,Mar 1999 – Jan 2000 El Segundo CA
Senior Database Administrator ( Consultant )

Oracle Financials and Manufacturing release 11.0 ( upgraded to 11.02 )
On 2 4-way Sun Ultra Sparc 4000 database servers running on Solaris 2.6
(Development and Production)

And Oracle Forms Server on 3 Sun Sparc Servers as apps/web servers
for an Oracle Fin/Mfg Release 11 NCA infrastructure.

to the aforementioned Oracle Applications Release 11 architecture.

implementation of the Oracle Instance strategy and scheduled refreshes and the establishment of an operational backup and recovery routine.
( These were all done for both development and production environments).
- performed all physical database file layouts for all instances on two database servers; wrote all startup and shutdown scripts for all databases,
concurrent managers, and all the configuration of the Apps forms/Web
servers.

team by troubleshooting problems with setup, data, or code (pl/sql) execution.

Confidential,Oct 1997 - Jan 2000 Burbank CA
Senior Database Administrator - Infrastructure ( Consultant )

- installed and configured Oracle7 RDBMS v73341 and Oracle Fin/Mfg
release 10.7 Prod16.1 on an HP9000 K460 and K570 ( HPUX 10.2 )
smart client 10sc running on Windows NT ( shared install ).
- upgraded all databases to ORACLE7server v734 for Y2K compliance.
- developed and implemented the instance strategy for the development
and production servers ( HP9000s ), including scheduled refreshes.
- designed and implemented all ORACLE and HPUX configurations which
included volume groups, logical volumes, and file system configurations,
UNIX kernel parameter configurations ( 5 instances per box),
ORACLE_HOME, APPL_TOP, and datafiles layout compliant to OFA
standards.
- performed all database administration functions including script creation
of all database refreshes, object sizing ( including tablespace ), patch
version control and application, and overall disc space management.
- provided implementation, “go-live”, and production DBA support
as well as capacity planning and the establishment of database
operational procedures.
- performed all application system administrator functions including
application user setup, assigning responsibilities, GUI menu
customizations, printer setup, profile values setup, and overall
applications troubleshooting and ORA & FRM error resolutions.
- developed and implemented the HP-UX cold file system backup
using OMNIBACK II for all databases on two systems.
- installed all Oracle Applications ( Fin/Mfg) relase 10.7 Y2K patches
including 10 megapatches and 34 client and server patches.

Confidential,Jun1997 - Oct 1997
San Diego CA
Consultant ( Oracle DBA/Oracle Fin/Mfg Apps Administrator )

- team member Sony-Oracle Implementation Team as a database
administrator and Oracle Fin/Mfg ( 10SC release 10.7 PROD 16 ) Apps
administrator.
- performed all DBA functions including database sizing, tablespace
and object extent management, version control on all patch
application, and performance monitoring and tuning.
- provided developer application support by facilitating custom
application integration into AOL by registering all customized
application extensions, ORACLE IDs, custom forms, and the
creation of new report sets and incompatibilities.
- provided user support by the creation of custom menus and
responsibilities and the resolution of concurrent manager problems.
- interacted frequently with the Systems Administration group regarding
the placement of datafiles, unix kernel parameter adjustments and
overall system performance enhancement

Confidential,Nov 1996 - Jun 1997 Santa Monica CA
Oracle DBA / SAPR3 Basis Administrator

- installed Oracle7 server v7.2.3 and SAP/R3 v3.0f on four HP9000
K460 servers for development, test and production.
- setup and configured Corrections and Transport System.
- performed all Oracle DBA related functions including SGA buffer
management, tablespace management, and performance tuning.
- developed and implemented “hot” backups for all SAPR3/Oracle
databases using Omniback II and the “backinit” interface to
SAPR3’s brbackup utility.
- developed and implemented all recovery procedures using SAPR3’s
brrestore utility and using Oracle’s server manager.
- performed all aspects of SAPR3 Basis administration including
SAPR3 buffer management, installing hot packages, job scheduling
and monitoring, dump analysis and resolution, user and profile
( authorization ) creation and maintenance, and client copies.

Confidential,Oct 1989 - Nov 1996 Simi Valley CA
Data Base Administrator July 1992 - Nov 1996

- installed and upgraded all versions of the ORACLE 7 server and
ORACLE Financials and Manufacturing; running Oracle7
server v7.1.6 and Oracle Fin/Mfg v10.5.
- designed, configured, and implemented the placement of all ORACLE
- product files ( RDBMS & FIN/MFG ) and the layout of the physical
database ( control, redo log, and data files ) on 2 HP-9000/HP-UX
platforms. ( development and production environments )
- configured all HP-UX 9.04 & 10.01 kernel and ORACLE7 RDBMS
parameters ( init$ORACLE_SID.ora ) to enhance RDBMS performance.
- working knowledge of ORACLE diagnostic tools such as Utlbstat/Utlestat,
Explain Plan( utlxplan), SQL Trace, and Tkprof.
- developed and implemented dynamic PL/SQL and SQL database
maintenance scripts for creating new databases/instances, issuing grants
and synonyms, recompiling invalid objects, recreating table specifications,
moving a user’s schema to a new tablespace, and other general database
maintenance functions.
- developed, tested, implemented, and documented all backup ( export/
import & file system ) and recovery procedures for all projected
failure scenarios.
- performed all Oracle Financials/Mfg System Administrator functions such as
the development of customized menus, responsibilities, and zooms; user
setup; the creation and registration of a new ORACLE ID ( MIC ) that would
house all Micom custom developement ( eg. rdf and inp files ); the definition
of additional concurrent managers and concurrent processing management;
and the definition of custom report sets, groups, and security groups.
- performed all major Oracle DBA tasks including tablespace management
and object creation, Oracle RDBMS v7 server and Oracle FIN/MFG v10.5
troubleshooting and patch installation, and Oracle7 RDBMS/HP-UX
performance tuning ( I/O & memory bottleneck identification and
resolution ).

Computer Specialist Oct 1989 - July 1992
- maintained daily, month/quarter/year end production schedules
- performed all functions in computer operations of the HP-3000
running a customized ASK/MANMAN application.
- performed all database maintenance and system administration tasks
on the HP3000/MPE.
- created parallel databases for FA, AP, and OMAR modules for month-end
reporting through IMAGE DBMS utilities.
- developed and implemented month and year end closing procedures
for all application modules.

Confidential,July 1984 - Sept 1989 Chatsworth CA Computer Programming/Operations and Production Scheduling

- developed and implemented daily, weekly, and month-end batch processing production schedule through OCS on
an HP-3000/MPE platform running ASK/MANMAN.
- performed all functions in operations including backups,
report printing and distribution, and functional user support
on the hardware, operating system, and application.
- performed system administration tasks such as IMAGE dataset
capacity adjustments, disc packing, peripheral device configuration
and overall system maintenance.
- modified and customized MANMAN standard report in FORTRAN and developed new reports using COGNOS/
POWERHOUSE Utilities (QUIZ)

EDUCATION:
Bachelor in Business Management