SUMMARY:

• A Certified Oracle Professional (DBA) with over 20 years IT experience and US citizen
• Responsible for performance tuning, troubleshooting, monitoring, and resolving technical issues.
• Provided 24x7 support for mission critical systems that are up to 10TB in size.
• Performed RDBMS upgrades from 8i to 9i and 10g, 9i to 10g, 10gR2 to 11gR2.
• Implemented RAC, ASM - Grid Infrastructure, Data Guard. Streamlined custom cloning of Oracle databases using NetApp Snap Manager for Oracle (SMO).
• Monitored using OEM Grid control.
• Created logical and physical standby databases with Dataguard.
• Managed database in various platforms such as Unix, Linux and Windows and SAN storage systems such as Hitachi, EMC and NetApp.
• Oracle EBS DBA since 1992; Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, proactive fire fighting, developer/integrator relations, script development, documentation and DBA .
• Specific Oracle Applications modules installed include AP, GL, AR, FA, PO, PA, QA, INV, OE/ONT, HR/Payroll, BOM, MRP, WIP, BIS, FII, I Procurement, CRM, Isupplier and Istore.

PROFESSIONAL EXPERIENCE:

Senior Oracle DBA & Senior EBS DBA Architect

Confidential

Responsibilities:

• 24x7 DBA support to mission critical business systems such as PeopleSoft HRIS, Custom research RAC databases
• 10gR3 and 11gR1/R2, dataguard for both 10gR3/11GR1/2.
• Support about 500 different inhouse custom datawarehouse on oracle exadata, supported ETL, Query both Star and Snowflake.
• Tuned collection of atomic data.
• Helped with database upgrades and filled in on all aspects while department had 5 dbas take a sabatacal over the summer.
• 24x7 DBA support to mission critical business systems such as PeopleSoft HRIS, ModelN, Siebel CRM, CVT Integration, GILDA, GNET, ARISg and GEMs and including Vmware ESX environments.
• Configuration, installation, trouble shooting, server security and shell scripting. Utilized Net apps SMO technologies for auto refreshes and SMO Clones. Enabled ARISG and GILDA DR database’s capabilities using Oracle Dataguard. Supported oracle EBS 12i (12.1.2) with 11GR2 rdbms - dataguard active standby modules full Financials, Demand Planning, Order Mgmt and Manufacturing with global accesss for CRM. All the patching and cloning, 4 node shared appltop, 2 node RAC with dataguard near zero dataloss configuration. PeopleTools 8.11/8.51 PeopleSoft 8.x upgrade to 9.1 OBIEE 7.9.6 - ETL process - DAC

Confidential

Technical Lead

Responsibilities:

• responsible for install and upgraded to 12i for Oracle EBS modules CRM, Oracle Financials, Inventory and Order Management.
• Upgraded 11.5.10CU2 RAC 10gR3 to 12i (12.0.6 to 12.1.1 upgrade)
• Trained internal DBA on 12i patching and procedures for FIN, OM, INV and CRM modules.
• PeopleTools 8.11 Peoplesoft 8.x
• Lead DBA responsible for the setup and support of 5 remote hospitals that included the USA’s largest VA hospital.
• The infrastructure consisted of 5 Oracle 10GR2 databases and 5 Physical Standby databases supporting the PICIS software with Oracle Dataguard.
• The PICIS software monitors the patient’s vital signs and is deemed mission critical.
• The environment’s infrastructure consisted of Linux RHEL 4.7 and 5.3 with Oracle 10g/11g RAC on Linux
• Installed and configured Oracle ASM, RMAN, Data Guard, Grid Control, OLTP SQL tuning and ETL tools, Oracle Business Intelligence Enterprise Edition (OBIEE) for a custom Analytics Solution for all of the VA VISN hospitals (170 in Total) for a multi-terabyte data warehouse.
• Designed, Installed and Supported 24x7 5 9s lights out operations and solutions for Police, Fire and rescue Computer Aided Dispatch systems, (CAD) - AVL/GPS positioning that utilize an Oracle RAC 10gR2 on Linux ES 4.5 with Oracle’s ASM.
• Providing phone and hands on support to resolve customer issues with software on site.
• Largest customer was LAX airport which is Oracle 10GR2 RAC installation with Physical Standby
• Performed upgrade from 11.5.9/9i to 11.5.10 Cumulative Update 2/10GR2 Installed and configured Physical Standby with a multi terabyte production database.
• Modules supported for the projectFinancials/HRMS/Install Base/CRM/OM Performed duties in tuning large custom applications and boundary
• Troubleshooting and performance support - Trace and TKPROF to help developers tune custom SQL.

Confidential

Responsibilities:

