SUMMARY

• Senior Oracle Applications DBA and Technical Architect with a proven track record.
• Over 34 years of experience in IT and over 22 years of experience as an Oracle Applications DBA.
• Extensive experience in architecture design, right sizing, Oracle E - Business software installation, upgrade, backup, recovery, disaster recovery, cloning, migrations, tuning, platform migration, virtualization, migration to cloud, and full cycle E-Business suite applications.

TECHNICAL SKILLS

• Oracle RDBMS V7.1.6 - V12.2.0.2
• Progress RDBMS V.6.x
• Oracle EBS V10.5 - V12.2.5
• Oracle 9iAS, Oracle 10gAS
• Discoverer, OBIEE, Portal, WebLogic
• Quest Software - Spotlight on Oracle and Oracle Applications, Quest Central for Oracle, Foglight on Oracle and Oracle Applications, Toad, SQL Developer
• Confio - Ignite for Oracle
• Oracle Enterprise Manager V1.x - V10.x
• Sun Solaris, HP-UX, IBM-AIX, Red Hat Linux, Oracle Enterprise Linux, Microsoft Windows
• Sun Sparc/x86, HP RISC/Intel, IBM, Dell and Cisco servers
• EMC, NetApp, HP, Hitachi, Sun, IBM, Dell
• Theos Basic, Progress 4GL, SQL, PL/SQL, Unix shell

PROFESSIONAL EXPERIENCE

Confidential, CA

Responsibilities:

• As a senior Oracle applications DBA and lead system architect for the managed services division of Trevera, provided services such as system architecture, hardware sizing, backup/recovery, disaster recovery, platform migration, data center migration, virtualization, migration to cloud, tuning, upgrade pre/post production support
• Provided on-site and remote pre/post production support to over 51 organizations
• Designed and created Oracle architecture solution for over 23 clients
• Performed individually and/or lead team of DBA’s in upgrading Oracle Database and EBS applications for over 31 clients over the years touching every major dot release
• Many of these upgrade projects involved platform migration, consolidation and/or split of Apps tier(s), and/or converting database from non-RAC to RAC
• Architected Disaster Recovery solution for over 10 clients over the years and various configurations of Oracle Advanced Architecture
• Installed DB and EBS for over 23 clients. Some including implementation of OBIEE, GRC, UPK, Vertex, SSO and SSL
• Architected (TMS) Trevera Monitoring System. A tool/utility to remotely monitor OS, DB and Applications
• Created (TECAT) Trevera Environment Collections and Assessment Tool. A utility that captures a snapshot of client database and applications environment focusing on over 100 critical items

Confidential, Irvine, CA

Senior Oracle applications DBA

Responsibilities:

• Supported several Confidential customers as part of Confidential ’ Remote Services team
• As a senior Oracle Apps DBA and lead system architect for the remote services division of Confidential, provided services such as system architecture, hardware sizing, backup recovery, disaster recovery, platform migration, data center migration, upgrade and post upgrade production support for numerous customers
• Lead the DBA team in upgrading EBS 11i to 12i, RDBMS 10g to 11g
• Upgrade project included platform migration from HPUX to HP Linux
• Architectural changes included converting the existing installation from a two node install to multi node RAC and Load Balanced application tiers

Confidential, CA

Senior Oracle applications DBA

Responsibilities:

• Lead the DBA team in providing R12 implementation support
• Project implementation included EBS R12.x, OBIEE, GRC, UPK, Vertex, SSO, and SSL running on two IBM AIX P550 servers (five LPARs) and twenty eight IBM Linux Blade servers (x86 and x86-64)
• Lead the effort to streamline the architecture and storage in order to support over a dozen CRP and Test/Dev environments
• Assisted with automation of backups of all environments
• Assisted the customer in sizing and subsequently acquiring Dell hardware
• Architected the hardware solution based on sizing information
• Installed Oracle Applications release 11.5.10.2/RDBMS 9.2.0.6 on Red Hat Linux 4
• Supported the implementation team with the implementation of Oracle E-Business Suite
• Providing on-going remote DBA support

Confidential, CA

Senior Oracle applications DBA

Responsibilities:

