Amy Yang Email & Phone Number

Austin, Tx, Us

Remote

Fort Worth, Texas, United States

• Installed 12R1,12R2,18C binaries and created databases (production/QA/Dev) for Linux in different platform (Linux, AIX, Solaris, Windows, AWS). • Restore and recovery database to new host for disaster recovery testing in global site (Fort Worth, Atlanta, Singapore, China etc.)• Refreshed QA/DEV using Data Pump for schema/full database and RMAN for full database from production database.• Configure Data Domain agent in Linux/AIX and triggered (Incr0, Incr1, Archive, Clean) Backup for database to Data Domain storage server.• Installed 9.2 postgres database and configure physical and logical backup for postgres.• Shell script to create schema in catalog database and register database in catalog db for various platform (Linux, Solaris, AIX).• Upgraded 9.6 postgres db to 10.6 postgres db in Linux environment by pg_dump.• Familiar with point in time recovery in postgres db from pg_backup.• Refreshed QA/DEV using Data Pump for schema/full database and RMAN for full database from production database.• Expertise in migration upgrade Oracle databases from 12R2 to 18 using Datapump/Rman active duplicate.• Familiar with SRVCTL and CRSCTL to implement RAC environment activities.• Patched more than 40 databases (11g/12c) using Patch Set Updates (PSU) /Critical Patch Update (CPU) and troubleshooted problem during the patch.• Installed and configured 12c/13c Oracle Enterprise Manager (OEM) and monitored top wait events /top SQLs/ top sessions using OEM.• Administered Oracle ASM disk groups (mirroring, stripping) with Command-line Utility (ASMCMD). • Involved in planning, installing, configuring, and administering 2 nodes RAC database and single instance database in AIX/Linux/Exacc. • Created user accounts, roles and granted required access permissions and privileges to the database based on the applications accessed.

Dearborn, Mi

• Expertise in migration upgrade Oracle databases from 11.2.0.4 to 12.1.0.2 using Datapump/Rman active duplicate.• Built more than 20 production/QA/Dev databases in different global plant and data center. • Performed database migration from non-Exadata to Exadata.• Configured Active Data Guard / Physical Standby on single instance and Rac environment for 11.2.0.4 and 12.1.02.• Worked as production support included receiving email alerts, attending production calls, troubleshooting emergent issues when oncall.• Created and tested two scripts for collecting stats for schema/full level of 11g/12c databases and purging audit files in the different environment.• Familiar with Automated Workload Repository (AWR) and Active Session History (ASH) for performance tuning of Oracle database.• Performed Oracle database storage migration from Non-ASM to ASM with RMAN.• Installed and configured 12c/13c Oracle Enterprise Manager (OEM) and monitored top wait events /top SQLs/ top sessions using OEM.• Administered and managed OCR (Oracle Cluster Registry) including manual backup of OCR and design the recovery strategy of OCR. • Involved in maintenance activities and troubleshooting Golden Gate issues such like abended, lagging, long transaction issues.• Created scripts for managing day-to-day activities and incremental and full image backup automatically in Cron.

Bryan/College Station, Texas Area

• Involved Installation, configuration, maintenance, and support of Oracle 11g / 12c database in in Linux/Unix.• Configured and maintained physical Data Guard. (RAC to RAC, RAC to single instance, single instance to ingle instance).• Worked on Data Guard configuration and activities like Switchover and Failover. • Installed, configured Golden Gate to replicate data from OLTP to Data warehouse. • Resolved all sort of Golden Gate abend/latency issues.• Performed database administration tasks like tablespace usage, checking alert log, trace files, monitoring disk usage, table reorganizations, online segment shrink, index rebuilds.• Migrated oracle large databases (15TB) cross platform from Solaris to Red hat Linux using transportable tablespaces / Golden Gate to reduce downtime.• Monitored database performance in OEM 12C and generated AWR and ASH report. • Configured job schedule to automate routine administrative tasks in Cron.• Created RMAN repository and configured RMAN full/incremental backups. • Using shell scripts on Crontab to monitor database in case of OEM crashed.• Maintained a regular project planning, review and meeting schedule with team, peers, manager, and clients.• Performed day-to-day database administration tasks like table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, full and incremental database backup. • Created users and granted them the required roles and privileges accordingly.