SUMMARY

• +17 years’ experience with supporting Oracle OLTP, hybrid and data warehouse in large scale and complex environments (single DB>22 terabytes and single environment > 200 databases)
• Expert level with Oracle database (8.x, 9.x, 10G and 11G), oracle Application (11.5.9 Business suite) implementation, administration, performance tuning and backup/recovery on UNIX (HP - UX, Sun Solaris and AIX), Linux (Redhat advanced server 4, 5 and 6.1)
• Undertake installations, upgrades, migrations, cloning and patch management of Oracle E-Business Suite environments (Database and Application Server). Perform application and database tuning, performance monitoring and investigate troubleshooting for various customers. Administer Oracle 10g /11g databases for third party applications.
• Hands-on experience with Oracle advanced HA options and monitoring tools: 11g RAC, 11G Grid Control, ASM, standby/dataguard, and advanced replication, RMAN, and OEM, Grid Control.
• Expert level with setting up and monitoring Shareplex replication with various configurations.
• Excellent troubleshooting, organization and communication skills.

TECHNICAL SKILLS

RDBMS: Oracle 11g, 10g, 9i, 8i, Microsoft SQL Server 2012/2008/2005/2000 , MySQL 5.5/5.1, MS Access 2010

PROGRAM: C, VISUAL BASIC 5.0/6.0, SQL*plus, PL/SQL, HTML, Perl

CASE TOOLS: Oracle 11.5.9 e-business suite. Oracle Designer 2000, Developer 2000 (Form 6, Report 6), Crystal Report 7.0/8.0, Lawson, Informatic. Clearcase.

PLATE FORM: UNIX (Linux RH 4, 5 and 6 x86, Sun Solaris 6/7/8/9/10/11, HP-9000, RS6000, AIX 6.1), Veritas Cluster Server & Volume Manager 3.x, Windows 2003, Windows NT (Server 4.0), and DOS 6.0

OTHERS: Erwin 7.3, 7.1, 3.5; Shareplex 5.3, Clearcase, Tock, Portal, iPlant 4.1, WebLogic 6.1, ASP, Cold Fusion 4.5, Visio 2007, MS Office 2010 (Word, Excel, Access, PowerPoint, Exchange, Outlook), Lotus 1-2-3 3.1, WordPerfect 5.1, SecureCRT 3.3, Embarcadero Rapid SQL 7.0, Embarcadero Change Manager 2.5, Exceed, DBArtisan 7.3, ERStudio 5.1, ERWin 7.3, Toad 10.1, Spotlight 4.5, StarTeam 4.0, Oracle 11g grid control 11.1, Hummingbird 10. Site Scope. Reflection X12.0. Crystal Reports 2008;

PROFESSIONAL EXPERIENCE

Sr. DBA

Confidential

Responsibilities:

• Build up many two nodes primary and two nodes secondary Oracle RAC 11gR2 Dataguard on AIX 6.1 servers with ASM file system;
• Setup RMAN backup from RAC STDBY nodes to Tape;
• Load 11.2.0.3.11 PSU patches to over 20 RAC and Non-RAC databases;
• Setup Oracle Kerberos to Centrify and let user use LANID to log into Oracle Database;
• Add and drop physical disk to/from ASM;
• Change DB character set on-line;
• Set up heterogeneous DB-link between Oracle to MSSQL;
• Terabytes table partition and compress both table level and tablespace level;
• Move AUD$ table out of system tablespace;
• Support AIX OS AIX61TL8SP2 upgrade to AIX61TL8SP5;
• Daily routine management, maintenance Oracle 11gR2 RAC databases by using Grid Control;
• Clone Oracle 11gR2 RAC database to RAC DEV,QA from PRD;

Sr. DBA

Confidential

Responsibilities:

• Upgrade oracle 9i, 10g database to 11gR2;
• Upgrade MSSQL 2000/2005 to MSSQL 2008/2012;
• Installed, built up and configured Oracle Internet Directory (Oracle OID 11.1.1.5) on VM with Weblogic ;
• Upgrade OIM (Oracle Identity Manager) from 9.0.1.3 to 9.1.0.2 BP19;
• Installed, built up and configured Oracle 11gR2 two nodes RAC on VM;
• Built-up, configured and admin Oracle 11gR2 Data Guard on VM;
• Built-up, configured and admin Oracle 11g Grid control on VM to monitor oracle 11gR2 databases and SQL Server 2008R2SP1 Databases by plug-in approach;
• Changing Oracle 11gR2 Database character setting by not shutting down database;
• Built-up SQL Server 2012 SP1 and 2008R2 Database on VMware;
• Setup, configure and admin SQL Server 2008R2 database auditing system;
• Move SQL Server 2000, 2005 databases to another server; (plus transfer login, credential and DTS local packages, jobs);
• Support many projects both on Oracle and MSSQL;

Sr. Oracle Production DBA