• Migrated Oracle ERP from Solaris to Linux, this included the OS port and upgrade from 11.5.8 oracle ERP and Oracle 9i RDBMS to 11.5.10 CU2 with Oracle 10gR2 RAC and ASM utilizing RMAN and Dataguard to do handle the port.
• The modules I supported were Financials, Order Management, CRM, HRMS, Oracle warehouse management and Oracle IStore.
• The install incorporated the Big IP F5 load balancer with a Shared APPLTOP and client also purchased another company which was on 11.0.3 and that company was incorporated into that upgraded system as a conversion.
• Upgrade 11.5.9/9i to 11.5.10 Cu2/10GR2 for the following modules FIN/OM/INV/HRMS/Oracle iStore. RAC 10gR2 ASM, Logical and Physical Standby utilizing RMAN Load Balance big IP F5 3 tier front end as well as DMZ setup load balancer iStore. Setup 2 node Parallel Concurrent Processing -Single Sign On - 10g Application Server.
• Utilized transportable tablespaces to speed up the migration from HP/UX to Linux.
• Installed and upgraded to Oracle application’s version 11.5.10. The project consisted of migrating off of JDE running on an AS/400. The infrastructure was converted to IBM Aix with the storage component being a Dell/EMC SAN. A Big IP F5 load balancer with Shared APPLTOP was incorporated into this architecture in production as 2 applications nodes were utilized and 3rd was setup in the DMZ.
• Upgraded from 9i/11.5.7 to 10g 11.5.10-CU1, modules supported Fin/MFG/ODP/OE DBI. Single Sign On -10g Application Server load Balance big IP F5 3 including DMZ setup for iSupplier. RMAN and RSYNC custom cloning scripts and installed and configured GRID 10.2 and integrated OAM.
• Installed and upgraded to Oracle application’s version 11.5.10. This project was divided into 3 sub projects, the first project was upgrading a production Oracle Financials from 11.5.8/8i to 11.5.10/9iR2. The second project was a separate HRMS/Payroll install with the third being a Project Account- DBI reporting instance. A total of 60 instances supported during the overall projects lifecycle.
• Created custom cloning scripts utilized RMAN, RSYNC (AD tools - adprelcone.pl/adconfig.pl). Installed DBI 7.0.1 reporting instances ERP Modules: Financials, HRMS/Payroll (Datainstall/Vertex), Oracle Time- Labor and Project Accounting.
• Installed and upgraded to Oracle ERP from versions 10.7/8i to 11.5.10/9iR2 and helped architect and test the upgrade process from beginning to end with some 330 patches.
• Production support for 10 terabyte Oracle EDW data warehouse that held ERP rollup data for reporting. Provided DBA support for applications code base migrations, this included working with developers for troubleshooting interfaces to the core financials and inventory and for the EDW the ETL interfaces to ERP.
• Supported 24x7 Ecommerce retail web site that had as many as 70,000 concurrent users during peak season and the order management component did around 2 billion dollars a year from this web site.
• Setup and managed Multi-Master Replicated Ecommerce sights
• Responsible for installing/configuring RMAN backups and setup of hot-standby for 24x7 SLA.
• Supported large data warehouse and spam email system called Kana-connect marketing system. Installed and tuned Oracle Retek modules.
• Installed and upgraded to Oracle application’s version 11.5.6 from 11.0.3 NCA and returned later to patch to 11.5.9. The project included setup and interfacing to a beta version of Oracle IStore.
• Installed and patched eight 11.5.9 instances, including 9 foreign languages Upgrade from 11.0.3 NCA to 11i included server port.

Confidential, San Francisco, California

Sole DBA and Technical Lead

Responsibilities:

• Oracle DBA and Applications DBA for a Global Implementation and Upgrade of Oracle Financials 11.0.3 to 11i. Implementation included databases.
• Responsible for day-to-day operations of Oracle financials for Global implementation, responsible for upgrade to 11i (11.5.2/11.5.3 ).
• Performance tuning, NLS (Simplified Chinese and Traditional Chinese).
• Troubleshooting of module issues with functional implementers and patching of Oracle ERP and Oracle RDBMS.
• Technical Lead and Oracle DBA on the technical team on interfacing to the Oracle Application open interface tables for Order Entry, manufacturing and financials. Lead developer and DBA for the custom report efforts and customizations to responsibilities and security managed of the applications.

Confidential, Chicago, Illinois

Senior DBA and Senior Financials DBA

Responsibilities:

• Led for a project team consisting of 7 people, 5 full time technical resources and 2 functional. The effort was the designing an Oracle Solutions Development Center for a major consulting firm. Led infrastructure architecture team consisting of 3 Jr. DBA’s to install the Oracle ERP for the solutions center. Performed duties for supporting up to 10 concurrent implementations of the oracle ERP through the solutions center.
• Led IT infrastructure methodology team. Responsible for designing and implementing the Oracle Applications practice IT methodology for a major consulting firm. Included projects that were in the Oracle Lab as well as projects that were to be run strictly at the client’s site. For projects in the lab, this included the lab support model and approach, database cloning and database instance strategy, patching strategy, knowledge transfer to the client and global project support.