• Architected hardware and SAN in support of an upgrade of Oracle Apps from 11.0.3/RDBMS 8.1.7.2 to 11.5.10.2/RDBMS 9.2.0.7 on HP platform
• Supported the upgrade effort
• Architected and installed Oracle Apps 11.5.10.2/RDBMS 9.2.0.7 on Red Hat 4.0 on Dell Servers for an Internal implementation
• Created custom menus and responsibilities
• Registered custom reports
• Provided Production support for a Apps 11.0.3/RDBMS 8.0.6.3 and Apps 11.5.8/RDBMS 8.1.7.4 on Sun platform
• Cloned Dev/Test databases from hot backup of PROD
• Registered reports
• Led the team with planning and sizing of the upgrade hardware
• Laid the ground work for upgrading of Oracle Apps 11.0.3 to 11.5.10.2 and migrating the platform from Sun to Dell Linux
• Architected the hardware solution for upgrade and DR

Confidential, CA

Senior Oracle applications DBA

Responsibilities:

• Provided system architecture support and installed Oracle Applications 11.5.9 on HP RP3400 series server running HPUX 11i
• Created DEV, TEST and CRP instances from GOLD after patching to current levels of 11.5.9
• Supported the on-site implementation team with the implementation of Oracle E-Business Suite
• Installed Oracle Applications 11.5.9 on Red Hat Linux 2.1AS on Dell 2650 servers
• Assisted with installation of Oracle Applications 11.5.9 on Red Hat Linux 3.0AS on Dell 2650 servers in a 9i Database RAC environment
• Assisted with the implementation of F5’s Big-IP in setting up load balancing of EBS including concurrent managers, forms and web servers
• Created DEV, TEST and CRP instances from GOLD after patching to current levels of 11.5.9. Created PROD from GOLD
• Assisted with setup of third party solutions like Cognos and Streamserve
• Supported the on-site implementation team with EBS implementation and support client through and post go-live

Confidential, Irvine, CA

Senior Oracle applications DBA

Responsibilities:

• Lead the upgrade effort for Oracle Applications release 11.5.6 to 11.5.9 on Sun Solaris 8.0
• Assisted in relocating Production servers in order to be compliant with Sarbanes Oxley
• Lead the DBA team in upgrading RDBMS from 9014 to 9205, from 32 bit to 64bit
• Assisted customer with international projects - Asia Pacific and Europe
• Lead the DBA team and assisted customer with implementation of Trade Management entailing installing 16 additional apps modules and 100+ patches
• Assisted customer with BIS and Discoverer reporting
• Coordinated tasks with off-shore DBA team

Confidential, Irvine, CA

Senior Oracle applications DBA

Responsibilities:

• Customer implemented Receivables, Sales Compensation and Contracts modules for Apps 11.5.8 with RDBMS 9.2.0.3 on IBM AIX 5.2 integrating into Peoplesoft Financials and HR
• Lead/managed a team of 5 Apps DBA’s including mentoring 2 in-house DBA’s
• Responsible for data sizing, instance strategy and database refreshes. Streamlined cloning process utilizing snapshot and snapclone technology. Streamlined migration of customizations and extensions into Oracle Applications
• Responsible for switching/migrating Oracle Apps from AIX to HP Linux Blades. Load balanced Applications (forms and ccmgrs) and Web tiers (9iAS/Apache)
• Lead the upgrade effort for Oracle Applications release 11.5.6 to 11.5.8 on Sun Solaris 8
• Also installed Service, Depot Repair, CRM Foundation and Oracle Contracts Service Module
• Client originally implemented financials and distribution modules

Confidential, Irvine, CA

Senior Oracle applications DBA

Responsibilities:

• Assisted the customer with recovering production Oracle applications database due to hardware failure
• Created cloning document to help with future cloning process of PROD database. Assisted in reducing database hot-backup time from 13 hours to 3 hours
• Upgraded test and production Oracle RDBMS and Applications from 8.0.6.2 version to 8.1.7.4
• Provided production DBA support
• Assisted the customer in sizing and subsequently acquiring Compaq hardware
• Installed Oracle Applications release 11.5.7 and release 11.5.8 on Windows 2000
• Client implemented financials modules
• Provided Oracle RDBMS and Oracle Applications DBA support
• Providing on-going remote DBA support

Confidential, Irvine, CA

Senior Oracle applications DBA

Responsibilities:

