Hao User

Analyzed, designed, and implemented RMAN-based backup and recovery strategies for Oracle databases, ensuring business continuity. Led AWS RDS MySQL upgrade migrations and leveraged Git and Ansible for automation of DBA tasks and DevOps practices. Managed and maintained MS SQL Server databases, implementing high availability solutions and migrating Oracle and PostgreSQL databases to AWS.

Provided on-call support for production Oracle RAC/ASM environments and implemented DR solutions using GoldenGate and Data Guard. Migrated databases to AWS-managed services like RDS and Aurora, ensuring minimal downtime and high availability. Optimized query performance and administered Amazon Redshift clusters, integrating with S3 and Glue for analytics.

Supported Oracle RAC/ASM environments, performing migrations and upgrades, and configuring Data Guard for disaster recovery. Utilized GoldenGate for heterogeneous data replication and integrated Snowflake for cloud-based ML/AI projects. Administered MongoDB and Redshift, automating DBA tasks with Python and Shell scripts.

Supported OLTP and data warehouse databases globally, setting up RMAN backups, RAC, Data Guard, and TDE encryption. Conducted zero-downtime rolling upgrades using GoldenGate and integrated Oracle Audit Vault for security. Automated CI/CD pipelines with GitHub and Jenkins, deploying PostgreSQL in Docker with HA.

Explored business opportunities with local organizations and managed after-school enrichment programs and holiday camps. Developed engaging projects for a full immersion Chinese curriculum. Contributed to the growth and educational quality of the Chinese section.

Performed data mapping utilizing star schema and designed ETL architecture using SSIS for data migration. Analyzed and optimized SSRS reports, providing production support to Tableau users. Designed and managed indexes to improve query performance and worked with Informatica for ETL processes.

Coordinated with business users to transform requirements into technical specifications and conducted test script reviews. Implemented indexes and partitions for performance tuning, optimizing existing queries and stored procedures. Worked with SSIS for ETL processes and utilized TFS for project version control and change management.

Communicated with business stakeholders to translate requirements into technical specifications and created comprehensive design documents. Performed data cleaning and optimized existing queries and stored procedures. Designed ETL packages using SSIS and developed on-demand and scheduled reports with SSRS.

Studied the fundamentals of computer science including programming languages, data structures, and algorithms.