SUMMARY:

• Over 14 years experience in IT field, 8 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. Database 9i upgrade,Database 10g upgrade. SOX 404 audit experience

TECHNICAL SKILLS:

• RDBMS ORACLE 7.x/8.x/9.x/10.x, SQL server 2000, SQL server 2006
• Applications Oracle Application 11.5.10 /11.5.9 /11.0.3, Siebel Application, MS sharepoint
• Application, Clarify Application
• Webserver Oracle 10g Application Server, Apache Web server
• Database Tools Quest TOAD, SQL Navigator, SPACE MANAGER, LIVE REORG
• Monitor Tools Quest FOGLIGHT,SPOTLIGHT for ORACLE, SPOTLIGHT for ORACLE APPS
• Replication Tools Quest SHAREPLEX
• Migration Tools Quest 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)
• Application Installation of Oracle RDBMS (8.0.x,8.1.x,9.2.x)
• 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 10g)
• 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)
• Implementation of Oracle APS system (Demand planning, Advance Supply Chain)
• Implementation of Oracle Application Reporting server with Quest 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.

PROFESSIONAL EXPERIENCE:

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
• 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 Siebel Application 6.2 to 7.7
• 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 Quest SharePlex
• Upgrade Oracle Application 11.0.3 to11.5.8
• 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 Quest online replication tools - SharePlex.
• Setup Oracle Apps failover environment using Quest 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
• Implement Oracle Application 11.0.3
• 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 Quest online replication tools - SharePlex.
• Monitor Oracle Apps environment.
• Setup Discoverer User account.
• Implement Siebel Application 6.3
• 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 Quest SharePlex to setup the high availability environment for Siebel

Confidential

Senior Oracle DBA, Oracle Application DBA

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.