• Assisted the customer in sizing, architecting the hardware and subsequently acquiring Sun hardware
• Installed Oracle Applications release 11.5.7 on Sun Solaris 8
• Client implemented financials modules
• Provided Oracle RDBMS and Oracle Applications DBA support
• Providing on-going remote DBA support
• Provided Oracle RDBMS and Oracle Applications DBA support for a production environment
• Client implemented Oracle Applications version 11.5.4
• Mentored on-site Applications DBA
• Assisted with sizing of new additional hardware
• Outlined the process of separating Production and Test database environments
• Assisted in the upgrade of Oracle applications to version 11.5.7
• Configured 9iAS and Discoverer 4i and Oracle Applications
• Client used Business and Financial Intelligence in conjunction with Discoverer

Confidential, Irvine, CA

Senior Oracle applications DBA

Responsibilities:

• Provided Oracle RDBMS and Oracle Applications DBA support for a post-production environment
• Assisted client in upgrading Oracle Applications from version 11.5.3 to 11.5.7
• Provided Oracle RDBMS and Oracle Applications DBA support for a pre-production and post-production environment
• Client implemented Oracle Applications version 11.5.6
• Outlined and assisted in implementing Backup and Recovery strategy
• Assisted with the interview process and subsequently mentored on-site Applications DBA
• Assisted in the setup of Oracle Applications in a Veritas Cluster configuration to minimize downtime
• Assisted in the setup of load balancing and failover of web and forms server
• Assisted in optimization of custom code
• Created standards for and assisted with the implementation of code migration process
• Supported multiple CRP environments
• Configured 9iAS with Discoverer 4i and Oracle Applications
• Assisted client in choosing and implementing Quest Software’s Foglight utility to allow 24x7 monitoring of Oracle environment
• Provided remote DBA support

Confidential, Irvine, CA

Senior Oracle applications DBA

Responsibilities:

• Providing remote DBA support for the production environment for the European operations of the Power One Companies
• Assisting the on-site DBA with the upgrade process of Oracle Applications from version 11.0.3 to 11.5.7 to 11.5.8
• Client is using Oracle’s upgrade assistance program to assist them with the upgrade process
• Assisted the customer in sizing and subsequently acquiring Sun hardware
• Installed Oracle Applications release 11.5.4 and 11.5.5 on Sun Solaris 8
• Client implemented financials and manufacturing modules
• Applied patches as necessary to provide functionality fixes
• Cloned applications environments as necessary to support post production test environments
• Outlined and implemented Backup and Recovery strategy
• Assisted with the integration of Veritas NetBackup Utility
• Providing on-going remote DBA support

Confidential, Irvine, CA

Senior Oracle applications DBA

Responsibilities:

• Provide Oracle RDBMS and Oracle Applications DBA support
• Upgraded the installation to the latest database and applications patchsets
• Installed Order Entry, Alerts and Localizations in an effort to incorporate their European and Asian operations into US
• Mentored on-site DBA’s
• Represented Oracle environment as part of the steering committee responsible for outsourcing Oracle Apps and Oracle Clarify production databases
• Implemented tools from Quest Software including SharePlex FS, Spotlight on Oracle, Spotlight on Oracle Apps, Toad, I/Watch for Oracle, I/Watch for Oracle Apps, Schema Manager, and Space Manager
• Provided production support in a 7x24 environment

Confidential, Irvine, CA

Senior Oracle applications DBA

Responsibilities:

• Provide Oracle RDBMS and Oracle Applications DBA support
• Assisted in creating three distinct environments: Production, Training and Patch
• Upgraded RDBMS from 8.0.4 to 8.0.6
• Brought the Applications to the latest patchset levels
• Assisted in installation of Oracle Apps 11i for testing
• Provide Oracle RDBMS DBA support
• Client developed custom Java Application running on Oracle RDBMS and deployed the application utilizing any third party Web Server, i.e. Webshpere, Apache, Oracle, etc.
• Responsible for certifying configurations so they could be deployed at client sites
• Configurations included Oracle 8.0.5 and oracle 8i and Websphere on Solaris 7

Confidential, Irvine, CA

Senior Oracle applications DBA

Responsibilities:

• Lead the upgrade process of Oracle Applications from Release 10.7 NCA to Release 11.0.3.1
• The installation consisted of an IBM RS6000 server as the back-end and a NT server as the middle-tier
• Assisted in resolving issues with Custom Forms and Reports
• Provided direction (necessary steps) so client could access Oracle Applications through the firewall
• This implementation consisted of Sun Solaris release 2.6, Oracle RDBMS 8.0.5.2.1 and Oracle Applications release 11.0.3.1.0.
• Assisted the KPMG functional team in activating Oracle Web Customers
• Implementation included four Sun servers - one back-end server, two middle-tier servers and the forth server was used to enable the Web Customers in a Business to Business environment allowing customers access through the firewall
• Client went live end of April

