SUMMARY:

• One real Oracle DBA veteran who has over five years of focused experience in high end Oracle database administrative area in various finance fields. Extensive experiences in Oracle database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Involved with the architect group in designing the logical and physical model of the enterprise level databases. Have long term and solid experience in Oracle PL/SQL, RMAN, RAC, ASM, DataGuard, GoldenGate, Exadata installation, configuration, trouble - shooting, and performance tuning. Have impeccable communication and interpersonal skills and an exceptional team player.
• Over 5 years extensive experiences in Information Technology industry, especially in Oracle Database / Unix-like system administration, software design and implementation area.
• Over 5 years in Oracle databases (9i/10g/11g/11gR2/12C) as Oracle Database Administrator in Oracle Redhat/CentOS Linux, IBM AIX, Solaris, Exadata machine,.
• Solid hands-on experiences in installation, configuration, trouble-shooting, performance tuning in Oracle High Availability technologies, including 11g/12C Database, DataGuard, RAC, ASM, Goldengate.
• Proficient with Database Cloning, Migration, Standby Database, Data Guard and Patching of Oracle Databases and RAC.
• Experience with Oracle 11g/12c new features: Flash-Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo Management, Grid Monitoring and Recycle Bin.
• Proficient in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold and hot backup, full/incremental backup.
• Highly skilled in SQL Tuning by using Oracle statistics management, Execution Plan, and necessary SQL code rewrite. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/OEM/AWR/ADDM/SQL Advisor/SQLT.
• Strong work experience with tools like PL/SQL Developer, OEM Grid Control 11g/12C, Statspack, SQLT.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Writing SQL or PL/SQL scripts to monitor database performance, Rman backup, Goldengate, OEM, etc.
• Proficient in developing management / monitoring scripts by using Bash Shell and Perl.
• Results-Driven with ability to take initiatives and meet deadlines in a fast paced changing environment; Strong analytical and communication skills with the enthusiasm to learn new technologies.

TECHNICAL SKILLS:

Database: Oracle Database 9i/10g/11g/12c

Language: SQL and PL/SQL, Perl, Korn/Bash Shell

Exadata, Linux, IBM AIX PowerPC, HP: UX

Data Replication: Oracle GoldenGate

Monitor Tools: Oracle OEM, AWR,ASH,ADDM, SCRIPS.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Oracle DBA and Goldengate Administrator

• Oracle Core DBA doing upgrade from Oracle 11gR2(11.2.0.4) to 12c(12.1.0.1). Maintenance both 11g and 12c, in charge of 300 databases include 30 production databases, provide 24x7 live DBA support.
• Check the alert log and trace files of an instance periodically to trace session and detect errors.
• Setup OEM monitoring, include OEM 11g Grid Control and OEM Cloud Control 12c. Generated AWR/ASH/ADDM reports to find Top wait events and Top SQL.
• Used Execution Plan, SPM Baseline, Oracle hints, SQLT to diagnose and fix SQL related issue to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application team.
• Implementation of Rman Backup, include Full Backup and Incremental Backup to FRA. Doing recovery when database goes wrong.
• Disaster Recovery (Using Physical Standby database and Active DataGuard), using Rman Duplicate to clone database.
• Setting up and administering of 11gR2 RAC and Clusterware and Instances. used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD. Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services. Applied patches on Oracle Cluster ware and RAC databases.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
• Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments. Use OGG to do Migration from OLTP to Exadata Machine.
• Trouble shooting ggs process abend, out of sync, check ggserr.log and use ggsci view report. Effectively decrease OGG lag by using various technical methods such as hartbeat table, split function, batchsql, OGG parameter tuning, application large table re-design.
• Upgrade OGG from 11g to 12c. Implement OGG 12c new features like integrated mode, coordinated replicate, exception table, credential store.
• Use Exadata as back end OLAP system for high avaiability, use OGG to do the replicat from front end OLTP to Exadata.
• Install Exadata, setup DSM, ILOM, IP, DNS, NTP, NETWORK. Install Exadata Storage Server, and check the status of process, check issue and doing tuning of Exadata parameter.
• Writing SQL or PL/SQL scripts to monitor database performance, Rman backup, Goldengate, OEM, etc.
• Provided 24x7 on-call supports for mission critical OLTP (RAC) production databases on Linux platforms.

Confidential, Orlando, FL

Oracle Database Administrator Trainee

• Installed, configured the Oracle 10g/11gR2 RAC/ASM production and non-production databases on Redhat Linux X64 boxes to support different applications.
• Maintenance of production database and development database which includes table space management, user creation, and privileges, roles.
• RMAN backup and recovery including physical backups and logical backups by using data pump(Exp/Imp) tool.
• Implemented 11g Data Guard Physical standby using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.
• Implementation and support of 10g and 11g migrations and upgrades from Oracle 10g to Oracle 11g databases, including RAC (Real Application Clusters) databases on IBM AIX and Linux X64 box.
• Created Oracle database objects(tables, partition tables, b-tree and bitmap indexes, constraints, views and materialized views), PL/SQL Procedures/Functions/Packages, SQL and Korn shell/Perl Scripts and develop transaction processes based on created objects to support business needs and report needs. Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
• Designed, and developed Oracle PL/SQL processes for loading data from internal systems using SQL Loader and External tables. Designed, developed and maintained oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Performance Tuning and Troubleshooting of custom and vendor apps running on Oracle databases using AWR/ADDM, traces/tkprof, explain plans, profiles.