SUMMARY

A Certified Oracle Professional DBA with over 15 years IT experience

• Oracle core DBA 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 9i/10g/11g to 12c, others in the past are 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 perl and OEM. In the past leveraged technologies like 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 and Exadata.
• Oracle EBS DBA 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 training. 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. Leverage rapidwiz and adclone,adpatch etc..

TECHNICAL SKILLS:

• Software: Oracle Database 7.x,8.0.x, 8.1.X,9.x,10.1.x,10.2.x10G AS,9iAS,10g AS,9i RAC,10g,11gR2/12.1.0.2C Grid infrastructure, Oracle ASM. OEM 12c 12.1.0.4 GRID/RAC,Dataguard,10g ASM, Oracle Web Server 12c/9ias,10gas, 3.x. and 4.x, Webdb 2.5. Oracle Applications 11i 11.5.1 11.5.10.2 , older versions 10.5, 10.6 SC Prod 14/15 , 10.7 Prod 16/16.1 , 10.7 NCA, 11.0.X NCA, Radley Caras V5 and V6 . I2 Factory Planner and Rythymnlink 2.x . PL/SQL, SQLPLUS, C, UNIX SHELL KORN, BORNE, CSHELL . Patrol, Chain Link. Sun Solaris 2.5,2.6,2.8,2.9 ,HP/UX 10.20,11.0,11i , AIX 4.3 and 5.x , Redhat Linux 7.1,7.2.7.3 ES 3.0,4.5,5.x,6.x ,DataGuard logical and physical standby.Supporting custom database designed with Hibernate/Jboss Oracle APEX 3.x and 4.x CSS Layouts and PDF design webforms with java containers. Oracle replication 9i/10g/11g Golden Gate from IBM DB2 to Oracle 11G and SQL Server 2008R2 to 12c.
• Hardware: HP Linux Servers, IBM Linux Servers, Dell Linux Servers, HP Blades, IBM Blades. Oracle Exadata, Oracle/Sun Sparc and X86, ,Sun Netra 12, E6500, E5500, E4500, E450, E250, Ultra 2. HP SuperDome, V Class, N Class, L Class, K370, K460. Storage TEK 9370, Hitachi 9xxxx,EMC ,MTI Storage, Sun T3, A5000, A7000, A1000 disk arrays, HP AutoRaid, FC60 EVA. Viking SAN storage and Netapps.

PROFESSIONAL EXPERIENCE

CONFIDENTIAL

• 24x7 DBA support to mission critical business systems for home health monitoring system. Oracle 10g and 12c dataguard. Oracle golden gate 12c. Oracle Enterprise manager 12c 12.1.0.4 .
• Modernized aging 9i Oracle RDBMS via 12.1.0.2 RAC deployment including custom Health Hero product conversion, introduced Oracle Golden Gate for replication of 9i production databases to the new 12c 3 node RAC, performed comprehensive application optimization including interval partitions on key tables that amassed several trillion rows and several terabytes in size, achieved throughput rate of 100 billion transactions per minute.
• Customized OBIEE 11.1.7.1 solution for internal billing and customer facing dashboards and business defined key performance measures. Developed centralized customized data warehouse with RAC pluggable databases and obiee with ODI, Hadoop and big Data.
• Led the database team through the development of custom databases for Veterans Affairs as well as other commercial products, coordinated teams internationally to deploy world wide data centers with custom bi directional replication.
• Integrated Oracle identity management with OBIEE,Oracle 12c along with LDAP.
• Led SQL migrations from 2000,2005 ,to 2012 and Management Studio.

CONFIDENTIAL

