SUMMARY:

• 20 years of Oracle database administration and Oracle Application administration experience.
• More than 15 years Oracle EBS production support experience, support both Oracle ERP and Financial environment around 1500 users.
• monitoring and troubleshooting Oracle database and Oracle concurrent manager system.
• work with development on implement production code migration and patch promotion.
• Proficient in area of Relation Database Management Systems and ERP systems. CRM system (Siebel, Clarify).
• Experiences with Oracle Application 11i upgrade.
• Oracle Application R12 upgrade, Database 11g upgrade. SOX 404 audit experience, Oracle GRC. Oracle OBIEE application, Oracle Hyperion application, Oracle Enterprise Manager 12c, SQL server 2008 and SQL server 2012

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, 10g to 12c)
• Oracle Application Shared Appleton 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 (12.1.1 to 12.1.3)
• Redhat Linux 7.4, Oracle Linux 7.4
• 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.

TECHNICAL SKILL:

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

Applications: Oracle EBS 12.2.5/12.1.3/12.1.1 / 11. .5.9 /11.0.3 , Siebel ApplicationApplication OBIEE Application Oracle GRC Application

Webserver: 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: APPWORX

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, 12c)

EXPERIENCE:

Confidential

Senior Oracle APP DBA

Responsibilities:

• Manage Oracle 11g 2 nodes RAC environment
• Manage Oracle SSO/OID with Oracle Fusion application.
• Implement syncing process between AD and Oracle OID
• Implement Oracle OUD and Fusion Application
• Testing EBS upgrade from 12.1.3 to 12.2

Confidential

Lead Oracle Application DBA

Responsibilities:

• Manage SQL Server 2008 database for company SharePoint environment.
• Schedule daily backup for SQL Server database.
• Oracle Enterprise Manager 12c implementation
• 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 .2.0.3, convert tablespace to OATM
• Clone Oracle Application R12 environment
• Using Shared ApplTop for R12 environment
• Configure 10g Physical Standby database.
• Oracle Application Platform Migration
• Migration Oracle Application from HP platform to AIX platform
• Oracle Application server upgrade
• Upgrade the Oracle application server software to the latest SOA suite
• Oracle Application BI publisher installation and setup
• Siebel Analytics database support

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 Oracle 10g Application Server
• Setup 10g Application server for discoverer application (discoverer plus,viewer)
• Setup 10g Application server using Internet directory
• Upgrade Oracle Application 11.5.9 to11.5.10.2
• 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.
• SQL Server
• Manage about 20 SQL server database
• 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.
• Upgrade Oracle Apps 11.0.3 Database 8.0.6 to Oracle Apps 11.5.8 Database 9.2.0.3
• Oracle Apps 11.5.8 instance cloning.
• Work with Oracle developer to evaluate patches, research issues, applying patches.
• Setup Oracle Apps reporting environment using Confidential online replication tools - SharePlex.
• Setup Oracle Apps failover environment using Confidential 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

Environment: includes Oracle Financial Applications running under HP /UX. The total database size is more than150GB. Responsibilities include database tuning, installing and upgrading oracle 7.x/oracle8.x, configuring SQL NET to communicate with other oracle databases in both a UNIX and WINDOWS/NT environment.

Confidential

Senior System Engineer, Oracle DBA

Responsibilities:

• Position required familiarity with both Oracle and Informix databases.
• Was responsible for installation of both Oracle and Informix, configuring database parameters for different environments, working as a oracle DBA in the customer site, and daily database backup, performance monitoring and tuning.
• Experience includes installing and configuring more than 20 sets Unix servers in 2 node or 3 nodes cluster architecture.
• Competency included tuning system kernel parameters, in order to facilitate optimal performance with databases (Oracle7.x, Infomix7.x).
• Participated in development of communication software.
• Used C in a Unix environment.
• Performed stream programming, also regularly performed tracing and debugging.

Confidential

Senior System Engineer

Responsibilities:

• Performed network design, database design and solved customer's problems in SCO Unix system environment.
• Install and configure Unix servers with RAID 0,1,5.

Confidential

System Administrator

Responsibilities:

• Performed network system administration of IBM ES9000, in charge of the communication between ES9000 and 7 AS/400 systems.
• Also performed VTAM programming.
• Also familiar with Novell having installed and configured several Novell LAN networks.

Operating Systems: Windows NT, HP/UX, SCO UNIX, AT&T Unix SVR4, DOS.