Emma C.
Oracle Database Administrator @Charles Schwab
Signup · Get unlimited contacts
WORK HISTORY
Oracle Database Administrator @Charles Schwab
Provided 24x7 operational support for multi-terabyte Oracle 12c, 19c, and 23c databases in both RAC and standalone environments on Oracle Linux platforms.• Led the upgrade and cross-platform migration of Oracle databases from 12c to 19c, including transitions from AIX to Linux virtual machines and conversions from non-CDB to multitenant (CDB/PDB) architecture.• Installed and configured Oracle database environments; applied quarterly PSU/CPU patches and conducted thorough post-patch testing and validations.• Migrated Microsoft SQL Server databases from versions 2016 to 2019/2021, including on premises to Azure Cloud transitions using Data Migration Assistant (DMA) and SQL Server, Management Studio (SSMS).• Designed and maintained robust RMAN backup and recovery strategies, including Level 0/1 incremental backups, block change tracking, and catalog-based backups. Performed point-in-time recovery and disaster recovery simulations.• Built and rebuilt Oracle standby databases using Data Guard Broker (DGBROKER) and configured Fast-Start Failover (FSFO) in clustered RAC environments.• Supported NoSQL databases, assisting with connectivity, access control, monitoring, and basic performance troubleshooting.• Supported Oracle Active Data Guard configurations for real-time replication, high availability, and read-only reporting; monitored log shipping and apply lag performance metrics.• Refreshed development and QA environments using RMAN Duplicate and Data Pump export/import utilities.• Set up and maintained Oracle Enterprise Manager (OEM) for centralized monitoring, alerting, and performance diagnostics across enterprise systems.• Performed advanced performance tuning using AWR, ASH, ADDM, SQL Monitor, and SQL Plan Management. Optimized SQL performance using SQL Profiles, Baselines, and PL/SQL code tuning.
EDUCATION
South China University of Technology
Bachelor's degree
ABOUT EMMA C.
8 years of extensive experience in the Information Technology industry, specializing inOracle Database administration across versions 9i to 19c, and environments including OracleLinux, AIX, and Solaris.• Proficient in the installation, configuration, and administration of Oracle-related componentssuch as Oracle Database, Real Application Clusters (RAC), Data Guard, RMAN, Oracle Enterprise Manager (OEM), GoldenGate, WebLogic Server, and Exadata.• Skilled in performing database upgrades from Oracle 10g /11g to 12c/18c/19c, including application of quarterly Patch Set Updates (PSUs).• Expertise in RMAN backup and recovery strategies, both with and without recovery catalog, including full/incremental, hot, and cold backup and restore processes.• Experienced in database migration within the same server or across different platforms usingData Pump, Transportable Tablespaces (XTTS), RMAN Duplicate, and GoldenGate. Cloud migration experience includes Oracle to OCI, SQL Server to Azure, and Oracle to AWS RDS. Using tools such as AWS SCT, CloudWatch, and AWS Management Console.• Advanced knowledge in configuring and managing Oracle Data Guard (standby database), including DG broker setup, switchover/failover operations, and resolving sync/lag issues.• Expertise in setting up and managing Oracle RAC ( 11g /12c/19c) for high availability. Skilled introubleshooting RAC node failures, OCR and ASM issues, and applying rolling patches using SRVCTL, CRSCTL,and ASMCMD.• Strong hands-on experience with Oracle GoldenGate ( 11g /12c/19c) for large-scale databasereplication and ETL processes from OLTP to data warehouse systems. Capable of resolving abends and synchronization issues.• Proficient in implementing security using Transparent Data Encryption (TDE), Oracle Wallet Manager, and Access Control Lists (ACL) for secure communications and data access.• Effective in managing storage capacity using OEM and custom monitoring scripts for tablespacemonitoring and expansion.• Experienced in Oracle Enterprise Manager 11g Grid Control and 12c/13c Cloud Controlinstallation, configuration, and administration.• Skilled in using Data Pump (Expdp/Impdp) for schema/table refreshes and database cloning viaRMAN Duplicate, Data Guard, or PDB hot clone.• Strong troubleshooting capabilities across Oracle Database, RAC, Data Guard, RMAN, OEM, GoldenGate, and WebLogic/Tomcat environments.• Advanced performance tuning expertise using tools such as OEM, AWR, ADDM, SQL Profile,SQL Baseline, SQLT, Tuning Advisor. etc.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.