Avery Yin

Senior Database Administrator nearly eight years of experience supporting and managing enterprise database environments, with extensive expertise in Oracle Database administration. Skilled in database implementation, production support, high availability, disaster recovery, performance tuning, upgrades, patching, and large-scale migrations across on-premises and cloud environments. Strong technical background in Oracle RAC, ASM, RMAN, Data Guard, GoldenGate, OEM, PL/SQL, and multitenant architectures.

Proven experience supporting mission-critical systems, resolving complex production issues, and collaborating with cross-functional teams to maintain database availability, performance, and reliability.

Sr. Oracle Database Administrator at AT&T (2023-04 – 2026-05)

Provided 24×7 production support for multi-terabyte Oracle 11g/12c/19c RAC and standalone databases across production and non-production environments on Linux, Solaris, and AIX platforms.

• Performed large-scale Oracle upgrades, quarterly PSU/RU patching, cross-platform migrations, database cloning, and environment refreshes using Data Pump, TTS/XTTS, RMAN Duplicate, PDB Hot Clone, plug/unplug methods, Database Links, and Oracle GoldenGate.
• Built and maintained Oracle Data Guard and Active Data Guard environments using Data Guard Broker and Fast-Start Failover (FSFO), including standby rebuilds, switchovers, failovers, archive gap resolution, and disaster recovery testing.
• Managed RMAN backup and recovery using Recovery Catalog, Level 0/1 incremental backups, Block Change Tracking, Point-in-Time Recovery (PITR), restore and recovery procedures, and backup validation.
• Administered Oracle RAC, Clusterware, and ASM environments using SRVCTL, CRSCTL, and ASMCMD, including rolling patching, node management, service relocation, cluster troubleshooting, and ASM disk group expansion.
• Configured and supported Oracle GoldenGate for large-scale database migrations and real-time replication; monitored Extract, Data Pump, and Replicat processes and resolved abends, replication lag, and synchronization issues using GGSCI and ggserr.log.
• Managed Oracle databases through OEM and diagnosed performance issues using AWR, ASH, ADDM, SQL Monitor, SQL Tuning Advisor, SQL Profiles, SQL Plan Baselines, Optimizer statistics, and Execution Plans.
• Implemented Oracle Database security using TDE, Oracle Wallet, HTTPS certificates, ACLs, user management, roles, profiles, and privileges.
• Supported Microsoft SQL Server and MySQL environments, including backup and recovery, database refreshes, upgrades, migrations, monitoring, performance troubleshooting, and production support.
• Administered Oracle WebLogic environments, including OHS, Node Manager, Administration Server, Managed Servers, WebLogic Console, clustered configurations, upgrades, migrations, and production troubleshooting.
• Supported PeopleSoft environments and underlying Oracle databases, including PeopleTools upgrades, PUM activities, database refreshes, patching, performance monitoring, and production support.
• Supported database workloads and migration activities across OCI and AWS environments, including database provisioning, backup and recovery, Amazon RDS, EC2, S3, and CloudWatch monitoring and alerting.
• Developed SQL, PL/SQL, Bash, KornShell, and Unix Shell scripts to automate database health checks, monitoring, RMAN backup validation, space management, maintenance, and routine administrative tasks.
• Supported Ansible-based deployment and configuration workflows for database provisioning, patching, configuration management, and repetitive administrative tasks.
• Supported production migrations and GO-LIVE cutovers, validating database services, TNS and SQL*Net connectivity, Database Links, scheduled jobs, application connectivity, and post-migration database health.
• Managed production incidents, change requests, and Oracle Support SRs while collaborating with application, middleware, cloud, infrastructure, storage, and network teams to resolve issues and meet SLAs.

Oracle Database Administrator at Aetna, a CVS Health Company (2020-01 – 2023-02)

Administered Oracle 11g/12c/19c databases across production and non-production environments on Linux, Solaris, and Windows platforms.

• Installed, configured, upgraded, patched, and maintained Oracle databases, including CDB/PDB environments and routine database lifecycle activities.
• Managed RMAN backup and recovery operations using full and incremental backups, Recovery Catalog, Block Change Tracking, Point-in-Time Recovery (PITR), and restore and recovery procedures.
• Performed database, schema, and table-level migrations, cloning, and environment refreshes using Data Pump Export/Import and RMAN Duplicate.
• Supported Oracle Data Guard environments, including Physical Standby database monitoring, switchovers, failovers, archive gap resolution, and disaster recovery testing.
• Monitored database availability, performance, and capacity using OEM, AWR, ASH, ADDM, Execution Plans, and SQL Tuning Advisor; investigated alerts, blocking sessions, resource utilization, and database performance issues.
• Supported Microsoft SQL Server, MySQL, and PostgreSQL environments, including backup and recovery, database refreshes, upgrades, migrations, user administration, monitoring, and production troubleshooting.
• Administered Oracle WebLogic and supported PeopleSoft application environments, including OHS, Node Manager, Administration Server, Managed Servers, PeopleTools upgrades, PUM activities, database refreshes, and production support.
• Developed SQL, PL/SQL, T-SQL, Bash, and Unix Shell scripts to automate database monitoring, maintenance, backup validation, health checks, and routine administrative tasks.
• Managed production incidents, change requests, and Oracle Support SRs while providing 24×7 on-call support for mission-critical database environments.
• Supported production migrations and GO-LIVE cutovers, validating database services, TNS and SQL*Net connectivity, Database Links, scheduled jobs, application connectivity, and post-migration database health.
• Managed production incidents, change requests, and Oracle Support SRs while collaborating with application, middleware, cloud, infrastructure, storage, and network teams to resolve issues and meet SLAs.

Database Administrator at TEK Systems (2018-10 – 2019-12)

Supported Oracle 11gR2/12c databases across client production and non-production environments, handling daily administration, monitoring, maintenance, and production issues.

• Participated in Oracle Database upgrades and migrations from 11gR2 to 12c, including pre-upgrade assessments, testing, validation, and post-upgrade support.
• Managed RMAN backup and recovery operations, including full and incremental backups, backup monitoring, database restores, and recovery procedures.
• Monitored database availability and performance using Oracle Enterprise Manager (OEM), AWR, ASH, ADDM, and Execution Plans; investigated database alerts, blocking sessions, space issues, and performance problems.
• Supported Oracle Data Guard Physical Standby environments, including standby monitoring, archive log transport, gap resolution, and disaster recovery activities.
• Performed database and schema refreshes using Data Pump Export/Import and supported routine database administration, including tablespace management, user administration, database objects, and scheduled jobs.
• Developed SQL, PL/SQL, and Unix Shell scripts for database monitoring, backup validation, space management, health checks, and routine administrative tasks.

Bachelors of science in Psychology – Arkansas State University