Experience Summary

A Graduate in Bachelor of Science (Computer Science) having 10+ years of work experience in the field of business software and database maintenance. Currently working as Database Administrator in a leading MNC company in Singapore for DBS Bank project.

Key Areas of Expertise:

• Database Administration / Installation -DB2 UDB
• Peoplesoft Administration / Installation
• People Tools upgrade
• Performance Monitoring & Tuning
• Unix Shell scripting

Job Title History

Period Appointment/Organization
Jul 2007 - Current Database Administrator cum Technical Lead/Confidential
Mar 2005 - Jun 2007 Database Administrator cum Technical Lead/Confidential
Jan 2002 - Feb 2005 Database Administrator cum Programmer/Confidential

Technical Summary

• Operating Systems: Sun Solaris, AIX, RHL
• DBMS: DB2 UDB V7.2, 8.2, 9.5, 9.7 on AIX/NT, Oracle 9.2, 10G on UNIX
• Software: Peopletools 8.2, 8.46, 8.47, 8.48, 8.50, 8.51
  PeopleSoft ERP Solutions HRMS 9.1, HRMS 8.9, FSCM 9.1, FSCM 8.9, LMS 9.0

Engagement Overview

Company : Confidential, Singapore
Project : Land Transport Authority, Singapore Dec 2011 - Till date
Role : DBA Expert
Team Size : 4
Domain : DB2 - UDB 8.2, 9.1, 9.7
Environment : AIX
Description : Database architect for DB2-UDB / PeopleSoft databasesDB2-UDB Administration Activities Installation and system designing for DB2 version upgrade

• Fixpak installation and DB2 migration
• Database mirroring
• Performance tuning
• Data migration
• Database monitoring and maintenance
• Created database manual to follow the best practices and naming standard
• Defined process for data migration
• Redesign the backup strategy
• Implemented maintenance scripts for (reorg, runstats, fixing inoperative views, log archival, backup)
• Implemented isolated permissions for the DBA IDs

Company : Confidential, Singapore
Project : DBS Bank Jan 2010 - Nov 2011
Role : DBA Expert
Team Size : 4
Domain : DB2 - UDB / PeopleSoft FSCM-PSGL, HRMS, ELM
Environment : AIX
Description : Database architect for DB2-UDB / PeopleSoft databases

Contribution

• PeopleSoft FSCM - Expense implementation (FSCM 9.1 MP2 ESA Bundle 5/PT 8.50.12 / DB2 9.5)
• People Tools upgrade 8.47 to 8.51
• Provided solution for database replication through HADR
• Scripts for log archival and space management
• 2FA authentication implementation
• Implemented database partitioning
• Implemented row level compression in DB2 UDB
• Provided solution for concurrency issue in DBS bank finance system
• Performance tuning across all DBS PeopleSoft applications

DB2-UDB Administration Activities Installation and system designing for DB2 version upgrade

• Fixpak installation and DB2 migration
• Database mirroring
• Performance tuning through indexing, data-compression, reorg / runstats, partitioning
• Data migration
• Database monitoring and maintenance
• Setting up federated environment across the base dataset and archival database

PeopleSoft Administration Activities

• Demo installation for PSGL and configuration for web, app, batch servers
• ML implementation for HRMS
• People tools patch upgrade
• Performance tuning for PeopleSoft applications
• LDAP implementation
• Online People book installation

Company : Confidential, Singapore
Project : Corporate Info System (Internal) July 2009 - Dec 2009
Role : Senior DBA
Team Size : 4
Domain : DB2 - UDB / Peoplesoft FSCM / Oracle
Environment : AIX / Solaris / RHL
Description : Maintaining all corporate databases on DB2-UDB / Oracle in AIX / Solaris / RHL

Contribution

• Standardize mailbox for issue tracking
• Knowledge sharing based on performance tuning
• Scripts and concepts for DB maintenance
• Segregate and maintain Organizational Process Assets

DB2-UDB Administration Activities DB maintenance

• Backup and recovery
• Data migration

Company : Confidential, Singapore.
Project : Corporate Finance System July 2007 - July 2009
Role : DB2 Specialist
Team Size : 7
Domain : DB2 - UDB / Peoplesoft FSCM
Environment : AIX
Description : Maintaining internal FSCM Peoplesoft system on DB2-UDB V9.5 in AIX platform

Contribution:

