Oracle Database Dba

DAVID RUAN

• CELLPHONE : 919-***-****

• EMAIL : ***********@*****.***

EXPERIENCE SUMMARY

A talented and resourceful professional with solid skill sets in Oracle database, RAC/ASM, Grid Control, Unix/Linux, Perl and shell scripts, working as an Oracle DBA, Oracle Exadata DBA and Oracle GoldenGate administrator for 15 calendar years.

WORKING AUTHORIZATION

Green Card Holder

OBJECTIVE

Oracle DBA(Database Administrator) and PL/SQL Developer

Oracle Exadata and GoldenGate Administrator

PROFESSIONAL SUMMARY

More than 10 years of experience of programming field with extensive knowledge of programming languages (C/C++, Java, PHP, Perl) and database management (Oracle, MS SQL Server, MySQL), strong knowledge of database administration, self-motivated and enjoy working in a team environment.

More than ten years solid Oracle database administration skills and experience in high-end enterprise environments across multiple industries.

More than ten years experience in Unix-like system administration (including Solaris / IBM AIX / HP-UX / Linux / BSD). Proficient in developing management scripts using Korn/Bash Shell and Perl.

Eight years solid hands-on experience and outstanding troubleshooting skills to Setup / Configure / Monitor / Maintain Oracle 10g/11g/12c RAC / ASM / Data Guard environments.

Three years first-hand administrative experience in Oracle Exadata database machine (include X5/X6/X7) administration, migration, health check, resource management, patching/upgrade and SQL tuning.

First hands-on skills about Exadata hardware architecture including Storage, Grid and Infiniband. Deep understanding of key Exadata features including HCC (Hybrid Columnar Compression), Smart Scan, Smart Flash Cache, Storage Index and Storage Management.

More than six years experience and solid hands-on experience in Installation / Configuration / Performance Tuning / Troubleshooting Oracle GoldenGate in Oracle to Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and MS SQL Server to Oracle).

Seven years experience in huge size Oracle data warehouse (more than 30TB) solutions and ETL architecture, development, maintenance, production support, data modeling, reporting fields. Extensive knowledge and experience on various ETL, reporting, and database development tools such as Informatica, Erwin and Power Design.

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.

More than six years experience in PL/SQL, Procedure, Functions, Triggers, Packages development in applications such as Financial, Telecom fields.

Highly skilled in SQL and PL/SQL Tuning, TKProf, Explain Plan. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor.

Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

TECHNICAL SKILLS

DATABASE: Oracle 10g/11g/12c, MS SQL Server, Sybase

LANGUAGE: SQL, PL/SQL Perl, Korn/Bash Shell, Java, C/C++

PLATFORM: Oracle Exadata, Redhat Linux, IBM AIX, HP-UX, Oracle Solaris, FreeBSD and Windows

DATA REPLICATION: Oracle GoldenGate

MONITORING: Oracle OEM 12c.

TOOLS: SQL/Plus, Toad, SQL Developer, DBArtisan

PROFESSIONAL HISTORY

February 2022~ Present: GXO Logistics Remote

Position: Senior Oracle DBA

Lead a large complex 19c upgrade project to upgrade 4 databases and 3 goldengate system together, called SmartSuites, from 12c to 19c, involves fivetran replication to datalake, write docs to be used by DBA team after making prototype works in lab env.

Lead and monitor the smartsuite 19c upgrade for 23 customers with more than 200 prod and nonprod databases with the docs I drafted from scratch.

Strong PLSQL coding experience with the ability of line by line code review with application team to rewrite function/procedure/trigger with business logic and improve SQL running performance.

PostgreSQL database creation, administration and maintance

Setting up Oracle GoldenGate (OGG) systems on Oracle 12c/19c RAC with ASM environments. OGG implementation between six source production systems and Exadata data warehouse environments. Oracle GoldenGate upgrade from 11g/12c to 19c, Goldengate maintenance, such as resync, re-instantiation, or adding tables

Resolve performance issues, by means of OEM monitoring, SQL plan management (SPM), AWR, ASH, ADDM, SQL Tuning Advisor, parameter adjustment, stats gathering, index rebuild, invisible index, table shrinking to lower high water mark, capacity tuning, hints, SQL modification

Oracle GoldenGate performance tuning of lagging by methods such as splitting replicats, OGG parameter tuning, database tuning, application large table re-design, Linux/Unix kernel performance tuning, etc.

Troubleshooting OGG abending due to long running transaction, trigger firing, unique key violation; troubleshooting hang due to index unusable by means of GGSCI, report file or discard file ananlysis, logminer utility, sql monitoring.

Provide 24x7 on call production support

November 2018~ December 2021: Bank of America Dallas, TX

Position: Senior Oracle DBA

