SUMMARY:

• DBA with over 11 years of database administration and development experience, managing over 20TB of production databases and utilizing several technologies such as Oracle (7.x, 8.x, 8i, 9i, 10g, 11g), RAC 10g & 11g, Oracle Golden Gate replication option: Data Guard, Fast - Start Failover, Flashback, ADDM, AWR, StatsPack, RMAN, Security, Encryption, LogMiner, Server side alert, Oracle Enterprise Manger (9i and 10g), PL/SQL, SQL, ETL, Data pump, Exp/Imp, Toad, SQL Navigator, Veritas NetBackup, Solaris 5.9 and 5.10, Sun x86-64, SCO Unix, SPARC Enterprise T5220, Sun Fire 15000 and T200, Microsoft Windows cluster, Oracle Failsafe, Windows 2003, NT operating system and Active Server Page (ASP), JDBC, ODBC, Dot Net Developer. Automate admin, backup and monitoring process using shell script such as Bash and Korn. Also develop application using Visual Basic 5.0, Dot Net, ADO and DAO.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Technology Educator / Community Activity Organizer

Responsibilities:

• Provide computer training in Database concept, SQL programming, Linux, shell script. Provide advance computer training in Oracle 11g and 12c database administration, such as installation, backup and recovery, performance tuning using SQL*PLUS, SQL Developer, Data Guard, and Oracle enterprise manager through Oracle VM virtual box manager. Provide consultation on issue related with Oracle technology such as backup/recovery, and tuning. Excellent customer service skills and the ability to work with all levels within the organization. MySQL database self-study. Encouraging diverse residents, faith based organizations, businesses to participate with community outreach events and activities.

Confidential, San Diego, CA

Sr. Oracle DBA

Responsibilities:

• Ensure a 24*7 high availability of the production databases environment by: Successfully implement and administer Oracle 10g and 11g in OLTP and Data warehouse OLAP (20Tb), SUN Solaris environment. Config, setup, admin, patch and audit production Oracle 11g RAC with Transparent Data Encryption (TDE) in comply with the Center for Medicare and Medicaid Services (CMS) security requirement and resolved related issues such as using non-default port in the cluster environment. Lead Oracle system testing effort by coordinated with server and network team to develop solid testing cases. Successfully identified, documented and resolved Oracle bugs and single point of failures. Develop Disaster Recovery (DR) plan and successfully recovered production db to a secondary system. Setup staging database by cloning a copy of production for OS/Oracle patching, security testing and disaster recovery. Successfully implement Oracle 10g physical replication standby database using Data Guard read-only option. Successfully test partial-site failover and switchover with automating OCI and JDBC clients failover using Fast-Start Failover, Data Guard Observer, Service relocation, Client Notification and reconnection. Re-architect our database monitor topology by separate the OEM Grid Control repository from the database that's been monitored. Also separate the repository from Oracle Management Server. Implemented new RMAN backup methods such as multi-channel parallel process, incrementally merged image copy with encryption, compression, corruption verification and RMAN catalog using BASH shell scripts. Improve level0 backup speed of a 15Tb data warehouse db from over 4 days to less than 19 hours. Resolved Oracle RMAN and disk-to-tape, SAMQFS, integration issues. Responded and resolved critical db alerts during off-hour.
• Proactively involved with SRB java developer team to resolved concurrency performance issues and provide solid advice with test case to allow their application to scale well. Lead Cipres database redesign effort to allow better query performance and much faster backup and recovery time through list partition and local indexing. Successfully recovered lost data from user deletion error using tablespace level cloning. Identify data corruption and recover primary db with block level recovery. Recover Drugdb tables by export and import the same tables from standby. Refresh development databases using tools such as datapump and external tables. Support HPSS usage statistic project by eliminating several Perl scripts that were used to format and sort raw data before loading into main table through Oracle external table feature. Excellent customer service skills and the ability to work with all levels within the organization.

Confidential, San Diego, CA

Sr. Oracle DBA

Responsibilities:

• Performance tuning Identified, analyzed and resolved application performance issue of our commercial product for Healthcare and Medical Insurance adjustor and client integration program through various tuning methods such as STATSPACK, session trace, TKPROD, Autotrace, Explain plan, v$sql plan and dbms xplan and disk io analysis in a connection pooling, load balancing and Oracle Data Guard environment. Provide recommendation to development team for necessary application change to improve web performance from minutes to sub-second. Developed SQL, PL/SQL, and Shell scripts to query Oracle v$tables and STATSPACK tables to monitor databases matrices and alert log files. Helped Developer DBAs to improve data exp/imp speed written in Perl from over 10 hours per schema to less than 30 minutes and provide way to monitoring import speed to derive better timeline estimation. Identify and provide practical solution to various Oracle issues such as snapshot too old issue during overnight data junction batch loading. Setting up a secondary Oracle 9i Enterprise Manager and repository and create user defined events to better monitor performance matrices. Backup Recovery Automat hourly, daily and weekly backup process using RMAN and Shell scripts in Oracle9i physical standby environment. Identify data corruption and recover primary db with block level recovery. Recovery physical standby database due to h/w corruption. Cloning production db using RMAN for 9i Data Guard testing. Setup RMAN catalog repository.

