SUMMARY:

16 years of Oracle database administration and Oracle Application administration experience. Proficient in the area of Relation Database Management Systems and ERP systems. CRM system(Siebel,Clarify). Experiences with Oracle Application 11i upgrade. Oracle Application R12 upgrade, Database 12c upgrade. SOX 404 audit experience,Oracle GRC. Oracle OBIEE application, Oracle Hyperion application, Oracle Enterprise Manager 12c, Confidential SharePlex, Automic

TECHNICAL SKILL:

RDBMS: ORACLE 8.x/9.x/10.x/11.x/12.x SQL server 2010, SQL server 2008, MySQL 5.6

Applications: Oracle EBS 12.1.3/12.1.1 / 11.5.10 /11.5.9 /11.0.3 , Siebel Application, MS sharepointApplication, Clarify Application OBIEE Application Oracle GRC Application

Webserver: Oracle 10g Application Server, Apache Web server Oracle Fusion Middleware

Database Tools: Confidential TOAD, SQL Navigator, SPACE MANAGER, LIVE REORG

Monitor Tools: Confidential FOGLIGHT,SPOTLIGHT for ORACLE, SPOTLIGHT for ORACLE APPS

Replication Tools: Confidential SHAREPLEX

Migration Tools: Confidential Stat

Schedule Tools: Automic

Apps Audit Tools: Logical Apps

Languages: PLSQL,PERL,KSH

ORACLE/Oracle: Installation of Oracle Applications(11.0.x,11.5.x, 12.x)

Application: Installation of Oracle RDBMS (8.0.x,8.1.x,9.2.x, 11g,12.c)

SKILL SUMMARY:

• Installation of Oracle Application Server (9i,10g)
• Installation of Oracle Discoverer 10g
• Database upgrade (8.0.5 to 8.1.7, 8.1.7 to 9.2.0.3,9.2.0.3 to 11g, 11g to 12c)
• Oracle Application Shared Appltop technology
• Oracle Application Upgrade (11.0.3 to 11.5.8)
• Oracle Application Upgrade (11.5.9 to 11.5.10.2)
• Oracle Application Upgrade (11.5.8 to 12.0.4)
• Oracle Application Upgrade (12.1.1 to 12.1.3)
• Implementation of Oracle APS system (Demand planning, Advance Supply Chain)
• Implementation of Oracle Application Reporting server with Confidential SharePlex.
• Implementation of Appworx with Oracle Application,Siebel Application,Clarify Application.
• Implementation of Siebel /Clarify/Appworx Application high availability with SharePlex.
• Database Tuning, database backup.

EXPERIENCE:

Confidential

Senior Oracle DBA, Lead Oracle Application DBA

Responsibilities:

• Install and configure Oracle Enterprise Manager 12c to monitor EBS system
• Use Oracle Enterprise Manager 12c to monitor Oracle database
• Upgrade Oracle Application from 12.1.1 to 12.1.3 and database upgrade from 11gR1 to 11gR2.
• Re - implementation of Oracle Application 12.1.1
• Upgrade Oracle Application from 11.5.8 to 12.0.4 and database upgrade from 9208 to 10.2.0.3, convert tablespace to OATM
• Clone Oracle Application R12 environment
• Using Shared ApplTop for R12 environment
• Migration Oracle Application from HP platform to AIX platform
• Upgrade the Oracle application server software to the latest SOA suite

Confidential

Senior Oracle DBA, Senior Oracle Application DBA

Responsibilities:

• Setup Oracle Application 11.5.10.2 as the APS destination instance
• Using Shared Appltop Technology, 4 linux as the application server, 1 database server
• APS database sizing capacity planning
• Using discoverer 10g to view the Planning Comparison report
• Upgrade the database to 9207 and apply the latest security patch
• Upgrade Jinitiator to the latest version
• Setup 10g Application server for discoverer application (discoverer plus,viewer)
• Setup 10g Application server using Internet directory
• Upgrade the tablespace to use OATM
• Upgrade developer 6i to the 6.0.8.27.0 Patch 18
• Upgrade database to 9207
• Upgrade Oracle Application to 11.5.10 CU2 patch
• Using rapid clone to clone application to different environment.
• Manage about 20 SQL server databases
• Design SQL database structure for sharepoint application
• Daily maintenance and apply latest service pack.

Confidential

Senior Oracle DBA, Senior Oracle Application DBA

Responsibilities:

• Use Logical Apps application to audit on form/table level
• Audit Oracle Developer activity on the production database
• Audit Oracle Apps user using different PC to login with the same login name
• Upgrade database from 8.1.7 to 9.2.0.6
• Database character change from WEBISO885P1 to UNICODE
• Setup Siebel Dataware housing database
• Setup Standby instance using Confidential SharePlex
• Upgrade Project Planning which include new hardware requirement. ntial online replication tools - SharePlex.
• Setup Oracle Appsal replication tools - SharePlex.
• Develop backup scripts to backup Oracle Apps 11.5.8 environment.
• Create Oracle Alert to monitor the number of pending jobs
• Setup Workflow Mailer
• Oracle Apps 11.0.3 installation.
• Oracle Apps 11.0.3 instance cloning.
• Upgrade Apps database from 8.0.5 to 8.0.6.
• Upgrade Apps Webserver from 3.0.2 to 4.0.8.
• Upgrade Developer 2000
• Setup Oracle Apps high available environment using Confidential online replication tools - SharePlex.
• Monitor Oracle Apps environment.
• Setup Discoverer User account.
• Create Siebel Development database 8.1.7 on Window 2000
• Migrate Siebel Development database to Aix Unix server
• Work with Siebel Consultant to design the Siebel Application Architecture.
• Refresh database from Production environment to Test environment.
• Using Appworx to schedule the interface jobs between Siebel and Oracle Apps.
• Apply the latest database patch set.
• Use Confidential SharePlex to setup the high availability environment for Siebel