OBJECTIVE:

To obtain a full time Oracle DBA position

SUMMARY:

• Twenty years of combined experience as an Oracle Applications DBA.
• Performed E - Business R11i/R12 installations, upgrades, administration, and performance tuning in diverse architectures.
• Over ten full cycle of medium, large size, brand new implementation, upgrading to R12.2.4/5 with both single or RACed databases.
• Has performed key roles as a technical lead to complex migrations and large budgeted (over 13 T bites in size of the database) 11i/R12 implementations.
• Possesses excellent skills in backup/recovery/clone (RMAN).
• Implement DR strategy by utilizing dataguard both single node to RAC or RAC to RAC
• Performance tuning of Oracle RDBMS, (VLDB, over thirty TB)
• Has also had export level experience in converting E-Business R11i from non-Unix to Linux for both database tier and apps tier.
• Additionally, has hands-on experience in various vendor clusterware / storage implementations such as HACPM and VCS.
• 10, 11, 12c GI installation and upgrade, ASM, OCFS
• Certified ORACLE DBA with version 7,10g.

EXPERIENCE:

Independent Consultant

Confidential

Responsibilities:

• Upgrade to R12.1.3 from 11.5.10 CU2 on Linux, R12.2.2/3/4/5 on Sun Solaris
• Installation, cloning, patching of Oracle Applications Release 12 .1.3/R12.2.2/3/4/5
• Configure R12 for Load Balancer.
• Install, upgrade 11g OID and 10g SSO, Webgate, Accessgate, WebLogic
• Integration R12 with Oracle SSO, OID.
• Install, upgrade, troubleshooting Oracle AS 9,10g, 11g. 12c, SOA, BPEL.
• Install, upgrade, troubleshoot Oracle Database 9i, 10g, both GI and database for 11g 12c
• Configure SSL, using Oracle Wallet Manager.
• Configure setup TDE /ASO etc.
• Implemented Rman for UAT and Production databases.
• Trouble shooting missing jsp pages and blank pages in hardware Load Balancer environment.
• Figure out workaround for PCP to the problem caused by two names for the same node ( physical and alias).
• Implemented R12 in a CISCO LB environment.
• Troubleshooting and figure out workaround for adautofig.sh error.
• Module included: HR, Ben and typical Oracle Financial modules.
• Install, Configure OEM for monitoring scheduling jobs in Production Databases.
• Wrote shell script for RMAN back up Prod database.
• Upgrade to 11gR2 from 10gR2 in both Linux and Windows
• Install, upgrade, reinstall, configure APEX version 3, 4.

Confidential, Reston, VA

Senior Principal Consultant

Responsibilities:

• Installed, configured, implemented 9iRAC, 10gRAC, on Linux, Solaris 10, AIX and HPUX.
• Converted Non-RAC to RAC for 9i, 10g.
• Installed, configured, designed, implemented ASM with Sun’s clusterware, Varitas, MPXIO multipathing.
• AIX EMC Powerpath SAN Storage, and Redhat Linux with NetApp/NAS storage.
• Hands-on experience in implementing Oracle Applications projects with SSO/OID in Confidential .
• Hands-on experience in implementing Oracle Applications on Real Applications Cluster (RAC).
• Experience in implementing Oracle Applications Release 11i with 10g Application Server (10gAS), performance tuning of Oracle Applications database, both on single and RAC database.
• Administering and tuning of Oracle 10gAS, 10g database and RAC.
• Install, configure, patching, cloning Oracle Applications Release 11.5.10.
• Install, configure, patching, cloning, upgrading Oracle Applications R12.2.2/3/4/5
• Developing, testing, administering, and tuning of large batch processes on an Oracle Applications database (RAC, ASM), developing, testing, administeringand tuning of Forms and html based Applications extension programs.
• Successfully created Oracle 10g Logical Stand By Database from primary to secondary by Oracle Streams technology.
• Experience in working with NetApp/NAS storage technology.
• Documentation skill to write technical deliverables, installation and configuration steps.
• Worked with SAP basis administrator to identify/verify functionality, set up, performance tuning for 10g RAC in Linux.
• Performance tuning on forms tier, concurrent manager tier, and database tier from R11 to R12.
• Install and configure OEM to provide alert and notification for DBA and sysadmins.
• Performed trouble shooting Oracle Workflow and XML gateway issues
• Oracle Apps modules expertise from traditional Fianancils to HR, PO, Manufacturing.
• Converted multi APPL TOP to shared APPL TOP.
• Defined WORKSHIFT to allow/disallow certain activities on various concurrent managers n different time periods.
• Implemented and configured PCP.
• Cloned multi-node system to single-node system (Rapid Clone) and vice versa.
• Physical Dataguard/Replication on both RAC and non-RAC.