Confidential

Responsibilities:

• Data modeling (conceptual, logical & Physical using Erwin 7.3), Relational and dimensional data models, Data dictionary content and metadata usage and Object Modeling.
• Supported Java programmers with working to Oracle Database.
• Worked daily with Java programmers and System Administrators.
• Use AWR to analyze and tune each Database and add indexes or drop indexes;
• Perform analysis, design and implementation on a variety of database, both physical and logical.
• Built up context Indexes in CLOB data type on Oracle 11g database and XML Indexes in XML data type on Oracle 11g database.
• Daily Managed 4 MySQL production databases. Replicated MySQL databases between Burbank and New York.
• Daily managed and maintained 13 Production MS SQL databases(2005);
• Configured various client software to connect to ORACLE and troubleshoot problems as they arise.
• Monitor transaction activity and resource utilization (CPU, memory, disk subsystem and network traffic) to diagnose resource shortages. Balance I/O.
• Daily/Weekly backup of all Oracle Databases, MS SQL, MySQL databases.

Sr. Oracle Production DBA

Confidential

Responsibilities:

• Upgraded Production Oracle 10g Database to 11gR2 on Solaris 10 system and Linux Red Hat 4 system;
• Worked with Unix ODBC connection with SQL Server 2005 by Heterogeneous, osql, isql and tsql;
• Upgraded Production Oracle 9i Database to 10gR2 on Solaris 10 system and Linux Red Hat 4 system;
• Worked with SQL server 2005 database, backup, restore and maintenance;
• Built up 10g Data Guard on Production database and setup reporting database by hot standby database;
• Moved Oracle 10g database from one server to another server;
• Configured VLM and hugemem on Linux system;
• Built up Oracle 10.2.0.3 grid control (10g OMS) and installed 10.2.0.3 grid agent in many Oracle 10g, Oracle 9i servers
• Managed the software release and processed table partition;
• Handles daily RMAN backup on many 10g Databases;
• Clone development and QA databases from production by RMAN backup;
• Installation and application of Oracle’s Critical Patch Updates.
• Optimize performance between Oracle Databases, operating systems and back-end storage.
• Partition tables and indexes monthly;

Sr. Oracle Architect DBA

Confidential

Responsibilities:

• Built up SiteScope Monitoring system;
• Built up three 10g R2 RAC databases on Linux servers;
• Built up RMAN backup system for 10g R2 RAC databases;
• Built up Oracle 10 grid control (10g OMS) and installed grid agent in many Oracle 10g, Oracle 9i and then connect with Oracle 10g grid control.
• Worked daily with Oracle 11.5.9 e-business suite issues and concurrent manager, printer issues.
• Installed and built up Oracle 11.5.9 Application on RAC Application server and clone App RAC production to RAC stage, and single test, single dev. APP server weekly;
• Patched, upgraded Oracle 11i (11.5.9, 11.5.10) and Apache, Forms server, and Oracle 9iAS; Experience in applying patches to Oracle Database and Oracle Apps patch management, patch migration processes.
• Instance Cloning (RAC, Non-RAC), Code migration processes.
• Built up and administrated shareplex 5.3 replication from production RAC database (Linux) to reporting RAC database (Linux);
• Managed the software release process.
• Clone development and test databases from production.
• Installation and application of Oracle’s Critical Patch Updates.
• Optimize performance between Oracle Databases, operating systems and back-end storage.
• Database tuning using Stats pack and SQL tuning using TKPROF, SQLTRACE

Sr. Oracle System DBA

Confidential

Responsibilities:

• Built up and maintenance Oracle 10g release 2 RAC database with ASM file system on Linux 3 nodes server with grid agent.
• Built up and maintenance Oracle 10g release 2 database with ASM files system on Linux and HP server with grid agent.
• Setup the 10g Grid Control Management Infrastructure for managing the 200+ oracle databases.
• Built up and managed Oracle 9.2.0.6 three node RAC database on Linux RH 3 system.
• Provided the standard documentations for building the 10g RAC, ASM & Grid Control infrastructure
• Managed RMAN Daily backup for 56 Production Databases.
• Installed Shareplex 5.1 on Production (source) database and replicate to reporting data warehouse.
• Upgraded Oracle database from 8.1.7.4 and 9.2.0.4 to Oracle 9.2.0.6 on Linux operating system.
• Setup Heterogeneous services for SQL server database to Oracle database.
• Built up hot standby database for rman management database.
• Database tuning using Statspack and SQL tuning using TKPROF, SQLTRACE.
• Sox compliance of production & cert databases, scrambling of NPI data.
• Optimize performance between Oracle Databases, operating systems and back-end storage.
• Extensive database backup and recovery experience using RMAN, BCV.
• Automate database maintenance tasks and monitoring with UNIX shell scripting.
• Installation and application of Oracle’s Critical Patch Updates.
• Review application code changes for compliance with corporate standards.
• Managed the software release process.
• Clone development and test databases from production.
• Provide 7 by 24 production supports for all enterprise ORACLE databases, ranging in size from 100 GB to 17Tb.

