DB2 Database Administrator, DB2 Database Administrator, Database Consultant

Freelancer: (Last Two)
Client: ISSAC / MYSIG-ASIA
Task : Database Health Check, Db Con fig and Database migration issues.
Assisting with issues with the migration from Db2LUW 10.1 to 11.1 on Windows / Linux Platform
Technology used: Db2, Db2 Data Manager, DB2 HADR, Log Shipping, Linux, Windows
SQL Queries as per business request

Client: Das and Dasan
Task : Database migration and creating database objects according
to business requirements.
Technology used: Oracle, Linux, SQL Developer, Shell Scripting

Key Result Areas:
As Database Administrator (Cyberjaya)

* Responsible for:
* Designing, implementing & supporting DB2 database (9.1, 10.1, 10.5,11.1) in a Windows & Linux
environment; upgrading & keeping database environment up to date and patched as per required
standards & architecture
* Modifying database structures to support business needs as well as population and updating
database tables
* Maintaining architecture and design integrity throughout the application and database
implementation process, ensuring that log shipping is in place to keep disaster recovering in
sync with production and managing HADR (active and passive) environments and troubleshoot when
issues arise and setup cluster environment.
* Managing replication to keep data in sync for certain databases.
* Planning & establishing backup and restore strategies; writing scripts to maintain / monitor
databases & processors
* Executing & managing database security according company policy (create & maintain users, roles
and privileges)
* Undertaking activities related to:
* Troubleshooting of application issues in all environments
* Database capacity planning, database documentation, data migration, database reorganization
for DB2, testing and setting up database servers
* Capacity planning of the database growth and communicating the same to management
* Implementation of system changes (Database) when agreed upon
* Database installation, configuration and upgrade of DB2
* Creation of partitioning (DFP) for table structures
* Weekly reorg process and used of DB2 move, DB2_all, rah.
* Database security management.
* Liaising with developers, systems analysts, project managers & business owner regarding all
project initiatives
* Assuring databases operate at optimal level by monitoring and adjusting database structures
* Supervising database through shell and batch scripts and a range of tools
* Resolving system environment issues and relate to the team
* Looking after various functions such as:
* SQL Server reporting & MSMQ and SQL Server administration for 2008 & 2012
* SQL Jobs, 24x7 production support, DB job scheduler, database replication and split mirror
* Standard DB capacity management, tune database parameters, export/import data on request
* Oracle database administration and SQL, WSH & Shell Scripting
* Database security, migration of database, MYSQL Workbench and MYSQL Backups
* Installation of new DB version, limited to one version or release upgrade per year per DB
instance
* Documentation of all database servers & ERD diagrams; designing database structures
* Performance tuning and capacity planning using MySQL Enterprise Monitor
* Attending to any data related issues.
* Ensure Client trigger executed successfully and if issues resolve in timeously manner.
* Managing performance (physical DB configuration) and analyzing bottleneck resulting in
performance issues
* Extending logical DB support like creating database schema table and index creation
* Database documentation (ERD, procedures, backups, upgrade, restores))
* Handling MySQL configuration changes to optimize performance and resolve performance issues
* MySQL environment management
* Database security as per policy.
* Overseeing database backups and restore for oracle DBS using RMAN
* Accomplishing database security measures as well monitoring & controlling user access in line
with company standards
* Monitoring operational documentation including logical designs along with the database and table
implementation and designs for any new applications
* Developing of database triggers, store procedures to meet business requirements.




As Database Administrator