Administered 12c/19c RAC databases with ASM on Exadata Platform, such as capacity management, security management, and performance monitoring and database tuning by OEM, ADDM, AWR, ASH, Statspack, SQL plan management (SPM), home-cooked scripts, etc.

Extensive experience of supporting application team daily operation, various data loading, data movement, application release, DR switchover test, monitor/maintain daily/nightly application batch jobs.

Solid performance tuning experience of application jobs, via statistics gathering, index rebuild, PL/SQL rewriting, big partition table reorgnization, Hybrid Columnar Compression (HCC) partition tables, etc.

Performed regular TB level database refresh by Expdp/Impdp with tight business schedule, data movement cross databases of different versions, improved expdp/impdp performance with optimized parameter sets, analyzing / troubleshooting errors in expdp/impdp log files

Solid skill of shell scripting and create/maintain automated scripts for Expdp/Impdp

Used remedy tools for incident management, CRQ, and nexus ticket system

April 2017~ August 2018: BNY Mellon Bank Pittsburgh, PA

Position: Oracle Database Administrator

Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.

Involved in software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, upgrades according to the suggestions from Oracle support department.

Analyze and fix execution plan flips of more than 15 bridge water production DB queries benefiting the monitoring logics of query plan flip.

Tune the performane of a CMPDBO query in our top performance issue list with around 80% buffer get reduce.

Participate in copy back automation project. Code five sub functions with Linux scripts and PLSQL, including complex logics to generalize ‘update pacemaster’ function to cover copy back from different source db to different target db within same region, cross region, cross app versions, and initial db build.

Participating in the data modeling sessions to understand the data model and providing inputs based on the existing data to make sure designed model is technically feasible.

Involved in a large number of tuning projects. Working with third party developers on SQL code review and quality control. Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, ASH, OEM Performance Manager and home-cooked scripts by using Korn shell/Perl.

Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.

October 2012 ~ March 2017: Charles Schwab Denver, CO

Position: Senior Oracle GoldenGate Administrator

The primary Oracle Goldengate (OGG) resource to manage a very complex OGG enterprise infrastructure in collaboration with the DBA team.

Lead all OGG related tasks such as OGG installation, configuration, tuning, maintenance, patching, and problem diagnosis and resolution.

Manage all aspects of the OGG design, implement and support in development, UAT and production environments; Identify and resolve OGG problems occurring in all database environments including performance related issues (i.e. database & SQL tuning)

Review and approve Remedy tickets to ensure Sarbanes Oxley (SOX) compliance parameters. Provide timely SOX documentation for SOX audits.

Review and participate in Translating business and functional requirements into incident specification design documents. Write unit test scripts. Perform unit tests and clearly document results.

Setup both the OGG one-way and the active-active data replication system and design the conflict detection solutions; Effectively decrease Oracle Goldengate lag by using various technical methods such as database tuning, OGG parameter tuning, application large table re-design, Linux/Unix kernel performance tuning, etc.

Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.

Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from MS SQL Server to Oracle Linux X64 box).

October 2007 ~ September 2012: Baxter Inc Deerfield, IL

Position: Oracle Database Administrator

Part of the Data Architecture team which supports development, test and production databases

Installed Oracle database, and applied Patches and DB migrating. Monitoring, Tuning and optimizing the performance of the database.

Implementation and support of 9i and 10g migrations and upgraded from Oracle 9i to Oracle 10g databases, including RAC (Real Application Clusters) databases on IBM AIX and Linux.

Planned and implemented a comprehensive Oracle backup & recovery strategy. Set up and maintained oracle disaster recovery site using DataGuard.

Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.

Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.

Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.

Provided application 7x24 technical support for high availability system via on-call and troubleshooting. Responsible for production application maintenance involving enhancements and performance improvements.

Auguest 2005 ~ September 2007: Hewlett-Packard Pontiac, MI

Position: Oracle PL/SQL Developer and DBA

Involved in Business Requirements, System analysis and Design of the Data warehouse application. Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, backups, replication, and other distributed data issues over a highly volume Terabyte Database.

Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats. Designed Physical and Logical Data model and Data flow diagrams and Designed database Relational and Dimensional models using ERwin.

Designed, and developed Oracle PL/SQL ETL processes for loading data from internal systems using SQL Loader and External tables.

Worked on various tables to create indexes to improve query performance. Also worked on partitioning large Tables using Range/List/Hash Partitioning, creating Index Organized Table (IOT), Cluster 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 optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.

Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.

Designed Test Plan and Test Cases according to Functional Requirements and design specifications of the application and executed them with testers. Implemented Unit Testing Stored Procedures, Functions, Packages and Triggers.

EDUCATION

Ph.D. of Electrical and Computer Engineering

University of Virgina 2005

Contact this candidate