Sr. Oracle Production DBA

Confidential

Responsibilities:

• Built up and migrate 2 databases from Oracle 8.1.7.4 to Oracle 9.2.0.5 (from US7ASCII to UTF8 ) and made one database as hot standby database, with Oracle 9i data guard.
• Built up Context Index in CLOB datatype on Oracle 8i database
• Wrote Unix Shell scripts to populate data.
• 24/7 Maintaining, monitoring and tuning three Production databases and three hot-standby databases with Oracle 8i data guard, plus three development and two QA databases.
• Setup quick i/o file system in Unix boxes in order to improve performance.
• Deploying daily code release, database changes, etc.
• Daily backup (Hot and export) all databases.

Oracle DBA

Confidential

Responsibilities:

• data modeling (conceptual, logical & Physical using ERWin 4), Relational and dimensional data models, Data dictionary content and metadata usage and Object Modeling built up and managing 2 Production Databases 9.2.0.4 . (the biggest database was 3 TB).on Sun Solaris 2.8 at Global Crossing (24*7), Configured UNIX Kernel, Imported application.
• Independently built up 2 Oracle 9.0.1 Production Databases .
• Installed RDA and Statspack on each Database and tuning.
• Built up and migrated (from US7ASCII to UTF8 and from 8k db block size to 16k db block size) 13 in-house Databases (Oracle 9.2.0.4 and Oracle 9.0.1.1) on Unix Sun Solaris 2.8.
• Perform analysis, design and implementation on a variety of database, both physical and logical.
• Built up Context Index in CLOB datatype on Oracle 8i database, and XML Index in XML datatype on Oracle 9i database.
• Replicated databases between Santa Monica database and Amsterdam database.
• Maintained all Oracle related products for whole company routinely.
• Configured various client software to connect to ORACLE and troubleshoot problems as they arise.
• Monitor transaction activity and resource utilization (CPU, memory, disk subsystem and network traffic) to diagnose resource shortages. Balance I/O.
• Setup multi-master replication.
• Setup Oracle 9i OEM and Oracle 8i OEM 2.2 going through Firewall.
• Daily/Weekly backup of all Oracle Databases. Cold Back up in-house Database and Hot Backup Production Database. Recovery from RMAN.
• Tuning Oracle’s memory, changing from dedicated connections to MTS.
• Supported Java programmers with errors to Oracle Database.
• Worked daily with Java programmers and System Administrators.

Oracle DBA

Confidential

Responsibilities:

• Designed and Built up Data warehouse with OWB using star schema module.
• Created fact tables and dimension tables and materialized views; Partitioned fact tables and related indexes.
• Analyzed and maintained Oracle 8.1.6 Data warehouse and in charge of extracting data from a couple of deferent Databases (SQL Server).
• Responsible for Financial Database (Lawson System). Specifically A/P, A/R, GL, Budget, Express and Financial Analyze, and Self-Service Expenses. Familiar with Oracle HRMS, Self-Service HR, OTM, and OTA.
• Extracted data by Oracle transparent open gateway ODBC driver.
• Imported, exported and loaded data using Oracle Enterprise Manager 2.1 / Data Manager / SQL loader. /Perl.
• Setup Oracle Client application using Oracle Network tool SQL Net / Net8.
• Database administration including managing Oracle instance, creating data dictionary views and standard packages, maintaining control file, redo log files, table spaces and data files, managing storage, rollback and temporary segments, managing tables, indexes, clusters, users and privileges/roles.
• Extracted data from Oracle 8.1.6 database to create Crystal Reports.
• Responsible for Database configuration, tuning, replication, data migration, database design, Database architecture, backup/recovery. Stored procedure, function, package and trigger in Unix Sun Solaris environment.
• Korn and “C” Shell programming in UNIX Platform.
• In full charge of Confidential .com financial Database.

Oracle DBA

Confidential

Responsibilities:

• Analyzed and maintained Oracle 8.1.5 Database and Oracle Financial Database.
• Built up Oracle Application Server (10.7/11/11i) by two nodes (60GB) and connect to Database Server, Concurrent Management Server, Report Server, Form Server and Application Server with two owners (Oracle and Applmgr).
• Converted SQL Server 7.0 Database to Oracle-by-Oracle transparent open gateway ODBC driver.
• Imported, exported and loaded data using Oracle Enterprise Manager 2.0.5 / Data Manager / SQL loader.
• Setup Oracle Client application using Oracle Network tool SQL Net / Net8.
• Database administration including managing Oracle instance, creating data dictionary views and standard packages, maintaining control file, redo log files, table spaces and data files, managing storage, rollback and temporary segments, managing tables, indexes, clusters, users and privileges/roles.