Summary
Overview
Work History
Education
Additional Information
Certification
Timeline
Generic

Desmond Ong Poh Chuan

Summary

29 years of database administrator


10 years DB2 udb


6 years of postgres edcb

6 years of Thales encryption

Overview

29
29
years of professional experience
1
1
Certification

Work History

DBA (MSSQL

EDBS
02.2020 - 04.2022
  • Security Clearance – CAT2
  • Perform Server Migration from Oracle 12 to MSSQL 2019 from DEV AWS Using Microsoft SSMA
  • Learning of new technology on Microsoft SSMA
  • Install MSSQL 2019 Enterprise for Oracle SSMA on DEV laptop
  • Migrate DEV Oracle to MSSQL 2019 using SSMA
  • Review baseline hardening on new SQL Server ORACLE client
  • Create procedure of how to manage SQL Server Migration Assistant (SSMA) Server and Azure SQL Database
  • Perform migration for Oracle DEV to DEV AWS cloud
  • Once completed, backup the database and restore to QA AWS
  • Review for Microsoft SQL Server 2019 baseline for DEV and QA
  • Review for Microsoft Window Server 2019 Baseline for DEV and QA
  • Testing connecting with MCC global protection for DEV and QA
  • Install MySQL and take backup and restore to MySql8
  • Install MSSQL 2019 Enterprise for MySQL Migration Assistant (SSMA)
  • Going for DSTA Cyber Threat Course

DBA (MSSQL

HCL
04.2021 - 04.2022
  • Security Clearance – CAT1
  • Perform Unit Disaster and Full Disaster for MSSQL Always On
  • Perform setup of new SQL Always on and Standalone with TDE encryption on MSSQL2019
  • Perform deployment for MSSQL and Oracle
  • Perform SQL Server upgrades and migration
  • Perform baseline hardening on new SQL Server
  • Troubleshooting control M backup failure on MSSQL Server and raising the necessary request to grant access to folder and troubleshooting backup failures and checking for successful backup
  • Troubleshooting Oracle log DG Data full, archiving Rman backup, raise ticket to add disk for DG DATA
  • Perform OS Patching support to bring up Oracle services and check if services are up
  • Ensure tickets are resolved and close on time
  • Trouble shooting access errors, working with users to solve their problems for MSSQL and Oracle
  • Account management also work with PALM Privileged Account enrollment into Vault
  • Backup and recovery of databases to different destination
  • Perform duty role to the best of our abilities.

DBA

04.2013 - 04.2018
  • Perform setup of new SQL Always on and Standalone with TDE encryption on MSSQL2016
  • Perform deployment for MSSQL and Oracle
  • Deployment of tickets and update the ITSM
  • Help to setup, install Sybase 15.6 and migrate database from V12 to V15
  • Help to troubleshoot for Informix
  • Setup new instance for Informix
  • Setup new SQL for projects and hardening for DSTA
  • Work with users to troubleshoot issues related with databases
  • Helping to perform deployment for Oracle V12 systems
  • Troubleshooting Oracle deployment errors.

Senior SQL DBA

Prudential Services Pte Ltd
09.2011 - 08.2017
  • DBA
  • Health check for production SQL server version 2008R2/SQL2012/SQL2014/SQL2016
  • Migration of legacy server MSSQL databases to latest version of VM SQL2012/2014/2016
  • Setup Reporting services
  • Working with SCCM team to setup SECOM to monitor database status
  • Troubleshooting production issues using system task monitor and sql profiler
  • Setup standalone VM MSSQL and MSSQL cluster servers mirroring using domain login with best practices and updated patch version
  • Setup agent jobs
  • Using Windows SCCM to automate SQL GDR and CU as well as regular service patches
  • Monitoring of performance degradation using BMC for fine tuning
  • Surrendering privileged account to vault
  • Attending Azure SQL Always-ON workshop
  • Coaching new junior joining to the team
  • Perform DR recovery at DR site
  • Responsibilities: POSTGRES DBA
  • Setup new standalone and cluster postgres database server using best practices
  • Setup of auto deployment for deployment team to take over
  • Config and fine tuning of postgres.cfg
  • Setup PGadmin console to monitor database status
  • Surrendering privileged account to vault
  • Setup new template of updated version of Postgres with latest patches and hardening
  • Perform update patches for databases
  • Coaching new junior joining to the team
  • Perform DR recovery at DR site
  • Thales Encryption Admin
  • Setup new policy according to Regional Security team request form
  • Encryption of databases and file servers’ support
  • Fine tuning of permission issues with support and review policy with Security Admin
  • Troubleshooting of performance issues with support and review policy with Security Admin
  • Update software agent and console version
  • Sending privileged account to vault
  • Coaching new junior joining to the team
  • Perform DR recovery at DR site.

DBA (MSSQL

Enggol Engineering IT
06.2002 - 02.2013
  • Security Clearance – CAT2
  • DB2 fail over to cluster when disk used up on data folder
  • Took backup on active node and restore fail over for the database
  • MSSQL server transaction log backup house keep as data folder is stored with data
  • And shrink the the log to release the space
  • Take monthly space of 2 servers
  • Assisting with colleague to raise documents for CAB meeting
  • Patching MSSQL servers clusters always on nodes

DBA

NCS
05.2001 - 08.2010
  • MSSQL DBA
  • Health check for production SQL server version SQL 2000/2005
  • Migration and upgrade of legacy server MSSQL databases to latest version of SQL 2005
  • Troubleshooting production issues using system perfmon and sql profiler
  • Setup new standalone MSSQL and MSSQL servers clusters using best practice and domain login
  • Monitoring of performance degradation using BMC for fine tuning
  • Patching latest service packs and security patches
  • Perform DR recovery at DR site
  • Responsibilities: DB2 DBA
  • Health check for production DB2 versions 9.1/9.7
  • Troubleshooting production issues reviewing system logs
  • Setup new standalone DB2 and cluster DB2 servers mirroring using best practice procedure
  • Monitoring of performance degradation using BMC for fine tuning
  • Patch latest database version
  • Perform DR recovery at DR site.

Education

Higher Diploma - Computer Science

Staffordshire University
Dec 1999

Diploma - Computer Studies

NCC International Centre
Dec 1993

Additional Information

  • AWARDS , Difference in Quality – Singapore eCustoms -PRSIM project NCS Making IT Happen Team award – IRAS Integrated Network Project NCS Service Excellence Award – IRAS Company: GIC Period: 23 April 1999 to 09 May 2001 Position: Operation Assistant Responsibilities: ORACLE DBA Health check for production Oracle 7.1 Troubleshooting production issues reviewing system logs

Certification

Iras service leadership

aws education

Timeline

DBA (MSSQL

HCL
04.2021 - 04.2022

DBA (MSSQL

EDBS
02.2020 - 04.2022

DBA

04.2013 - 04.2018

Senior SQL DBA

Prudential Services Pte Ltd
09.2011 - 08.2017

DBA (MSSQL

Enggol Engineering IT
06.2002 - 02.2013

DBA

NCS
05.2001 - 08.2010

Higher Diploma - Computer Science

Staffordshire University

Diploma - Computer Studies

NCC International Centre

Similar Profiles

CREATE PROFILE
Desmond Ong Poh Chuan