SUMMARY:

• Oracle 11i/R12 Senior APPS Database Administrator (EBS Enterprise Business Suite), with extensive data processing background (21 years data processing total, fives years Peoplesoft/Oracle Apps DBA, and seventeen years Oracle Apps 11i/R12 DBA).
• I also worked as a VMWARE VSphere version 6, internal cloud DBA.
• I have exposure to the design and management of large scale databases in a Oracle environment.
• Worked as a Systems Security Administrator to register new users, add roles and privileges, register new programs, and monitor service requests.
• Experience with performance tuning for Oracle Applications (application and database).
• (11G/12c Tuning techniques utilizing AWR and ASH Reports.
• Ability to troubleshoot technical issues in a web server (Apache and Websphere) environment including working knowledge of Unix and exposure to networks. (Proficient in unix administration and shell scripting (Exadata/RAC) ).
• Exposure to large scale database reporting tools with general accounting, Financials (GL, AP, AR, etc), Oracle Project, HR Payroll/Benefit Admin, and Manufacturing knowledge.
• Also involved with implementing ASCP (Advanced Supply Chain Planning). (Exposure to CRM, I - Support, OBIEE, (SOA - Fusion Middleware) RAC and ASM).
• Maintained 11g OAM and OIM. Demantra Forecasting.
• Excellent interpersonal skills in addition to strong Team Spirit. I have the skills and knowledge to upgrade the Oracle Applications suite from 11i to R12. Most current upgrade was r12 (12.1.3) to r12 (12.2.6). I have participated in six Oracle Application upgrades in the past and dozens of database upgrades.

TECHNICAL SKILLS:

Databases: Oracle 12c, 11gR2 RAC/10gR2/9i/8i/8.x/7.x, 10g/9i RAC, MySQL 5.1

Oracle Applications: R12 (12.2.6, 12.1.3), 11i (11.5.10.2) 11.0.3, Financials, Manufacturing, HR Payroll, Benefit Admin, ASCP (Advanced Supply Chain Planning), CRM, I-Support, Peoplesoft 5.1, 7.0 HR/Payroll, Financials, 12c Grid OEM. OBIEE 11.1.1.7.1, SOA 11gR 2 11.1.1.6.3, BPEL 11gR 2 11.1.1.6.3 .,ESSBASE 11.1.2 Hyperion, Quest Software Stat version 5.6.4, OAM and OIM 11.1.2. cpadmin

Operating Systems: Linux RH 9.x, RHEL AS 3.0/4.0/5.0, Ubuntu, Oracle Enterprise Linux Server 5.x/6.x, Sun Solaris, HP 11, AIX, Windows Server 2000/2003/2005

File systems: Oracle Cluster File System (OCFS) 1/2, Oracle Automatic Storage Management (ASM), Network File Systems (NFS). Exadata Storage Server Version 12.1.1.1.0 Hadoop, Big Data, Cloud technology Vmware VSphere version 6 IBM Websphere 5.02, Siebel CRM 7.8, Oracle 11g OBIEE, 11g SOA - Fusion Middleware, Demantra 7.3.4, Mongodb 2.4, Hadoop, on the cloud for Tamatura

ETL/Replication Tools: Materialized Views, Kintana Cloning tool. Some experience in Golden Gate 11.2.0.1 Oracle Workflow, Web ADI, and Discoverer., Concurrent Managers, IBM Websphere, Apache Servers 9iAS, 10gAS

Tools: AWR (Automatic Workload Repository), ADDM (Automatic Database Diagnostic Monitor) ASH (Active Session History) STS (SQL Tuning Set), STB (SQL Tuning Base), Quest Toad 8.x/9.x, Oracle SQL Developer, Net8, Oracle Enterprise Manager (OEM), RMAN, 10g Grid, 12c Grid, SQL*Net, SQL*Loader, SQL*Plus, Quest Schema Manager, Oracle Connection Manager, Oracle Statspack, MS Office, Visio, vi, imp, exp, impdp, expdp

Version Control Tools: CVS, PVCS. Jira 2.5 Scheduling Software, Visual Studio 2012, BMC Remedy Action Request System version Version 7.0. 01 Patch 00 7

Languages: SQL, PL/SQL, Unix shells (sh, ksh, bash), DOS shell

PROFESSIONAL EXPERIENCE:

Confidential, Oklahoma City, OK

Sr. Oracle Apps R 12 12 .2.6 DBA

Responsibilities:

• I participated in large scale project (10 Oracle DBA’s, 10 functional personnel) to upgrade Oracle Apps 12.1.3 to 12.2.6 (27 terabytes, hundreds of large partitioned tables) Exadata/Rac environment with links to 20 other government agencies.
• My role was mainly focused on patching (adop utility), quarterly security patches, Opatch, code migrations, weblogic administration, performance tuning (mainly Quest Toad product, some 13c OEM), and trouble shooting.
• I was also responsible for maintaining, loading, and performance tuning two large datawarehouses (about 15 terabytes each with tables in excess of 2.8 billion rows. Most databases 12c (12.1.0.2) not-plugin.

Confidential, Idaho Fall, ID

Sr. Oracle Apps/VMWARE Cloud DBA

Responsibilities:

• This client is a large Nuclear facility (Dept of Energy) with very sensitive data. I was involved in large scale project to migrate roughly 150 fixed database servers (Oracle) to Vmware VSphere 6.0 internal cloud servers. (Virtualized their infrastructiure).
• Initially I had to map out all their fixed servers, to identify most critical data, security concerns, and strive to minimize duplication of data. Also upgraded all databases (10g and 11g) to 12c not-plugin. Most of the migrations were performed via datapump, bringing over just the most critical schemas with a good deal of merging between databases of separate import dump files. My team needed to verify all db links, grants, synonyms, and interfaces were valid as a condition of success. I also spent a great deal of time upgrading many systems from SHA-1 to SHA-2 encryption certification for increased security. This client also has a R 12 12 .2.5 Oracle Applications Financials system, that I assisted in patching, troubleshooting and performance tune.

Confidential, Boston, MA

Sr. Oracle Apps DBA

Responsibilities:

• Client (Harvard Pilgrim Hospital) Worked as a member of a worldwide team (Dell US and India based) responsible for the upgrade of Oracle Applications from 11i (11.5.10.2) to r12 (12.2.4) (patching,cloning) and the maintenance of a 300 plus servers. Consisting of R12 Oracle Financials, 12c Grid OEM. 11g RAC, exadata, SOA 11gR 2 11.1.1.6.3, with first North American implementation of OHI (Oracle Hospital Insurance module) on 12c Fusion Middleware Weblogic platform . Responsible for upgrading numerous Apex (Application Express) environments from 4.0 to 4.2. Responsible for new clones of Weblogic Fusion Middleware OHI, bring up managed servers and deploying war, ear, and jar files. Utilized Remedy software for managing work queues, dealing with hundreds of trouble tickets tied to administrative tasks, security, code migrations, performance tuning, imports, exports, patching and all around trouble shooting and maintenance. Initiated service requests, documented all new processes, and enhanced existing documentation.
• Performance tuning tools included OEM, AWR, and ASH reports, command line SQL Tuning Advisor recommendations, utilizing various scripts to capture new and existing SQL IDs, hash plans, explain plans, and fixing baseline table settings. Scheduled dozens of dba jobs for computing stats on custom schemas and other maintenance related issues.

Confidential, Seattle, WA

Sr. Oracle Apps DBA

Responsibilities:

• Worked as a member of a team responsible for the maintenance of a 30 plus servers of R12 (12.1.3) Oracle Financials, 12c Grid OEM. OBIEE 11.1.1.7.1, SOA 11gR 2 11.1.1.6.3, BPEL 11gR 2 11.1.1.6.3 .,ESSBASE 11.1.2 Hyperion, Quest Software Stat version 5.6.4.
• Involved in security, performance tuning, code migration, cloning (with snap technology) and all around troubleshooting.
• Heavy Workflow and obsolete data purging, with a good deal of workflow troubleshooting. Created new RMAN scheduled backups and new notification jobs in 12c GRID. Upgraded various Oracle databases from 11g to 12c (11.2.0.2 to 12.1.0.3).

Confidential, Bellevue, WA

Sr. Oracle Apps DBA

Responsibilities:

• Worked as a member of a team responsible for the maintenance of a 30 servers of R12 (12.1.3) Oracle Financials, Demantra (7.3.4) Forecasting systems. Involved in security, performance tuning, code migration, cloning and all around troubleshooting.
• Walgreens bought out Drugstores.com, moving their Data Center from Bellevue, WA to Lincolnshire Illinois. Demantra runs on a Windows platform, involving a great deal of data transfer between EBS and Demantra.
• Worked with Offshore Team to bring about resolution.

Confidential, San Jose, CA

Sr. Oracle Apps DBA

Responsibilities:

• Worked as a member of a team responsible for the maintenance of a hundreds of 11i/R12 (12.1.3) Oracle Financials, HR Payroll and Manufacturing systems. Single Sign on LDAP environment. OAM and OIM version 11.1.2.
• Maintained OAM and OIM but did not install this software. Involved in security, upgrades and all around troubleshooting.
• Includes maintenance of SOA/BPEL, weblogic servers. Helped maintain Golden Gate replications, but did not set up Golden Gate. Worked with Offshore Team to bring about resolution.

Confidential, Raleigh, NC

Sr. Oracle Apps DBA

Responsibilities:

• Worked as a member of a team responsible for upgrade and maintenance of a worldwide implementation of R12 (12.1.3) Oracle Financials, HR Payroll and Manufacturing (ASCP), supporting 12 different languages in 120 countries.
• Single Sign on LDAP environment. OAM and OIM version 11.1.2.
• Maintained OAM and OIM but did not install this software. Involved in patching, cloning, and all around troubleshooting. Worked with Offshore Team to bring about resolution. Complex environment involving 11g(11.2.0.3), 12 TEST and DEV environments., on a Redhat linux platform. Performance Tuning, utilizing 11g Grid, AWR and ASH reports. Used Remedy software for securing service requests.
• Heavy involvement in cleaning up obsolete work flow records. Responsible for setting up menus, forms and functions as a SYSADMIN in this environment.
• Heavy HR Payroll patching, with hrglobal.drv where different language patches had to be run via a Legislative RunInstall utility (Redhat supports 12 different languages in 120 countries in their patching activity). Cleaned up various issues with Oracle Time and Labor workflow corruption.
• Lots of exposure to vertex HR payroll patching in the past. Set up the patch wizard and trained users on proper functionality of this tool.

Confidential, San Diego, CA

Sr. Oracle Apps DBA

Responsibilities:

• Worked as a member of a team responsible for upgrade and maintenance of a worldwide implementation of R12 (12.1.3) Oracle Financials and Manufacturing (ASCP). Single Sign on LDAP environment.
• OAM and OIM version 11.1.2. Maintained OAM and OIM but did not install this software. Involved in patching, cloning (Kintana), and all around troubleshooting.
• Worked with Offshore Team to bring about resolution.
• Complex environment involving 11gRAC2, 12 TEST and DEV environments. 12 SOA TEST and DEV environments (11g (10.3.3)), on a Redhat linux platform. Occasional Performance Tuning, utilizing Quest Toad product.
• Multiple Standby environments. Strong exposure to web logic with SOA technology, and some involvement with OBIEE (Business Intelligence) on DEV, TST .
• Responsible for setting up menus, forms and functions as a SYSADMIN in this environment. Performed the upgrade of Oracle Applications from 11i to R12, secured all the software, documented all procedures, utilizing TUMS, and helped augment all new customization's.

Confidential, Redwood City, CA

Sr. Oracle Apps DBA/Linux Admin

Responsibilities:

• Worked as a member of a team responsible for design, development and support of the Cloud Computing environment on Amazons Cloud. Worked to set up new instances and configure front end Single Signon environment, to tie together multiple competing vendor cloud companies..
• Part time job to learn this new technology.
• Responsible for all linux administartion. Learning to install and maintain mySQL 5.1 and Oracle 11g on the cloud.

Confidential, Tinley Park, IL

Sr. Oracle Apps DBA

Responsibilities:

• Responsible for Performance Tuning and cleaning up various production and Test databases.
• Cleaned up and streamlined MSDCLV Data Collection Process. Cleaned up all their workflow tables, millions of errored records hidden from sight. Performed the upgrade of Oracle Applications from 11i to R12, secured all the software, documented all procedures, utilizing TUMS, and helped augment all new customization's.
• Focus on troubleshooting ORA-00600 core dump errors, and ORA-00060 DEADLOCK memory issues. Mainly tied to custom code
• Extensively used Oracle Enterprise Manager (OEM) to perform various database maintenance and routines.
• Exposure to Oracle Streams and Golden Gate replication
• Patched and upgraded number of databases from Oracle 9i to 11gR2.
• Worked with development teams to create new DB objects such as procedures, triggers, packages, etc. using PL/SQL, SQL*Plus, Quest Toad and Oracle Enterprise Manager Tuning Tools (AWR, ASH, etc)
• Cloned and refreshed databases and schemas for different business and testing purposes.
• Provided 24x7 database support.

Confidential, Baton Rouge, LA

Sr. Oracle Apps DBA

Responsibilities:

• Analyzed layout of databases/schemas
• Responsible for verifying and documenting all Oracle Data Warehouse processes tied to the Hurricane Katrina (Road Home) reimbursement program for the out of the Data Warehouse (Ten terabytes of data) involving over 24 interfaces through a dozen agencies, title and insurance companies.
• Wrote RFP’s (Request for Proposal documents), and cleaned up their Backup and Recovery Guides, Performance Tuning Guides and all other documents tied to the project.
• Provided technical 24x7 database support.

Confidential, Frisco, TX

Sr Oracle Apps DBA

Responsibilities:

• Collected, analyzed and documented requirements and functionality based on current application.
• Responsible for upgrades, cloning, tuning, security patches and all around maintenance of six separate instances of various modules (Financials (GL, AP, AR, FA, CRM, Mobile Supply, Depot, Spares Management, BOM, WIP, MRP, Inventory)). New implementation from Baan Applications to Oracle Apps R12 (12.1.2).
• Installed, patched and cloned databases. Performed regular database maintenance and support using Oracle Enterprise Manager (OEM).
• Created and updated tables, packages, stored procedures, functions, triggers using Quest Toad and Oracle Enterprise Manager Tuning Tools (AWR, ASH)
• Assisted in the installation of a 10G RAC/ASM configuration, with all new hardware.
• Involved with all phases of initial development to CRPI, CRPII, UAT and finally Production utilizing a AIM methodology
• Maintained and updated bugs tracking database. Developed procedures and UNIX (sh, ksh, bash) and DOS shell scripts to automate database operations, database monitoring and data integrity between databases.
• There is a team of 30 people with half the development team residing in India, and I will support all their technical concerns internationally and domestically, registering programs, controlling change management, and cloning new environments. Provided 24x7 on-site and on-call database support.

Confidential, Irving, TX

Sr Oracle Apps DBA

Responsibilities:

• Responsible for upgrades, cloning, tuning, and all around maintenance of fifteen separate instances (Financials (GL, AP, AR)) (two production, thirteen TEST), on two-tier servers (DB server and APPS server separated) 11.5.10.r2 implementation.
• Additional responsibilities in maintaining six other instances (Mainly 10G) with a second DBA . This is a 24/7 shop with additional servers located in Moscow, Beijing, and Zurich
• All of the systems utilize, hot backups with archives for the production instances. and Standby Configuration for both production instances.
• Responsible for all linux administration, workflow administration, and Discoverer administration.
• I am responsible for training users on all Oracle APPS pieces, and for documenting processes, and resolving SR (system requests) issues.
• Tuned production database objects and queries using different methods using Explain Plan.
• Moved corporate Data Center, rebuilt unix test server, broke mirrors, and reinstalled operating system, and test databases due to failed hardware.
• Company is migrating to SAP and needed to maintain this environment while transitioning over.
• Maintained TEST 11g database, and perfected their switch over switch back disaster recovery environment. Client did not use Data Guard in this environment.

Confidential, Austin, TX

Sr Oracle Apps DBA

Responsibilities:

• Responsible for upgrades, cloning, tuning, and all around maintenance of three separate instances (Financials (GL, AP)), on two-tier servers (DB server and APPS server separated) 11.5.10.r2 implementation. Additional responsibilities in maintaining thirty plus instances (Mainly 10G) in a rotational environment.
• All of the systems utilize, RMAN backup and restores, and Data Guard Standby Configuration. One systems is a 10g RAC/ASM configuration. Maintained but did not install this RAC system.
• Client is the Texas Dept of Welfare. Server’s are being modernized for a statewide roll out of new kiosk’s and automation project.
• I am responsible for all training for all Oracle APPS pieces, and for documenting processes, and resolving SR (system requests) issues. Worked with nationwide team to maintain 24/7 uptime optimal performance. Responsible for all linux administration, workflow administration, and Discoverer administration.
• I am responsible for training users on all Oracle APPS pieces, and for documenting processes, and resolving SR (system requests) issues.
• Tuned production database objects and queries using different methods using Explain Plan and SQL STATSPACK

Confidential, Herndon, VA

Sr Oracle Apps DBA

Responsibilities:

• Responsible for upgrades, tuning, and all around maintenance of three separate instances, on two-tier servers (DB server and APPS server separated). In a clustered for Sun Solaris (9i database) environment.
• Client is Small Business Administration and FEMA. Reimbursements Small businesses tied to Hurricane Katrina. Server is going through massive upgrade and migration.
• I am mainly involved, in managing workloads between the various enterprises, documenting processes, and resolving SR (system requests) via Seibel tracking system.
• Maintained Websphere 5.02, migrated terabytes of LOB data.
• I am responsible for all training for all Oracle APPS pieces, and for documenting processes, and resolving SR (system requests) issues. Worked with nationwide team to maintain 24/7 uptime optimal performance.
• Tuned production database objects and queries using different methods using Explain Plan and STATSPACK

Confidential

Sr Oracle Apps DBA

Responsibilities:

• Responsible for patching, tuning, and all around maintenance of five separate instances, on two-tier servers (DB server and APPS server separated). In a clustered TRU64 (9i database) environment.
• Worked with team in worldwide operations, (Sydney, London, San Diego)To maintain 24/7 uptime optimal performance.
• Tuned production database objects and queries using different methods using Explain Plan and STATSPACK

Confidential, Reston, VA

Sr Oracle Apps DBA

Responsibilities:

• Responsible for all upgrades, new installs, and patching for five separate instances DEV1, TEST, SYSTEST, TRN and DEV2, on two-tier servers (DB server and APPS server separated) (CRM, I-Support)
• Also responsible for all Cloning, Backup & Recovery, Security, Data Loading and Performance Tuning of these databases
• Tuned production database objects and queries using different methods using Explain Plan and STATSPACK
• Responsible for various other custom 9iAS and a 9i database applications, tied to compiling data on Airport Security. Exporting and importing LDAP information and the application of EAR files.
• Installed one instance of 10G, dealing with a HTMLDB
• Performed Rapid Upgrade from 11.5.8 to 11.5.10.2 in two day time frame on a Development Server with a copy of production.

Confidential

Sr Oracle Apps DBA

Responsibilities:

• Permanent employee Salt Lake City, UT Oracle Application 11.5.8 DBA (Financials and Manufacturing (GL, AP, AR, INV, OPM, ASCP))), also responsible for some Unix administration, Oracle APPS System Administration, and some functional programming.
• Responsible for all Cloning, Backup & Recovery, Security, Data Loading and Performance Tuning of these databases
• Tuned production database objects and queries using different methods using Explain Plan and STATSPACK
• Responsible for all upgrades, new installs, and patching for three separate instances PROD, TEST, and DEV, on individual servers (database server and APPS server combined).
• Share system admin duties on twenty different servers, comprising, Sun OS, HP, Linux, and Windows NT server 2000.
• Responsible for the Datawarehouse, Order Entry and all portal databases.
• Heavy involvement in upgrading ERP system from Discrete Manufacturing to OPM, (Oracle Process Manufacturing)
• Involved with implementing ASCP (Advanced Supply Chain Planning)
• Responsible for upgrading systems in five countries around the world each weekend with Materialized views, and maintaining Blue Pumpkin Customer service software.

Confidential, Tulsa, OK

Sr Oracle Apps DBA

Responsibilities:

• Oracle Application 11.0.3/11i (11.5.7) DBA (HR/Payroll/Benefit Admin & Financials (GL,AP,AR)), also responsible for all Unix administration, Oracle APPS System Administration, and functional programming.
• Responsible for all Cloning, Backup & Recovery, Security, Data Loading and Performance Tuning of these databases
• Tuned production database objects and queries using different methods using Explain Plan and STATSPACK
• Responsible for all upgrades, new installs, and patching for three separate instances PROD, TEST, and DEV, on individual servers (database server and APPS server combined).
• Responsible for all OS patches, hardware upgrades, for both Unix boxes running Sun OS version 2.6.
• Upgraded instance from 11.0.3 (database 8.0.5) to 11.5.7 Split partition (database 8.1.7.4).

Confidential

Mainframe Cobol/ AS400 Developer

Responsibilities:

• Diamond Consulting Chicago, Illinois
• First Security Bank of Utah Salt Lake City, Utah
• Peat Marwick Advanced Technology Chicago, Illinois
• Senior Programmer Analyst AS/400 RPG Mainframe MVS/DB2 COBOL,Assembler, CICS
• Worked for the above three companies doing AS/400 RPG and mainframe COBOL/CICS for five plus years.