SUMMARY:

• Oracle DBA with experience in client/server and web environment on Unix/Linux platforms. Capable of applying new methodologies, and strategies with proven results. Ability to lead projects and work efficiently with other team members. Strong communication skills with solid technical and academic background.
• Experience in RAC
• Installed, configured and upgraded three - nodes Oracle RAC 11gR2 databases on Unix/Linux.
• RAC with Oracle Grid Infrastructure (Oracle Clusterware+ASM+Virtual IP (VIP)+ACFS +SCAN listeners).
• Configure ASM disks by asmca and SQL commands for hosting RAC databases.
• Applied upgrade patchset to RAC databases, ASM, Clusterware.
• Maintained separate RAC database for testing and cloned production databases.
• Experience in High Availability: Data Guard
• Implemented a disaster recovery solution for mission critical production databases. Proficient in setting up physical standby databases with redo log apply.
• Setup Active Data Guard and Snapshot Standby database with Flashback Recovery function and use Data
• Guard Broker to perform swithiver/failover/reinstate/flashback capabilities
• Configured physical standby database for Maximum Availability protection.
• Duplicated database using RMAN cloning from production to UAT servers.
• Experience in Data Replication: Stream
• Setup Capture, Propagation and Apply processes by using DBMS STREAMS ADM.MAINTAIN TABLES
• Customize Stream by defining rules not to replicate LOB columns or only replicating the matched subset criteria, adding Global Rules to exclude certain DDLs like Truncate Table etc. to be replicated.
• Monitor message latency, Keep data in sync by fixing the Logical Change Record (LCR) and instantiate tables
• Using Heartbeat table to ensure Stream function well.

TECHNICAL SKILLS:

Operating Systems: Linux 32bits/64bits Red Hat 4.0, UNIX (IBM AIX 5.3/6.1, HP 9000-UX, Solaris 10/11 SPARC), HP3000 MPE, Windows, S/36, AS/400

Database & Networking: Oracle 11g/10g/9i/8i/7x, PeopleSoft 9.1/8.4/7.5/6.0/5.0, Siebel 8.0/7.0, Window NTNetware 3.x & 4.x

Programming: PeopleSoft s PeopleTool, Oracle (SQL*Plus, SQL*Loader, PL/SQL), SQL, C, Unix/Shell, PowerBuilder, RPG II, RPG/400, OCL, CL

EXPERIENCE:

Confidential

Oracle Database Administrator Consultant

Responsibilities:

• POS (Point of Service) system spreads to 4 areas: East,West,South,Mwest using Shareplex to replicate core data between 4 areas. Each region has 3 nodes RAC+ ASM with standalone local /remote DR with ASM.
• Configure OEM 12cR2 to deploy agent software, define the rules, templates, groups, setup alert notification.
• Setup Oracle Database Gateway for connecting to MS SQL Server
• Install patchset for grid and database to upgrade from 11.2.0.2 to 11.2.0.3
• Tuning SQLs by running SQL Tuning Advisor to enable SQL Profile and using SQL Plan Baselines

Environment: HPUX Itanium 64bit, SPARC Enterprise M5000 Server, SuperCluster SPARC T5Oracle Enterprise Manager Cloud Control 12c, Quest SharePlex Replication

Confidential

Oracle Database Administrator Consultant with PeopleSoft

Responsibilities:

• Production and development support, including install and upgrade databases, apply patches, load dataarchitectural design, shell and PL/SQL programming, create Materialized Views, create Standby Database with DataGuard, databases tuning/tkprof/ASH/AWR/ADDM and cloning databases.
• Setup RMAN with IBM s TDP s TSM (Tivoli Storage Manager) to backup/restore/clone database.
• Setup Oracle Internet Directory (OID) and Oracle Name Server with DNS (Domain Name System) for the client s database connection. Involving in Disaster Recovery Planning using Standby database.
• Cloning database using EMC s BCV(Business Continuance Volumes), using Quest s SharePlex to replicate data, Setup Oracle Stream to replicate tables.

Environment: Oracle 11g/10g, IBM P595 AIX6.1, Quest SharePlex, Tivoli System’s Maestro Workload Scheduler, Tivoli Data Protection (TDP 5.2/2.2 for Oracle ), PeopleTool 8.51/7, SQR, PeopleSoft’s Tuxedo Application Server, PeopleSoft ERP Financial 9.1/8.4/7.5 and HR 9.1/8.16 Application, BMC’s Patrol Monitor Tool, Oracle Enterprise Manager Oracle 11g Grid, EMC TimeFinder BCV/Snap, EMC Symmetrix SAN Storage.

Confidential

Oracle Database Administrator

Responsibilities:

• Apply application patches using adadmin and adpatch, clone app tier and db tier using Rapid Clone I
• (adpreclone and adcfgclone)
• Bounce app tier and DB tier and Concurrent Manager and Apache Server

Environment: Oracle E-Business Suite R11/R12 (Financial, HR), NetApp FlexClone, Stratavia’s Data Palette for Automation Clone

Confidential

Oracle Database Administrator

Responsibilities:

• Support City wide Financial Applications, budget, accounting (On - line and Report) support DB2 UDB for z/OS; database native tool (such as SPUFI on DB2 UDB for z/OS)
• Oracle Database Administrator
• Support Customer Relation Management (CRM) SIEBEL for worldwide locations including: SQL tuningsetup high availability by using HP ServiceGuard cluster and Oracle Data Guard, replicate tables by using
• Oracle Stream, checking AWR/ADDM/ASH(Active Session History) reports.