Confidential, San Diego, CA

Oracle DBA

Responsibilities:

• Project lead for Oracle Team. Achieve 99.9% uptime SLA for Oracle production databases in a 24*7 manufactures and distributed environment for the past 3 years. Oracle Database Planning and Standardization: Develop & implement strategies in the area of performance monitoring automation, application tuning, on/off line backup, partial/complete recovery methods, disaster recovery, connection manager, heterogeneous services, capacity planning, change control, security auditing and user admin. Monitoring: Integrate Oracle Failsafe with Oracle Enterprise Manger 9i and 10g Grid Control to provide high availability and monitoring in Windows clustered SAN system. Extend OEM9i email function to send SNMP paging through fixit job and TCL script. Successfully integrate Oracle 9i SNMP with third party monitoring tool, SNMPC. Tuning: Support multiple .NET application teams by providing insight into Oracle architecture, tools for tuning SQL, PL/SQL, Store procedures and packages. Refresh development databases weekly using Exp and Imp utilities base on production. Identify and tune top SQLs and sessions that perform poorly through session trace, TKPROD, Autotrace, Explain plan, v$sql plan and dbms xplan. Utilize AWR, STATSPACK, and BSTATS/ESTATS report to analyze DB activities. Develop SQL, PL/SQL, SQL*Plus, and Shell scripts to query Oracle v$tables and STATSPACK tables to monitor databases matrices and alert log files. Utilize Oracle process to overcome 2GB limitation and address memory > 4 GB in 32 bit Windows OS environment. Implement statistic gathering, connection pooling, cursor sharing, bind variable, functional index to boost DB and application performance. Backup and recovery: Develop step-by-step recovery scenarios for DBAs using RMAN, Flashback, and LogMiner utilities. Successful document and perform DB disaster recovery to staging databases weekly. Recover production databases to remote site using RMAN and migrated them from 32bit to 64 bit Oracle as part of disaster recovery and server consolidation testing. Implement 10G new features such as flashback database, flashback drop tables, to prevent downtime caused by human error and speed up recovery. Successfully recover 82,000 cascade deleted records through LogMiner. Migration/Patch: Install, configure, manage, patch and upgrade Oracle 8, 8i, 9i, and 10G on SCO Unix and Windows environments. Training: Led training on topics such as Oracle SQL tuning, Connection manager, Transparent Application Failover, FailSafe and Security. Provide knowledge sharing by contribute to "Did you know" topics monthly to development team. Security: Establish security model to provide guidance on configuring production and development DBs in a secure manner with development team. Implement OS Authentication to provide single logon for end user. Implement Oracle connection manager to allow external access through firewall. Others: Serve as backup SQL Sever 2000 DBA for other Confidential site at Plymouth.

Confidential, El Paso, TX

Oracle DBA /MIS Engineer

Responsibilities:

• Troubleshoot Oracle relative issues such as performance tuning, TCP/IP, LAN, in NT & Solaris UNIX environments. Involved with application developing process to perform data modeling, sql-apply replication, create and modify database storage structures (tablespaces) and objects (tables, views, indexes). Install and upgrade ORACLE Server from 7.3.x to 8.x. Successfully recover damaged tablespace in the production environment Oracle performance turning staff training project - Served as internal trainer for a 3-day classes and one day hand-on workshop in two of company's manufacture sites. Prepared training materials, and summarized the key performance indicators with relative SQL statement for easy references. Develop warehouse-shipping program using Visual Basic & PL/SQL store procedures. Successfully Consolidate multi-regions (Mexico, America) production data issue (different PCs with duplicated serial number) for Europe shipment. Computer Floor Control System (SFCS) Planning, application development used VB ODBC/DAO/ADO/Oracle Object for OLE, Oracle PL/SQL store procedure & Perl script. Install, maintain and host MS IIS Web server for decision support system used active server page (ASP) & Java script. Set up IBM DB2 v6 database for researching purpose based on Reveal Net's DB2 knowledge Base.

Confidential, Honolulu, HI

Marketing Representative

Responsibilities:

• Marketed life insurance and security products. Diagnosed and repaired PC hardware and software problems for coworkers.

Confidential, Honolulu, HI

Financial Planner

Responsibilities:

• Provided financial planning to customers. Diagnosed and repaired PC hardware and software problems for coworkers.

Computer Support Specialist

Confidential, Honolulu, HI

Responsibilities:

• Diagnosed & repaired PC hardware and software problems