Alan Wang

. Comprehensive knowledge on all major Oracle DB products version, 11g/12c/19c/23i, Autonomous DataBase(ADB) etc.

. Strong performance tuning experience regarding on DB system level, SQL level and application side, hands-on problem diagnosing issue, with varies tools such AWR, ASH, ADDM, SQLHC, SQL profile etc.

. GoldenGate exposure to set up one-way/bi-way communication with integrity mode, microservice mode.

. In-depth Data movement/restore recovery with GoldenGate, RMAN backup/restore to move DB level, TBS level, Schema Level, as well as ad-hoc data movement with expdp/impdp, CTAS tools, and trace/alert log archiving with Pipeline.

. Comprehensive experience on configuring High-Availability with Oracle RAC, ASM, DataGuard.

. Data Encryption solution to protect data in transit, at network level, at storage with Transparent Data Encryption.

. Manage User security to apply data restricted access (ACL), manage resources(DBRM) more efficiently like from runaway SQL.

. Experience with shell, awk, Python tools on Linux to automation, simplify daily automation works,

. Strong knowledge on SQL/PLSQL scripting, tuning and diagnosing issue with inefficient coding.

. Apply monthy/quartly patch (PSU, CPU) and ad-hoc patch.

. Certified with Oracle OCP, Oracle Cloud Infrastructure (OCI) professional, Autonomous Database (ADB) professional, Agentic AI professional.

. exposure to other common tools, platform: Ansible, Github, Linux, Shell scripting, awk, Python, Visual Studio Code etc.

. Provided high-quality SaaS service of Oracle Cloud Fusion Application for Oracle's thounsands clients across world, tuning the application peformance and worked with Fusion module team(Finance, Human Resource,Supply Chain and BIP etc) for better performance and fix defects.