• Automated script to release the application deadlock
• Auto-script for data migration from production environment to UAT environment
• Scheduled and manage database native backup
• Scheduled for database maintenance and performance monitoring
• Generate report for database state, backup image status, tablespace usage

DB2-UDB Administration Activities

• DB2-UDB V9.5 installation & system design
• Version migration from DB2-UDB V8.2 to DB2-UDB V9.5
• Fixpak installation
• Performance tuning in DB2-UDB V8.2. (Proved 100% improvement to the performance of the system, based on benchmark review from the user)
• Technical refresh (Changing of production environment to new server)
• Performance tuning guidance for Home Land Security - Singapore
• HADR implementation
• Implementation of row level data compression
• Application tuning
• Prepared and formatted reports / documents for KPMG audit

Peoplesoft Administration Activities

• LDAP implementation
• Performance tuning
• Online help & people book installation
• Creating PeopleSoft environment (Application server, Process scheduler, Cobol compiler, Web-server)
• Appserver, Webserver tuning
• OLTP tuning
• Process tuning
• Ensuring 99.9% system availability throughout the year

Company : Confidential, March 05 - June 07
Project : Hewitt Associates
Project Title : WM Infrastructure support
Role : Senior DBA
Team Size : 7
Domain : DB2 - UDB v8.2
Environment : Sun Solaris
Description : This is an offshore project to develop Peoplesoft applications (HRMS module) for HEWITT clients. We are responsible for maintaining DB2 UDB Development and Production databases in UNIX platform and giving support for Peoplesoft issues. Handling OLTP database

Contribution:
UNIX Scripting Automation

• Multi functionality tool with scripts to do 1) Export 2) Import 3) Load 4) Killing Process 5) Fixing the views reduced the downtime by analyzing the output generated to list out the odd transactions and it is designed as an user friendly tool in such a way that it can be used by a non technical person
• To load the missed transactions at the time of deadlock in to transaction table in Client Environment. And it is implemented in production environment
• To merge the transactions into single file and transfer the file from application server to database server.
• To split the bulk file into several chunk of files and transfer to different server and make into a single file and also the script check the consistency of the file transferred.
• Generating report for database state, space usage, error log files, /var/adm/messages to know the system error & Current active log file details.
• Delete 3 days older archive log files and compress recently archived files.
• Multi functionality tool that identifies the table that needs reorg and reorg the specified table(s) and runstats to collect statistical information for the tables that are reorged.
• To delete two days older backup images.
• To make the inoperative views, operative and gives required permissions.

DB2 UDB - Administration Activities

• Data refresh from production environment to development environment databases
• Checking Database Backup images completion/failure status.
• Database administration
• Monitoring of error logs and issue fixing
• Tuning database configuration and DB manager configuration file
• Making inoperative views to operative
• Executing online system utilities (Reorg, Runstats, export, import, load etc)
• Monitoring the databases - for locks, deadlock, transactions log and Available page in tablespace.
• Organized backup strategy and ensure its availability for fast recovery - Online and Offline backup
• Restoring the backup - using with / without roll forward
• Redirect restore - using with / without roll forward

PeopleSoft Admin Activities

• People soft application server bouncing through Tuxedo
• JVM bouncing
• Message Handler bouncing
• Starting/Stopping process scheduler
• Creating new user id through PIA environment
• Running CDE (Common data exchange) app engine scripts
• Sending trace file.
• Running DMS script through People Soft Utility - Data Mover
• Clearing Cache

Company : Confidential Jan 02 - March 05
Project : Infrastructure
Role : Programmer / Database Administration
Team Size : 5
Domain : DB2-UDB / MS-Access
Environment : Windows 9x, NT, 2003, NT, RHL
Description : Educational institution. We are responsible for maintain all DB2 databases running in RHL / Windows NT platform

Activities

• Database maintenance
• Network maintenance
• Desktop support
• Antivirus maintenance
• Confidential Website maintenance

Company : Progressive Engineering Equipment Oct 01 - Dec 01
Project : Infrastructure
Role : Senior Programmer
Team Size : 5
Domain : VB6.0 / MS-Access
Environment : Windows 9x
Description : Manufacturer of Wet-grinders. Our team is responsible for maintaining all infrastructure databases (MS-Access) and VB6.0 applications running in Windows platform

Education

• B.Sc.(Computer Science)