Alois Hoo Ziming

Go-live CAT 1 Project:

• Perform monthly setup, upgrades and maintenance of Vmware environment encompassing Exsi virtual machine management including snapshots. Proficient in tasks such as VM provisioning and migration as well as ensuring license compliance through use of RVtools.
• Broadcom-Symantec set up for RHEL servers and windows push down (Manager), antivirus, sylink
• Provisioned and upgraded storage systems in collaboration with vendors, including Hitachi, Data Domain (Dell), and Veeam backup and recovery solution.
• Installed and collaborated with vendors for PKI, facilitating the transition from smart card to YubiKey in Windows and RHEL production servers.
• Maintained and installed encryption software, such as SecurAge, Luks, and BitLocker.
• Conducted equipment site survey to compare current and proposed server and network setup for migration.
• Managed sever patch process using WSUS app, RHEL satellite, and ansible (User).
• Worked in collaboration with the network team to efficiently provision vLan and establish network connectivity.
• Managed and administered project infrastructure, including handling service request duties as a System Administrator for Active Directory user management.
• Implemented installation of 2nd AD replication server along with advanced security measures and system setup.
• Worked collaboratively with STE to ensure efficient management of data diode, Nxlog, and Opswat.

Collaborated with multiple organizations for seamless integration projects, including MyID + Entrust CA + Luna Thales HSM and Oracle OUD installation.

NOC-NLB:

• Configured and set up eG monitoring, overseeing the onboarding of NLB servers for enhanced oversight.
• Upgraded Solarwinds, renewed eG license, and upgraded Hitachi S11
• Vulnerability management in terms of implementing solutions- TLS upgrade
• Duties and responsibilities include handling incidents based on priority.
• Obtained certification as an AWS certified cloud practitioner
• Ensured efficient CloudWatch monitoring and timely resolution of incidents in AWS
• Utilized AWS to deploy new instances and incorporated sysprep for efficient operation.
• Worked closely with developers to ensure successful production deployments

Database Management:

• Managed and optimized MSSQL and Oracle 19c databases with proficiency.
• Established triggers for efficient monitoring of insertions, updates, and deletions in MSSQL database.
• Implemented high availability and disaster recovery solutions for MSSQL, such as replication and AlwaysOn configurations.
• Developed and implemented MSSQL stored procedures for efficient scheduled data extraction.
• Implemented proactive measures to monitor and maintain the efficiency of Oracle 19c databases. This involved managing available disk space, troubleshooting session blocking problems, and conducting regular RMAN backups.
• Executed Oracle 19c patching proficiently, including OJVM, database, and OPatch.
• Scripted tablespace management, RMAN restoration, and backup scripts for Oracle 19c databases to enhance database efficiency and reliability.

IT process documentation:

• Led documentation and patching for various systems including RHEL 7 &8, Win 2012/2016/2019, Oracle Database 19c, Oracle OUD, Java, MSSQL, OLEDB, ODBC, Apache-Tomcat, OCSP-Axway, and Symantec Endpoint Protection.
• Created and maintained documentation for all processes and procedures in the department.

Security and System Management:

• Conducted regular vulnerability assessments through Nessus scans, resulting in the timely remediation of security vulnerabilities.
• Addressed security vulnerabilities in Nexus CA by implementing Microsoft KB5014754 workaround.
• Splunk, Tenable Nessus, and PKI (HID, LDAPadmin, CA operator) utilized proficiently for conducting security analysis, ensuring compliance and optimizing product usage.
• Handled patching and updates of various operating systems including Red Hat Enterprise Linux 7&8 as well as Windows 2012/2016/2019. Also managed updates for Oracle databases such as Oracle 19c and Oracle OUD.

Client and Vendor Collaboration (Project):

• Collaborated with multiple organizations for seamless integration projects, including MyID + Entrust CA + Luna Thales HSM and Oracle OUD installation.

• Provided weekly project updates and conducted monthly Account Reviews for MCCY and NAC under NLB
• Explore proof of concept and setup of new projects and POC for vendors
• Managed Oracle 11g & SQL Server environments, including patching, hardening, and performance tuning
• Executed data and schema extraction as per client requirements and facilitated data exports in CSV format from MSSQL
• Conducted migration activities from Oracle 11g to SQL Server 2019 using SSMA
• Implemented authentication, authorization, and upgrades for SQL Server instances
• Administered tasks related to logins, log shipping, mirroring, replication, and HA/DR for SQL servers
• Handled service request System Administrator duties, including Active Directory user management and DNS records administration
• Upgraded Splunk forwarder and Splunk Enterprise versions, managed 2FA token activations, and handled server account reviews
• Liaised with vendors for system-related activities like Commvault tape changes, 2FA token activation (Digipass-Vasco), and Nessus-recommended actions
• Conducted Windows OS upgrades and collaborated on GCC migration activities
• Carried out various ad-hoc tasks, including collecting file information, collating LDF files for point-in-time restores, and supporting MCCY B2 migration and intranet system meetings.

• Took ownership upon joining, achieving a 100% PM success rate in 2020, recognized in statistics and director appraisals
• Extracted data from Tableau, creating impactful PowerPoint presentations utilizing SPC charts to identify root causes in collaboration with process and equipment engineers
• Managed 7 defect inspection tools, collaborating with vendors to enhance capabilities and performance, particularly in brightfield and darkfield tools
• Executed PM on photolithography module tools like CLEAN TRACK ACT 8, TEL MARK 8, I-LINE, DUV scanner, and metrology tools from HITACHI and KLA Tencor
• Demonstrated above-par equipment uptime during line duty and efficiently troubleshooted machine issues to maintain operational efficiency
• Applied critical and analytical thinking to identify and replace faulty parts, conducting diagnostic and troubleshooting activities for line tools
• Proficient in performing basic resets and handover presentations through statistical charts and data analysis
• Assisted in implementing leak-proof systems and adopting new technologies like AI to address critical line issues as requested by TSMC.