* Responsible for:
* Designing, implementing & supporting DB2 database (9.1, 10.1, 10.5,11.1) in a Windows & Linux
environment; upgrading & keeping database environment up to date and patched as per required
standards & architecture
* Modifying database structures to support business needs as well as population and updating
database tables
* Maintaining architecture and design integrity throughout the application and database
implementation process, ensuring that log shipping is in place to keep disaster recovering in
sync with production and managing HADR (active and passive) environments and troubleshoot when
issues arise and setup cluster environment.
* Managing replication to keep data in sync for certain databases.
* Planning & establishing backup and restore strategies; writing scripts to maintain / monitor
databases & processors
* Executing & managing database security according company policy (create & maintain users, roles
and privileges)
* Undertaking activities related to:
* Troubleshooting of application issues in all environments
* Database capacity planning, database documentation, data migration, database reorganization
for DB2, testing and setting up database servers
* Capacity planning of the database growth and communicating the same to management
* Implementation of system changes (Database) when agreed upon
* Database installation, configuration and upgrade of DB2
* Creation of partitioning (DFP) for table structures
* Weekly reorg process and used of DB2 move, DB2_all, rah.
* Database security management.
* Liaising with developers, systems analysts, project managers & business owner regarding all
project initiatives
* Assuring databases operate at optimal level by monitoring and adjusting database structures
* Supervising database through shell and batch scripts and a range of tools
* Resolving system environment issues and relate to the team
* Looking after various functions such as:
* SQL Server reporting & MSMQ and SQL Server administration for 2008 & 2012
* SQL Jobs, 24x7 production support, DB job scheduler, database replication and split mirror
* Standard DB capacity management, tune database parameters, export/import data on request
* Oracle database administration and SQL, WSH & Shell Scripting
* Database security, migration of database, MYSQL Workbench and MYSQL Backups
* Installation of new DB version, limited to one version or release upgrade per year per DB
instance
* Documentation of all database servers & ERD diagrams; designing database structures
* Performance tuning and capacity planning using MySQL Enterprise Monitor
* Managing performance (physical DB configuration) and analyzing bottleneck resulting in
performance issues
* Extending logical DB support like creating database schema table and index creation
* Database documentation (ERD, procedures, backups, upgrade, restores))
* Handling MySQL configuration changes to optimize performance and resolve performance issues
* MySQL environment management
* Database security as per policy.
* Overseeing database backups and restore for oracle DBS using RMAN
* Accomplishing database security measures as well monitoring & controlling user access in line
with company standards
* Monitoring operational documentation including logical designs along with the database and table
implementation and designs for any new applications
* Developing of database triggers, store procedures to meet business requirements.
* Participant in BAU (Business as usual).
* Involve in Charge Management.




As Software Test Analyst
* Handled activities related to:
* Development & execution of software test plans and analyzed test standards & procedures
* Analysis of regression testing using SAS
* Evaluated test results to ensure existing functionality and recommended corrective action
* Liaised with developers in resolution of problems and modified test system to prepare
implementation
* Looked after:
* Implementation of testing programs i.e. database impacts, software scenarios, regression
testing, negative testing, error or bug retests or usability and documented software defects
using a bug tracking system & reported defects to software developers
* Bug resolution efforts and tracked successes
* Execution of test schedules in accordance with project scope or delivery dates
* Evaluated product designs to provide input on functional requirements, product designs, schedules
or potential problems
* DB2 database monitoring (table functions, administrative views)

Highlights across the tenure:
* Essayed a stellar role in:
* Heading a team in supporting a set of complex database implementations including DB2 10.5
migration, Amnesty Project which was on DB2 and SQL Server, Combo & Regs; performed data
migration & management of MySQL database during development and implementation
* Taking system security & data processing software functionality; carrying out thorough testing
procedures on each product's functional areas
* Developing store procedures and triggers as per business requirements
* Formulating backup & recovery including disaster recovery plans and analyzing data in
production & testing environment
* Holds the distinction of migrating databases for DB2 10.5, SQL SERVER 2012 to Windows Server 2012
* Spearheaded a diverse Database Administration (DBA) Team of 4 personnel with resources in
multiple locations
* Significantly performed query on optimization on both DB2 & MySQL and designed database
structures
* Played a key role in validating data load IT processes through careful testing in order to
maximize the benefit of business investments in IT initiatives
* Efficiently coordinated with internal customers & client organizations to understand incidents
and ensure provision of quality service in line with agreed upon SLAs; achieved a 75% incident
closure rate with 5% reduction in the number of incidents
* Steered efforts in implementing changes approved by the change control committee