DB2 DBA

Marino C. Villareal Jr.

Mobile Number: +63-999*******

Email: *****************@*****.***

Qualifications

DB2 Database Engineer for more than 5 years

College Graduate in BS Electronics Engineering

University of the East, Philippines, 2012

Language: English,Tagalog

Current Location: Philippines

Professional experience

Profile

Currently leading a team of database administrators for issues and changes raised as part of the support to the client. Performs and lead tasks and activities as needed/requested by the client.

Key Skills

DB2 DBA for Linux,Unix and Windows

DB2 DBA for Z/oS Mainframe

Career History

07/2017 – Present

DXC Technology Philippines

DB2 for LUW Team Lead

DBA (Database Administrator ) - Applications Operations Support (Monitoring, Issue

Handling & Escalation, Install and Upgrade, Documentation)

Project Description: Provide lead support for DB2 database maintained.

Provide support on tickets raised as per needed by the project.

DB2 Database Migration

DB2 Database Fixpack Upgrade

DB2 Database Version Upgrade

DB2 Related Tickets

Database ticket reduction initiatives

Support on Guardium Database Encryption

Raise PMR for DB2 related bugs

Other DB2 related support

Oracle Database Patching

03/2013 – 07/2017

IBM Solutions Delivery, Philippines

DB2 DBA

DBA (Database Administrator ) - Applications Operations Support (Monitoring, Issue

Handling & Escalation, Documentation)

Project: Ishango

DB2 LUW Database Administrator/Netezza Database Administrator

Project Description: Provide application support for DB2 database maintained.

Provide support on tickets raised as per needed by the project.

DB2 Installation

DB2 Fixpack Upgrade

DB2 Database Migration

Other DB2 related support

Netezza Database Support

Project: Sprint

DB2 LUW Database Administrator/ IVR Production Support

Project Description: Provide application support: Resolve problems and answer questions related to DB2 Databases in Unix environment; contact vendor support when necessary facilitate application development and client problem resolution with optimum speed and efficiency

Performs Fixpack installation on current DB2 installed.

Participate in OS patching activities, hotfix installation and other upgrades needed by providing support as a DB2 Database Administrator resource.

Provide support on incidents related to DB2 Databases.

Maintains DB2 Database backups and storage to prevent issues and keep the databases available and accessible.

Provide 24x7 oncall support

IVR Production Support: such as Service Requests and health checks on the IVR related servers. Also provide 24x7 on call support as IVR Support.

Contribution: Installed Fixpack 11 to upgrade DB2 9.7 to its latest fixpack version. Reduced tickets by creating Cron jobs to prevent issue for disk space.

Participate in deployment and upgrades and successfully perform tasks such as DB2 Stop and DB2 sync.

Provide support for issues with DB2 Servers.

Complete assigned Service Requests for IVR Production on time without escalations and/or issues.

Provide 24x7 on-call support for IVR Production Support.

Project: Ericsson

DB2 for Z/oS

Project Description: Work with development team to resolve any performance problems; explain any non-efficient SQL, add indexes where required, etc.

Install (or provide installation instructions to Server team) database software.

Support DBMS Software (Upgrades / PTF’s / Maintenance / Security Patches)

Install and maintain related database management tools

Data Modeling / design logical database and create DDL

Define entities, attributes, and relationships

Logical design review / make suggestions & recommendations

Transform logical design data model to physical design

Create physical database

Execute object DDL to create database objects (i.e. tables, indexes, packages, etc) Execute DBMS system tasks to manage application database objects (maintenance like add table spaces etc)

Define size & placement of databases, backups and logs for recoverability and performance based on application requirements/expectations

Design purge/archive process according to records management requirements for the application

Stress testing as it pertains to database performance/monitoring

Set up performance monitoring process and review application SLA

Provide documentation and/or training for Level 1 support team; define problem escalation process.

Plan and implement physical DBMS performance improvements (i.e. resize logs, modify DBMS configuration, modify physical layout, partitioning, parallelism, moving objects across bufferpools, etc )

Utilize appropriate Change Management Processes and Tools

Manage database availability and resources

Manage Database Space (allocated and used )

Manage Database Transaction Logs ( active and inactive )

Manage physical DBMS configuration related to application databases

Manage and perform physical database maintenance (including running of appropriate utilities, jobs, scripts)

Manage job scheduler for database maintenance jobs.

Monitor size of the physical database objects.

Perform database monitoring to address performance issues or concerns as needed Perform database reorganization to improve performance, reclaim space etc.

Plan and implement database data loads/exports/imports strategy Perform database monitoring using agreed upon enterprise level tool Manage DBMS error logging.

Utilize appropriate Problem Management Processes and Tools

Provide 24x7 Physical (Infrastructure) DBMS support (level 2 and level 3) as required by SLA.

Provide 24 x 7 Logical (Application) DBMS support (level 3) as required by SLA.

Report problems and communicate with DBMS vendor and DBMS-tools vendors for support.

Participate in RCAs or incident reviews as required.

Assist application owner with application cost investigation; provide suggestions for cost reduction, such as data archiving, CPU usage reduction through SQL performance improvements, physical database improvements, etc.

Recommend operating system tuning to address DBMS performance issues.

Project: PHH

Application Maintenance and Support

Project Description: Handled Middleware Application tickets and provide workaround and root cause analysis that can resolve incidents. Provides investigation and analysis by looking at the Java codes, server log files and database.

Contribution: Resolved tickets that prevents the client from continuing their business process. Provides analysis and information on how to prevent the issues from happening again. Managed 1 team member in shift and exchanged ideas and thoughts related to the incident that can help us in resolving the issue.

05/2011 - 02/2013

Accenture, Philippines

Remote Desktop Support Specialist

Remote desktop support at end client.

Contact this candidate