Amy Yang Email & Phone Number

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).

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.

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.