Summary
Overview
Work History
Education
Skills
Experience Summary
Timeline
Generic

Alex Cai

San Ramon,CA

Summary

Accomplished Oracle Database Administrator with 8+ years of hands-on experience providing 24/7 support for mission-critical OLTP production systems, development environments, and enterprise implementations in on-premises, hybrid, OCI, and AWS environments. Expertise in database installations, upgrades, migrations, patching, cloning, and performance tuning across Oracle versions from 10g to 19c on multiple UNIX and Linux platforms. Have deep knowledge of PL/SOLRMAN, RAC,ASM, DataGuard, GoldenGate, OEM, Exadata, weblogic, OCI, SQL Server/Azure, PeopleSoft PeopleTools. Proficient in Oracle Enterprise Manager (OEM) 12c/13c, RMAN cloning,skilled in diagnosing and resolving performance issues, optimizing large-scale database systems, and automating database tasks using Shell scripting and Ansible.Have impeccable communication and interpersonal skills and an excellent team player.

Overview

7
7
years of professional experience

Work History

Senior Oracle Database Administrator

Gap Inc.
Pleasanton, CA
10.2021 - 11.2025
  • Responsible for building, configuring, maintaining, patching and upgrading the database servers.
  • Manage and provide 24x7 support for multi-terabyte Oracle 12c,19c,23c databases in RAC and standalone environments on Linux servers.
  • Hands on Oracle on Amazon RDS (backup/recovery workflows, parameter/option groups, performance troubleshooting).
  • UPerformed upgrades and cross-platform migrations of 100+ databases from Oracle 12c to 19c, from AIX to Linux VM.
  • Designed, managed and, Automated RMAN backup/recovery strategies (Level 0/1, block change tracking, catalog-based backups)and
  • Experience on Data Pump export/import processes, enabling rapid environment refreshes for dev/test teams.
  • Supported Active Data Guard for real-time disaster recovery and read-only reporting. Monitored log shipping and applied lag metrics,reducing primary database load by 40%.
  • Set up and maintained OEM for centralized monitoring, alerting, and performance diagnostics.
  • Tuned database performance using AWR, ASH, ADDM, SQL Monitor, and SQL Plan Management. Optimized high-cost SQL through SQL Profiles and PL/SQL code improvements.
  • Managed Oracle 12c/19c RAC/DataGuard environment for payroll and customer service applications handling 5M+ records
  • Designed and deployed databases, working closely with system designers and developers.
  • Configured Oracle Wallet Manager for managing HTTPS certificates and set up ACLs in Oracle 11g/12c to enable secure and controlled database access to external services such as SMTP and HTTP.
  • Setup Oracle Golden Gate (OGG) for large database migration. Configure manager, extract, data pump and replicate. Trouble shooting ggs process abend, out of sync, check ggserr.log and use ggsci view report. Effectively decrease OGG lag by using heartbeat table, split function, batchsql, OGG parameter.
  • Administered WebLogic Server 12c for APEX, Banner, and custom PL/SQL applications; managed OHS configurations and cluster environments.
  • Assist with estimates of system capacity to meet near and long-term processing requirements.
  • Optimized critical queries and indexes, decreasing average report execution time by 55% and saving ~$180K annually in compute costs.
  • Performed database capacity planning and managed ASM storage, including requesting additional space and adding new disks to ASM disk groups to support performance and scalability needs.
  • Backup of SQL Server databases using SSMS include full backup and incremental backup as daily bases.
  • Refresh of SQL Server databases from PROD to DEV/QA/TST using SSMS.
  • PeopleSoft management (Application server and PIA), PeopleTools upgrade, PUM image upgrade.
  • Created and managed ServiceNow tickets (incidents, changes, requests) and actively contributed to CAB (Change Advisory Board) reviews.
  • Collaborated with application and DevOps teams to integrate database changes via Liquibase/Flyway in CI/CD pipelines.

IT Specialist Oracle Database Administrator

Raley’s IT Department
Sacramento, CA
06.2019 - 08.2021
  • Managed various database structures: Tablespaces, data files, control files, redo log and archive log files using OEM, GUI tools and command-line.
  • Created, maintained, managed, and monitored several databases by using Data Guard oracle databases to avoid disasters and corruption of data.
  • RMAN level 0, 1, and 2 backups, Full backup and Incremental backup and database recovery.
  • Discover new database from Oracle Enterprise Manager (OEM), setup RMAN backup and lifecycle, configure agent, and setup metrics to monitor database performance
  • Upgraded from 11g to 12c, and implemented oracle database 11g/12c to 2 nodes Real Application Cluster (RAC) by using oracle cluster ware for achieving high availability on ASM
  • Oracle Wallet Manager for HTTPS certificates and Oracle 12c, 11g ACL features for SMTP, HTTP, etc.
  • Perform database maintenance tasks, such as backups, restoration, tuning, and upgrades.
  • Troubleshoot and resolve database issues in a timely manner.
  • Perform routine, day-to-day database administrator duties and observe more senior database administrators to build skills in data modeling, SQL and PL/SQL tuning, application tuning, creation of database objects, data modeling, utilities, Linux commands.
  • Involved in 24/7 on call support for both production and development databases including a 2-node production RAC database.

Software Development Engineer

