EXECUTIVE SUMMARY:

• 18 years’ work experience in IT mainly as Oracle operational DBA, and GoldenGate Administrator.
• Extensive experience in large - scale, highly complex database environment, including database installation, patching (PSU/CPU) and upgrading, and cloning (RMAN).
• Extensive experience with Oracle RAC in UNIX and Linux.
• Extensive experience in Oracle Data Guard (physical/logical standby), parallel and cascade standby database, implementing backup & restore/recovery (RMAN), database monitoring and security, and disaster recovery (DR) solution.
• Extensive experience in performance tuning (OS Watcher, memory management), SQL tuning (explain plan, profile, index, partition), SQL tracing and TKPROF.
• Extensive experience in data replication (GoldenGate, Attunity), including installation, upgrading, patching, monitoring, and troubleshooting.
• Strong experience in project management such as Oracle RAC deployment, ASM conversion, GoldenGate migration to Attunity.
• Extensive experience on incident management and change request management by coordinating infrastructure teams (storage, network, system admin), application teams, and senior management.
• Interact with business analyst and application developer to ensure the overall system design to meet the business requirement of performance and high availability.
• Adopt DevOps to enhance the product delivery and service speed.
• Use JIRA to management project and tasks; Use Confluence for the documentation.
• Problem diagnosis and troubleshooting skills, project and process management skills, communication skill, organizational skills.
• Team player with great positive attitude, self-motivated, helps other team members accomplish tasks.

TECHNICAL SKILLS:

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

High Availability: RAC, Data Guard, ASM, Exadata

Data Replication and ETL: Oracle GoldenGate 12c/11g, Attunity 6.0/5.6

Disaster Recovery:: RMAN backup/recovery, Data Guard (physical/logical standby)

Language: SQL, PL/SQL, Shell Scripting, C, HTML

Database Tool: RMAN, OEM, Erwin, BMC Patrol, IWS (IBM Workload Service)

Development Tool: TOAD, SQL Developer, SQL Assistant (Teradata)

Oracle Tool: OEM, OS Watcher, RDA, AWR, ASH, ADDM, SQL tracing and TKPROF

Oracle Application: Forms, Reports, Express, and Discovery

Operating System: UNIX - AIX, LINUX, Solaris, HP-UX, MS Window

Performance Testing Tool: WebLoad, SwingBench

WORK EXPERIENCE:

Confidential - St. Louis, MO

IT Engineer/Oracle DBA

• Administrate Oracle GoldenGate in large-scale, complex, high-volume environments;
• Manage project on migration from GoldenGate to Attunity;
• Manage project on GoldenGate 12c upgrade;
• Install and configure GoldenGate agent, and document the process/procedure;
• Configure OEM (12c) to monitor GoldenGate and generate reports for the status review;
• Work with Oracle Support: create SRs (Support Request) for issues and incidents;
• Create shell scripts to monitor GoldenGate status, auto-detect discarded records, and file maintenance;
• Interact with business analyst and application developer to ensure the overall system design to meet the business requirement;
• Adopt DevOps to enhance the product delivery and service speed.
• Use JIRA to management project and tasks; Use Confluence for the documentation.
• Coordinate efforts of capacity planning, application team, DBA, decision support team and Teradata team for releases, change request and new projects.

Confidential - St. Louis, MO

Senior IT specialist/Oracle Application DBA

• Manage a load testing project for HARVEST application and Crop Data Warehouse;
• Conduct performance tuning for Remedy in its major version upgrade from 7.5 to 8.1;
• Improve Business Objects performance by making recommendations on resizing the SGA (memory management), SQL query tuning (explain plan, profile, index, partition), SQL tracing and TKPROF, statistics gathering, and job scheduling;
• Help Mexico team improve database performance by fixing long-running queries on Exadata for mission critical applications;
• Upgrade WebLoad Console and WebLoad Generator on production servers;

Confidential - St. Louis, MO

Senior Oracle DBA

• Manage ASM project: Converted all databases from the legacy storage filesystems (raw device) to Automatic Storage Management (ASM) including coordination, engineering, testing, implementation and documentation.
• Engineer a project: Upgraded databases from 10g/11gR1 to 11gR2 including upgrade testing, performance testing, troubleshooting and documentation.
• Maintain and apply current industry best practice, trends and policies.
• Coordinate capacity planning, network, system admin, storage, and project manager on new projects.
• Install database binary and create new database.
• Regular security patching (PSU quarterly) on databases including test environment setup, shell scripting, binary preparation and PSU implementation.
• Work with Oracle Support for trouble-shooting: create SRs (Support Request) for issues and incidents including generating and analyzing RDA, AWR, ASH, and ADDM report.

Confidential - St. Louis, MO

Oracle System DBA

• Support large-scale, highly complex databases (RAC and HA environment).
• Install and configure Oracle RAC in UNIX and LINUX.
• Setup physical and logical standby databases.
• Install new database binary and create new databases.
• Performance tuning using OS monitoring tool, RDA (top wait events), SQL tuning (explain plan, profile, index, partition), SQL tracing and TKPROF.
• Work with Oracle Support to engage, manage and escalate SR in Oracle support to analyze and resolve issues, and fix bugs.
• Apply patches (mainly CPU) regularly, and evaluate/apply one-off patches on databases.
• Provide 24x7 production database support/maintenance via on-call rotation.
• Coordinate system admin, storage, network, project managers, and clients on capacity, hardware and software planning.

Confidential - St. Louis, MO

Oracle DBA

• Develop Oracle Forms and Oracle Reports.
• Work on the data warehouse project, database design, PL/SQL procedures.
• Perform application object level tuning including query structure, and table index.
• Support and use Oracle Express and Discovery for data analysis and reporting.

Confidential - St. Louis, MO

Engineer

• Design the Genesis database to store information for ingredients and nutrition labels.
• Develop the Oracle reports.
• Apply statistical methods to identify significant factors which have the most impact on the product quality.
• Manage product development process and ensure projects were completed in timely manner, and within the budget and scale.