Confidential, Dallas,TX

Oracle DBA

Responsibilities:

• Led and successfully upgraded Oracle Applications 11.5.2 to 11.5.8
• Patched 11.5.8 installation, including AR, AP, GL, FA, PA modules on a daily basis
• Successfully upgraded from 11.0.3 to 11.5.3.
• Applied database and applications patches.
• Migrated 11.5.8 from Unix environment to 11.5.8 Linux.
• Performed troubleshooting with concurrent managers, Apache, and Jserv processes.
• Cloned multi-node system to single-node system (Rapid Clone) and vice versa.
• Performed many cloned 11i environments using Autoconfig and RMAN with TSM.
• Performed and conducted test on Load Balance on application tier.
• Converted multi APPL TOP to shared APPL TOP.
• Created custom queues in PCP and load balanced the jobs to run on specific node.
• Defined WORKSHIFT to allow/disallow certain activities on various concurrent managers on different time periods.
• Implemented and configured PCP and DCP.
• Directing Apps developer to using XMLGEN Oracle Package utilities, PL/SQL to process XML formatted files to AR.
• Setup DataGaurd for RAC production database.
• Intigrate discover with Oracle ERP.
• Installed and upgrade Quantum Tax program and data
• Cloned multi-node system to single-node system (Rapid Clone) and vice versa.

Confidential

Oracle DBA

Responsibilities:

• Hardware capacity planning, software installation and upgrading.
• The system is configured as a 3-tie environment.
• Database server and Concurrent Manager on a Sun E5000 box, Form Server on Sun E450 machine, and web/application server Sun Ultra-80.
• Configure and setting up Self Service V5.7.
• Configure and setting up Oracle Notification.
• Configure and setting up Oracle workflow 2.5, 2.6.
• Applying patches as needed by using adpatch.
• Using adctrl and corresponding adwork99.log files to monitor and trouble shoot patch applying problems. Used many times of option 8 of adctrl
• Apps modules including: GL, AP, AR, FA, CE, PA
• On July of 2003, upgrade from 11.5.6 to 11.5.8(database from 8.1.7 to 9.0.1.4) within 32 hours.
• Cloned Test and Training system from Prod for in a three tie environment: database server, forms server, web server, even Oracle’s Autoconfig is not available at that time.
• Periodically refresh TEST and TRAIN system from PROD.
• Developed and documented TEST and Train refresh processes.
• Modified highly paid consultant’s PL/SQL converting procedures to speed up processing typically from a couple of hours to server minutes.
• Trouble shooting routine problems at expert level.
• Shell scripts coded database Hot Backup process.
• Mentoring and knowledge transfer to junior 11i DBA.
• Directing Apps developer to using XMLGEN ORACLE Package utilities, PL/SQL to process XML formatted to AR
• Maintain and Configure ORACLE 8i/9i Application Server configuration files for company customized applications.

Oracle Database Architect / DBA

Confidential

Responsibilities:

• Reengineered Ariba’s search engine by not touching their application code.
• Dramatically improved the search responding time.
• For a typical search case, improved responding time from a very slow five minutes to under 1
• (one) second.
• Tuned hundreds of the ETL sql scripts.
• Developed and experimented a fastest way to load data into data warehouse by using external table and insert into table as select * from external table by using hint /*+ append
• Create and maintain materialized view.