• 24x7 DBA support to mission critical business systems for home health monitoring system. Oracle 11gR3 active dataguard and sql server mirrored database.
• Played a key technical role in helping secure a major funding win for cancer and gastrointestinal research by providing relevant and timely analytics having designed, developed and deployed an OBIEE analytical application to provide the VA Endo researchers with quality metrics and KPIs key performance indicators .
• Managed OBIEE Stack Weblogic Cluster and identity managment.
• Innovated with current toolsets to pull together data via custom ETL from disparate and distributed sources including Sybase, SQL Server, MySQL, VAX VMS flat files and Oracle employing custom interfaces/APIs, BLOB with XML type to match the various data layouts and transform them into custom facts and dimensions in star and snowflake schemas recommended and implemented latest technologies, such as Oracle Exadata and Exalogic, to accommodate business needs of the client. Desgined datamodel and wrote custom pl/sql as well as integrated with Hadoop/Big Data.
• Sql server 2008 R2 and Sql server 2012 management Studio.

CONFIDENTIAL

• 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. Oracle Id Mgmt Aim
• 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
• Supported mySql and Sql Server.
• Integrated Oracle identity management in the stack also OAM and OEM.

CONFIDENTIAL

• 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. Including Sql server HA and my sql rdbms.
• Supported MS SQL 2000/2008 R2

Project at Data

• 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
• Ms SQL Server 2000/2005.

CONFIDENTIAL

• 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 for Williams Sonoma/PotteryBarn
• 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

• Oracle DBA and Applications DBA for a Global Implementation and Upgrade of Oracle Financials 11.0.3 to 11i. Implementation included databases in Hong Kong, Taiwan, Korea and United states. 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

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

CONFIDENTIAL

• As a Senior Principal Consultant I performed duties as Led Applications Tech in which I led a small DBA team on the installation of the 203 North LaSalle Chicago office's demonstration center. The 203 N. LaSalle Demo Center used Oracle Applications 10.7 Prod 16 and 16.1 Smart Client along with Citrix/Winframe 1.6. This architecture was used to deploy and manage the PC client side software rollout. The center supported 50 salespersons out of the Chicago office.
• As Principal Consultant for Oracle Core Technologies, performed 35 installations of 10.6 SC Prod 3 to Prod 15 , 10.7 Prod 16/16.1. Did Oracle/Unix system performance tuning, database and Oracle Applications patching. Installed the Smart Client SC architecture with the Oracle Client Configuration Manager OCCM . Performed duties as project trouble shooter for the Oracle ERP.
• Installed Oracle Applications Several 11.0, 11.0.1 and 11.0.2/3 NCA in the Oracle at customer sights. This included installation of the servers, Sun Solaris 2.5.1 and HP/UX 11.0. Installation of Oracle Applications 11.0 NCA, Oracle 8 databases oracle Web Server 3.x.
• Multiple upgrades from 10.5 to 10.6.
• International troubleshooting Core DBA team traveled to Penang Malaysia, Tokyo Japan, Germany and Seoul South Korea install the Oracle ERP 10.6 or 11.0.3 and to fix stalled technology projects.
• Trained by Oracle corporation boot camps for installation and upgrades for the Oracle ERP by the actual designers and developers of the AD Applications DBA tools suite.
• Worked on internal oracle applications teams on core techniques for upgrades, tuning and project troubleshooting for the Oracle ERP.

CONFIDENTIAL

• Installed Oracle Applications 10.5 and Avalon Order management system. Lead DBA for the Aftermarkets re engineering effort. Designed and implemented a 10,000 object database to support the Cummins Aftermarket Warranty and Claims system based on Forms 4.5 and Oracle 7 architecture.
• Served on several corporate committees as a technical consultant to select key infrastructure products and to formulize plans for the Cummins IT strategic direction.

CONFIDENTIAL

• Installed, monitored and maintained Oracle 6 and 7 databases on Sun Model 690 and Sparc Center 2000 servers.
• Led 4 Oracle Jr. DBAs and 2 Jr. Unix System administrators

CONFIDENTIAL

The lead architect for converting a custom medical billing system from an Alphabase/Metropolis database on an Alphamicro to Oracle 6 database and oracle forms 3.0. The base medical billing was converted to run on Oracle with forms on a 3b2 Unix environment. This also included interfacing with BlueCross BlueShield of Illinois, Indiana and Ohio.