Confidential, CA

Senior Oracle applications DBA

Responsibilities:

• Provide DBA support and on-site training
• Responsible for fine-tuning the system
• Reduced MRP run-time by 17%. Automated rebuilding of indexes in order to de-fragment the database
• Created a formal process for migration of customizations from Test to Production database
• Led the effort from a DBA perspective for evaluation of a SAN and Disaster Recovery solution
• Responsible for setting up a server to facilitate the certification of ten production databases to be Y2K compliant
• The enterprise environment consisted of a 10.7 NCA database, 10.7 SC Prod 16.1 database, Oracle Express database and seven custom databases
• All databases interfaced with 10.7 NCA database
• Led the team of DBA’s responsible for Y2K certification for the production environment
• Supported production database environment
• Worked with internal audit team to answer/address all concerns regarding Oracle database and application security issues

Confidential, CA

Practice Manager

Responsibilities:

• Managed Oracle Application DBA practice
• Mentored and supervised the development of the DBA’s
• Acquired additional business with existing clients
• Involved in sales cycles to acquire new projects for company
• Responsible for technical estimates for RFP’s (request for proposals)
• Participated in the creation of a new product/service where clients would purchase remote DBA support. Performed hardware sizing for all clients

Confidential, CA

Practice Manager

Responsibilities:

• Supported several CRP (conference room pilot) environments
• Created several databases on SUN E10000 server
• Supported SmartDB environment for data conversion from legacy systems
• Created additional space on the servers by rightsizing the databases
• Migrated Data Warehouse databases from NT to Unix servers
• Created database backup scripts and automated them
• Created Unix scripts to set user environments upon login

Confidential, CA

Practice Manager

Responsibilities:

• Installed Oracle RDBMS 8.0.x, Oracle Financials 11.0.x, Oracle Web Applications Server 3.0.x, and Developer 2000, 1.6.x and 2.x on Sun E4500, Sun E3500 and Sun E450 servers
• Supported multiple (6-12) databases
• Trained on-site DBA’s
• Involved in the resolution of functional issues
• Established backup and recovery strategies
• Documented the installation process
• Optimized MRP: reduced run time from 10 to 3 hours
• Created production environment and helped transition the client from implementation to production
• Installation was multi-org and multi-location environment
• Two of the test instances were running MRC
• Provided post-production support
• Recovered the Production database due to database corruption

Confidential, Las Vegas, NV

Principal Consultant

Responsibilities:

• Installed Oracle RDBMS 7.3.4, Oracle Financials 10.7, Smart Client Production 16.1 on an IBM AIX RS/6000 platform for a health services company in Las Vegas
• Performed server sizing analysis and physical database layout confirming to Oracle's OFA (Optimal Flexible Architecture) standard
• Automated database and applications startup/shutdown procedures and created technical portion of project plan
• Allocated hours and resources for all technical tasks, utilizing Oracle's AIM methodology
• Prepared a plan to move the data from a test/development environment to a production environment
• Prepared a document outlining roles and responsibilities of the DBA, systems administrator, and Express DBA
• Trained on-site DBA and systems administrator on the installation and maintenance process
• Interviewed DBA's and technical resources for the project
• Performed database and applications performance testing for Litton Aero Products
• Identified network and application bottlenecks and provided solutions
• Outlined twenty-four possible solutions to improve the database, applications, and network performance
• Installed Oracle RDBMS 7.2, Oracle Financials 10.6 Smart Client Production 14 on an NT 3.51 platform for the Commander in Chief Pacific Fleet, in Pearl Harbor, Hawaii
• Installed Oracle RDBMS 7.3, Oracle Financials 10.7 Smart Client Production 16 on an NT 4.0 platform
• Both installations conformed to Oracle's OFA (Optimal Flexible Architecture) standard
• Documented server and client installation process; performed the sizing analysis for hardware requirements for production and testing server; converted three to five years of historical data from various legacy systems; wrote SQL and PL/SQL scripts; and trained on-site DBA and systems administrator on installation and maintenance process