Raley’s IT Department
Sacramento, CA
08.2018 - 06.2019
  • Led development of the Internal Content Management System for business content creators and managers, handling full-stack responsibilities for web and mobile applications.
  • Designed and implemented front-end APIs, UI elements, and testing protocols to ensure seamless functionality and user experience.
  • Primarily responsible for the Internal Content Management System (full-stack), serving as the middle-layer between the business content manager and product inventory
  • Designed and implemented RESTful APIs for user authentication and data retrieval, utilizing Sequelize ORM to handle database migrations and ensure ACID compliance in transactions.
  • Assisted in migrating legacy SQL Server databases to PostgreSQL, writing scripts for data transformation and validation, minimizing downtime to under 2 hours.
  • Debugged and resolved database-related issues in production, such as deadlock scenarios in concurrent queries, improving system stability.
  • Performed database performance tuning, including query profiling and sharding in Redis for session management, which enhanced application responsiveness by 35% during high-traffic events.
  • Collaborated across teams with back-end engineers and DBA to gather business requirements and translate them into technical tasks, delivering efficient solutions.

Education

Bachelor of Science - Computer Science

University of California, Davis
05.2018

Skills

  • Database: Oracle Database/RAC 9i,10g,11g, 12c,18c, 19c, 23c, SQL Server Mysql
  • Platform: Linux,Solaris,IBM AIX,HP-UX,Exadata,OCI,Windows,Azure,AWS
  • High Availability / DR: RAC clustering, Active Data Guard, Fast-Start Failover, RMAN backups/recovery, Flashback, Zero Data Loss Recovery Appliance (ZDLRA)
  • Migration Tools: Datapump, Rman, Dataguard, TTS, Clone, Unplug&Plug, GoldenGate
  • Security: TDE (tablespace/column), Oracle Wallet, patching (RU/RUR/CPU)
  • Automation & Scripting: Bash/Shell, Python (cx_Oracle/oracledb), PL/SQL, Ansible, OEM 13c/Cloud Control
  • Monitor Tools: Oracle Enterprise Manager (OEM), AWR,ASH,ADDM,SCRIPS
  • OS/Platforms: Linux (RHEL/OEL 7/8/9), Solaris, Windows Server
  • Middleware: Weblogic/Tomcat
  • Development skills: HTML, CSS, React (with Hooks), React Native, Redux, jQuery, Bootstrap, Nodejs, Expressjs, Babel, WebPack, RESTful APIs,Material UI

Experience Summary

  • Over 8 years extensive experience in the Information Technology industry, especially in Oracle Database (10g/11g/11gR2/12c/18c/19c, 21c/23a,i) in Oracle Linux, AIX, Solaris platform.
  • Oracle database related software tools installation/configuration, including Database, RAC, DataGuard, Rman,OEM,Goldengate,Weblogic, Exadata.
  • Upgrade Oracle databases from 10g, 11g to 12c/18c/19c, and quarterly PSU Patching.
  • Rman backup & recovery with/without catalog, full/incremental backup, cold and hot backup/recovery.
  • Merging on-premises database into cloud-base AWS database service using a combination of AWS services, primarily the AWS Database Migration Service (DMS) and the AWS Schema Conversion Tool (SCT)
  • Migrating Oracle databases in the same server or between different servers using Data Pump, Transportable Tablespace(XTTS), Rman Duplicate, Golden Gate utilities. Migration to Cloud, include Oracle to OCI, SQL to Azure, migration to AWS RDS, AWS Management Console, (SCT) AWS Schema Conversion Tool, Cloudwatch.
  • RAC (Real Application Cluster) 11g/12c/19c High Availability setting up, use command line utilities SRVCTL, CRSCTL, ASMCMD. Resolve RAC issues, Node issues, OCR related issues, ASM issues. Apply rolling patches for GI and databases.
  • OGG (Oracle Golden Gate) 11g/12c/19c setup for large database migration, or loading data from front end OLTP to back end data warehouse.
  • Security management using TDE (Oracle Wallet Manager) for HTTPS certificates and ACL features.
  • Storage capacity management using OEM/Scripts to monitor tablespaces and add space once needed.
  • OEM Monitor tool 11g Grid Control,and 12C/13C Cloud Control installation and administration.
  • Data Pump Export/Import to refresh schemas and tables.
  • Clone database using Rman Duplicate/ Dataguard, or Hot clone PDB.
  • Trouble-shooting Database, RAC, DataGuard, Rman, OEM, Goldengate, Weblogic/Tomcat.
  • Performance tuning of Oracle database using OEM/AWR/ADDM/SQL Profile/SQL Baseline/SQLT. And SQL Tuning Advisor using Optimizer to choose a best plan (CBO/RBO), Execution Plan to do SQL Tuning and SQL code rewrite.
  • WebLogic Server 12c includes HTTP(OHS) Server maintenance. Upgrade and Migration. Manage Nodemanager Admin Server and Managed Servers, Weblogic Console, Weblogic Cluster management.
  • Exadata Machine architecture and features like Flash cache, Storage Index, HCC and IORM, Exadata hardware like Luns, Cell Disk and Grid disk. Use CELLCLI and DCLI to control Storage Server Cells. Exadata Patching (DB server, Storage Server, IB Switch, Bundle Patching).
  • Experience with SQL, PL/SQL coding, stored procedures/functions/packages, triggers. Writing SQL or PL/SQL scripts to monitor database performance, Rman backup, Goldengate, OEM, etc.
  • Using Bash Shell and Perl scripts to enable auto management / monitoring.
  • PeopleSoft Management, peopleTools upgrade, upgrade PS2/PS3, upgrade PUM image.
  • Provided 24x7 on-call supports.

Timeline

Senior Oracle Database Administrator

Gap Inc.
10.2021 - 11.2025

IT Specialist Oracle Database Administrator

Raley’s IT Department
06.2019 - 08.2021

Software Development Engineer

Raley’s IT Department
08.2018 - 06.2019

Bachelor of Science - Computer Science

University of California, Davis
Alex Cai