SUMMARY

• Objective To apply for a position of Senior Oracle EBS Apps DBA in your company.
• Database Oracle EBS Application R12.2.4/12.1.3, Weblogic Server Admin.
• Skills OBIEE/DAC/Informatica/RCU, Oracle Identity Manager, OAM/OID/SSO with EBS.
• Oracle Database 11.2.0.4/12.1.0.2, MS SQL Server 2014, Vertex O Series Admin
• Oracle VM Server 3.2.4/3.3.1, Oracle VM Manager, Oracle VM Templates
• ASM, RAC, Grid Control, RAC, ASM, Grid upgrade to 11gR2 in HP - UX and Linux.
• Golden Gate 12c, Physical Standby Database, Logical Standby DatabaseDataguard, OEM, SQL Loader, Import / Export, datapump
• Advanced EncryptionBackup and Recovery, Performance Tuning, Physical Storage ManagementQuest Foglight, Quest Central, Shareplex Replication.
• OS Enterprise Linux, UNIX Solaris ( System Administration, Backup, NFS )
• Skills HPUX 11i, HP N Class Servers, NetBackup, SureStore Tape LibraryExperiences
• Oracle EBS Apps DBA Consultant in Oracle Corp Consulting Services ( Feb 2013 -- Current )
• As an Oracle supplied contractor, I am currently working for multiple Fortune 500 clients in Northwestregion, and I am the main driver for several critical projects:
• Upgraded Oracle EBS 12.2.4 Grid and Database from 11.2.0.4 to 12c ( 12.1.0.2 )
• Upgrade Oracle EBS Suite from R12.1.3 to R12.2.4 on a PROD RAC environment.
• Use the latest startCD 50 to build R12.2 stage area Upgrade R12.1.3 E-Busines Suite to R12.2
• Work with Development team to adjust customized in-house codes to align with online patching EBR rules, ( customized materialized views rewriting )
• Enable online patching in R12.2, and use adop to reduce maintenance downtime.
• Upgrade R12.2 E-Business Suite to R12.2.4, perform all necessary post upgrade steps.
• Upgraded Oracle eBusiness RAC database from 11.2.0.3 to 11.2.0.4
• Migrated Oracle E-Business R12.1.3 from HP-UX to Redhat Linux 6 servers.
• Upgraded Oracle eBusiness Application from 12.1.2 to 12.1.3 and sorted out various issues in the upgrade, applied latest RPC patches to make 12.1.3 most current.
• Work with offshore team for various initiatives of development and production support
• Work with Deloitte Audit Team for Annual SOX Audit of PROD EBS system.
• Work with vendor on various packaged application, including Vertex, Oracle EBS.
• Support multiple environments of OBIEE/DAC/Informatica/RCU on Linux servers
• Upgraded 11.1.0.7 RAC Oracle database to 11.2.0.3 for EBS Oracle Apps 12.1.2 system.
• Doing Vertex implementation with EBS R12.1.2, installed Weblogic servers and vertex application servers, configured vertex taxlink in R12.
• Adding 3rd node into existing RAC EBS R12 configuration
• Implementing deduplicate feature of FND LOBS in R12 PROD database by using Oracle Advance Compression, saved 50% SAN disk space.

PROFESSIONAL EXPERIENCE

Oracle Apps DBA Contractor

Confidential

Responsibilities:

• Successfully tuned Crane’s EBS PROD system, results are striking: no more complaints from end users, all concurrent requests are completed in a timely manner.
• Provide DBA support for Crane’s Taiwan Implementation, including migrating customized codes, rapid clone new environments for UAT testing.

Confidential

Oracle Apps DBA

Responsibilities:

• Support a multiple TB sized Oracle EBS RAC PROD environment.
• Migrated R12.1.2 from HP-UX to HP Itanium, then migrated to 11.0.7 RAC environment
• Worked as a DBA to upgrade EBS 11.5.10.2 to R12.1.2 on HP RISC platform
• Successfully troubleshoot performance issues of Oracle Apps R12.1.2, and this is my third case of successful performance tuning of Oracle E Business Applications.
• Work with offshore DBA team to achieve important milestones.
• Convert a 4 nodes configuration of EBS R12.1.2 to 11gR1 RAC environment
• Use Rapid Clone to refresh test / dev from production in R12.1.2, troubleshooting various situations of missing library, completing cloning with post clone steps.
• Design and implement a rman backup strategy for this client.
• Follow and work with SOX processes defined by this client.
• Work with metalink for various troubleshooting service requests.
• Design and implement a logical dataguard to replace old clone-based data warehouse
• Performance Tuning in our production R12 EBS application after upgrade.
• Plan an Oracle 11.1.0.7 RAC ASM environment for this R12.1.2 EBS Apps on HP-UX.

Confidential

Senior Oracle

Responsibilities:

• Installed Oracle Apps R12 12.1.1 on a 2 nodes Enterprise Linux environment.
• Upgraded Oracle EBS 11.5.9 to 11.5.10.2, supported the efforts to UAT customization
• Use Rapid Clone to refresh test / dev from production in 11i and R12
• Perform SYSADMIN responsibility to customize responsibilities, menus, functions to tighten security for daily users.
• Work with metalink for various troubleshooting service requests.
• Research ( patch README.txt ), test, apply patches by using adpatch in 11i and R12.
• Performance Turning in our production R12 EBS application after upgrade.
• Building an Oracle 11.1.0.6 RAC ASM environment on Enterprise Linux platform.
• Setup an Oracle 11g Dataguard environment on Enterprise Linux platform.
• Setup rman backup script jobs for 11g RAC ASM environment.
• Work independently to solve a transient performance problem of real time shop floor database Exacta, which outsourced consultants could not solve for months.
• Successfully completed NEXTGEN performance tuning project and speedup database 500%
• Work with consulting team to upgrade Oracle Clinical to 4.5.1
• Work with many other projects, including NIMS, NextGen, Tibco Applications.
• Design and implement new RMAN backup strategy for Covance Madison Site.

Oracle Database Administrator

Confidential

Responsibilities:

• Upgrade Quest shareplex from 4.X to 5.X version.
• Upgrade several mission critical databases from 8i to 9i.
• Implement new backup standard using rman and catalog
• Research on project path of implement 10G RAC on Linux