Oracle Ebs Apps Dba Consultant Resume
OBJECTIVE:
- To apply for a position of Senior Oracle EBS Apps DBA in your company
TECHNICAL SKILLS:
Technology and Tools: Database Oracle EBS Application R 12.2.4/12.1.3, Weblogic Server Admin. Skills OBIEE/DAC/Informatica/RCU, Oracle Identity Manager, Weblogic Clustering. 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 Database Dataguard, 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 Library
PROFESSIONAL EXPERIENCE:
Oracle EBS Apps DBA Consultant
Confidential
Responsibilities:
- Performance Tuning of Oracle EBS R12.2.4 running on upgraded database 12c, resolved multiple issues of EBS concurrent requests slowdown after 12c db upgrade.
- Upgraded Oracle EBS 12.2.4 grid and database from 11.2.0.4 to 12c ( 12.1.0.2 ), by using ETCC tool to find all required rdbms patches for EBS R12.2.
- Upgrade Oracle EBS Suite from R12.1.3 to R12.2.4 on a PROD RAC environment.
- Upgraded Oracle E-Business 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 E-Business Suite from 12.1.2 to 12.1.3 in 3 nodes RAC 11.2.0.3 environment.
- Work with offshore team for various initiatives of development and production support
- Work with Confidential 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.
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.
Oracle Apps DBA Contractor
Confidential
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.
Senior Oracle DBA
Confidential
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