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

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

ETL/Replication Tools: Materialized Views, Kintana Cloning tool. Some experience in Golden Gate 11.2.0.1

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 007

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

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Apps R12 12.2.6 DBA

Responsibilities:

• This client is a large Federal Financials shop (Dept of Transporation) with very sensitive data.
• 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

Sr. Oracle Apps DBA

Responsibilities:

• 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

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

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

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

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