EZEKIEL DULGUIME VERGARA

*N Magnolia Tower Peninsula Garden Midtown Homes, Barangay 826, Penafrancia St., Paco, Manila

Contact Nos: +632 999-***-****

Email: adjcu0@r.postjobfree.com

Administration Skills

MS SQL Server version 7,

2000, 2005, MSSQL

2008, MSSQL 2008 R2

and 2012

Oracle Database 11g, 12c

MySQL & Postgres

Sybase Adaptive Server

Enterprise 11.x, 12.0,

12.5.x, 15.x

Replication Server 11.0.3,

11.5.1, 11.9, 12.x, 15.x

Transact SQL, Stored

Procedures

Performance and Tuning

Stored Procedures

Optimization

Data Transformation

Services

SQL Server Integration

Services (SSIS)

MSSQL Server

Transactional

Replication

MSSQL Log Shipping

Technical Skills

Language and Software

DBArtisan

Sybase Central

MS SQL Enterprise

Manager

MS SQL Management

Studio

Cyrano

Visual Basic

SQL Navigator

SQL Advantage

ISQL

Unify Vision

HTML

Active Server Pages

MS Office

Lotus Notes

MS Project

Paradox for Windows 7

Professional Overview

I am a Senior SQL Database Administrator and have 24 years of professional experience in Information Technology industry with over 18 years of experience as SQL Server DBA. My most enriching EXPERIENCE was working with BETSSON in Malta, PRUDENTIAL FINANCIALS in New Jersey USA and ASURION in Nasville, Tennesse, USA. Aside from my work experience, I'm an ITIL Version 3 Foundation CERTIFIED which I got a perfect score.

SQL Server versions Handled: MSSQL 7.0, MSSQL 2000, MSSQL 2005, MSSQL 2008, MSSQL 2008 R2, MSSQL 2012, MSSQL 2014, MSSQL 2016, MSSQL 2018 My expertise and strong background are the following:

Providing technical expertise in Database Management

Working in partnership with other Developers in attaining highly optimized and innovative solutions

Perform Database Administration tasks independently in MS SQL Server 7.0, 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2018

Perform MS SQL Server database setup, database upgrades, space management, backup and recovery.

Diagnose and resolve performance issues, connectivity/security issues and database corruptions in a critical production environment.

Setup and maintain High-Availability and Disaster Recovery solutions.

Experience in supporting multiple SQL Server installations on a single box and very large databases.

Experience in troubleshooting on MS SQL Server and AlwaysOn High Availability issues.

Reviewing application’s access to the database structures.

Review, where required, the purge/archive criteria.

Document necessary for processes and procedures (creating KBs, runbooks, topology, etc)

Capable of providing 24X7 supports in a critical production environment. I have carried out technical roles for several strategic projects where sophisticated solutions were implemented in a variety of computing infrastructures and system architectures. I led the front- end and back-end developments including end-user reports, implementation and support of Homegrown Applications. I demonstrated proficiency in planning, coordinating and execution of corporate projects from conception to completion with very minimal supervision. I have strong interpersonal communication skills. I am responsible, hardworking, proactive, good team player, independent, customer and result oriented. With these experiences, I established the following goals when working on a project: zero downtime, quick response time, quick resolution time, project shall be within scope, budget and schedule, 100% delivery and always work with urgency during deadlines.

EZEKIEL DULGUIME VERGARA

8N Magnolia Tower Peninsula Garden Midtown Homes, Barangay 826, Penafrancia St., Paco, Manila

Contact Nos: +632 999-***-****

Email: adjcu0@r.postjobfree.com

MS Cobol/CICS

FTP

Dameware

Techtia Shell Client

LeechFTP

Putty

Rapid SQL

Cyrano Workbench Client

3.2

X Manager 1.3.9

Rational Clear Quest

Remedy

CA Service Desk

Database

Sybase Adaptive Server

Enterprise

MS SQL Server

Oracle

MySQL

Postgres

Sybase SQL Remote with

Data Replication

ODBC

MS Access

Paradox for Windows

Operating Systems

MS-DOS

Sun Solaris 8 (UNIX)

MS Windows 2003

MS Windows 2000

MS Windows 2000

Advanced Server

MS Windows XP

MS Windows 9x

MS Windows NT

Novell Netware

Hardware

DELL

DEC Alpha 8400

Unisys Aquanta ES

HP SunSparc

Compaq Proliant

Intel-based PCs

Career Summary

Unionbank of the Philippines under AKGC (Pasig, Philippines) Senior Database Administrator (March 2020 – Present) Betsson Group (Malta, Europe)

Senior SQL Server DBA (April 2016 – February 2020) Betsson Group (Malta, Europe)

Sportsbook DBA (April 2014 – March 2016)

ASURION (Global City, Philippines)

Global DBA Team (January 10, 2011 – March 31, 2014) Seven Seven Global Services Incorporated – Prudential Financials (New Jersey, USA) Sybase/MSSQL Database Consultant(May 2, 2007 – January 2011) AMERICAN INTERNATIONAL UNDERWRITERS (AIU) (Phils.) Sybase/MSSQL DBA 3(January 2005 – April 30, 2007)

Sybase DBA 2(June 2001 – January 2005)

EXPRESS TELECOMS (Phils.)

Senior SQL DBA – Asst. Manager (April 2000 – May 2001) Project Manager/Systems Analyst (August 1999 – March 2000) EQUITABLE PLANS (Phils.)

Senior DBA – Asst. Manager (January 1999 – July 1999) IT Experience and Consulting

Unionbank of the Philippines under AKGC Level11 Tech (Pasig, Phils.) Database Administrator (March 9, 2020 – Present)

My duties and responsibilities also includes:

- Database support of multiple platforms such as MS SQL Server, Oracle, MySQL & Postgres

- Working in partnership with the UBP DBAs providing knowledge transfers of Database deployments, data fixes, etc.

- Installs and configure new SQL Servers

- Monitor and Notify teams for DB Resource Utilizations

- Providing performance tuning, implementations, fault tolerance and database administration

- Apply knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server Implement operational automation

Industry Experience

iGaming

Insurance (Underwriting)

Systems

Pre-Need Insurance

Systems

Education

This individual holds a

Bachelor Degree with a

major in Computer Science

from Adamson University and

Business Systems from

Systems Institute.

While in College, he was an

active member of Junior

Philippine Computer

Society from 1991 to 1994.

Top 2 of the graduating class

of Batch 311 in Programming

and Business Systems at

Systems Technology

Institute (STI).

Personal Data:

Jake, a Protestant and Filipino

by birth, is the eldest son in the

family who was born on

December 12, 1973 in

Surigao City, Philippines.

He became the Best

Rebounder (Y2003), member

of the mythical five (Best

Power Forward – Y2002 to

Y2004) and the Most

Valuable Player (MVP -

Y2003) in the AIU Basketball

League.

Also, he was awarded the

Highest Pin for Men with the

pins of 213 in AIU Bowling

Tournament 2002, Top 9 of

the Most Number of Spares

and 2nd runner-up of the

Highest Average Score Male

in AIU Bowling Tournament

2004.

Aside from that he play Chess,

Volleyball, Billiards,

Badminton and Table Tennis.

Betsson Group (Malta)

Sportsbook DBA (April 1, 2014 – January 31, 2020)

My duties and responsibilities also includes:

- Managing multiple databases for Sportsbook.

- Providing technical expertise in Database Management.

- Working in partnership with other Developers in attaining highly optimized and innovative solutions.

- Monitor and Troubleshoot Database issues.

- Knowledgeable in SQL Server and T-SQL as well as server Architecture and High Availability solutions.

- Providing performance tuning, implementations, fault tolerance and database administration.

- Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlock issues, replication/log shipping issues, connectivity issues, security issues etc.

- Performance Tuning, Query Optimization, using Performance Monitor, SQL Profile

- Troubleshooting SQL Server related CPU, memory, I/O, diskspace and other resource contention

- Apply knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Availability groups

- Apply knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server Implement operational automation

- Apply knowledge of how indexes, index management, integrity checks, how statistics work, how indexes are stored, how they can be created and managed effectively

- Apply knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs and system sprocs)

- Document necessary for processes and procedures (Confluence, Wiki page)

- Installs and configure new SQL Servers

- Deploy database change scripts provided by the Developers

- Tuning T-SQL queries to improve performance

- Advise Developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc)

ASURION PDOC (Global City, Philippines)

Global DBA Team (January 10, 2011 – March 31, 2014) My duties and responsibilities also includes:

Provide troubleshooting of SQL Alerts across US Territories, Europe and Asia Pacific.

Reviews and Approves RFCs under ITOLC (Information Technology Operational Logistics and Communications.

Make Release Notes & Deploy RFCs (Change Requests) globally.

Engaging on Bridge Calls CIRTs (P1,P2,P4).

Acknowledged and Completes Incidents and Service Request via Service Desk.

Database Support and Assistance across US, Europe and Asia Pacific Region.

Database Support and Assistance for DEV/QA Environment in PDOC (Philippine Development and Operations Center).

Veritas Clustering limited to DB Failovers.

Installed and Configured SQL 2012 Enterprise Server

Installed and Configured MS Clustering Failover

Upgrade Database Administration Skills on MS SQL Server 2012 Prudential Financials (New Jersey, USA) under Seven Seven Global Services Incorporated

Sybase/MSSQL Database Consultant – (May 2, 2007 – January 2011) As a Database Consultant, I am responsible in the Database engineering offshore support and implementation for Prudential Financials in New Jersey, USA. EZEKIEL DULGUIME VERGARA

8N Magnolia Tower Peninsula Garden Midtown Homes, Barangay 826, Penafrancia St., Paco, Manila

Contact Nos: +632 999-***-****

Email: adjcu0@r.postjobfree.com

My duties and responsibilities also includes:

Creation/Removal of userids.

Implementing scripts into Sybase and MS SQL Server Production Servers.

DBA offshore supports in the US and Ireland Production Servers.

Performs vignette migration from (Development to QA, QA to Staging, Staging to Production).

Maintaining and troubleshooting Sybase and MS SQL Servers.

Maintaining and troubleshooting Replication Server and Log-shipping.

Providing 24x7 on-call support.

American International Underwriters Corporation (Phils.) (June 2001 – April 30, 2007) Sybase/MSSQL Database Administrator – Team Lead (Tier 1) As a DBA Lead, I am responsible in IT Infrastructure Support, Database Design & Implementation in Asia Pacific Region including Taiwan, Thailand, Malaysia, Indonesia, India, China, Korea, Australia, Guam, Philippines and Singapore. My duties and responsibilities also includes:

Approval of data patches, verifying and applying of builds in all Underwriting applications, production support.

DBA support in all Asia Pacific Region, installing and upgrading Sybase Adaptive Enterprise, monitoring database server’s health and tuning accordingly and using storage properly.

Performs Back-Up and Recovery

Managing database users and security.

Works with the Development and Configuration teams to establish and enforce standards, performs data extracts/transfer/migration, setting up and maintaining data replication, setting up server scheduling and providing 24x7 on call support.

He prepares documentations such as DB Release Notes to sites and DB Technical Documents.

He finished the Database Operations Review in Australia, Indonesia and Remediation in Singapore.

Assigned as the DRP Core Member of MRTC Disaster Recovery and Business Continuity Plan. EXPRESS TELECOMS (Phils.) (August 1999 – May 2001) Senior SQL DBA – Asst. Manager (April 2000 – May 2001) Project Manager/Systems Analyst (August 1999 – March 2000) As a Senior DBA – Asst. Manager, I am responsible in IT Operations, Database Design & Implementation. Provides main support for Prepaid, Postpaid, Billing, Internet Information System, Data Warehouse, Fraud, Development and Authentication Database Server. As a Project Manager/Systems Analyst, I am responsible in the analysis, design and implementations of Postpaid Reports, Cell card Activation and Broadcast Message Program. A Postpaid Report Program designed to facilitate the Customer Service and Collection & Billing Department for generating Postpaid Details & Summary Reports. A Cell Card Activation Application designed to facilitate the Cell card’s Activation for processing validation numbers randomly, Status, Balance and amount of the Cell Card. EZEKIEL DULGUIME VERGARA

8N Magnolia Tower Peninsula Garden Midtown Homes, Barangay 826, Penafrancia St., Paco, Manila

Contact Nos: +632 999-***-****

Email: adjcu0@r.postjobfree.com

A Broadcast Message Program designed to facilitate the Collection & Billing Department to upload Subscriber MINs for any collections, billing, promotions, etc…. EQUITABLE PLANS (Phils.) (January 1999 – July 1999) Senior DBA – Asst. Manager

As a Senior DBA – Asst. Manager, I am responsible in the entire Pension Plan Program involved in the analysis, design and development of the Pension Plan Program. Responsible in data gathering, data modeling, user training, systems test, implementation plans, maintain databases, tune-ups, backups, restore data and made status reports. Courses / Trainings Attended:

Project & Time Management

Introduction to SCRUM

Updating your Database Skills to MS SQL Server 2012 (MS 40008)

Implementing and Maintaining MS SQL Server 2008 Analysis Services (6234A)

Implementing and Maintaining MS SQL Server 2008 Integration Services (6235A)

Implementing and Maintaining MS SQL Server 2008 Reporting Services (6236A)

Microsoft Clustering Training

Information Technology Infrastructure Library ver 3.0 (ITIL)

Spectrum and EHealth

Communications Skills

Fast Track to Adaptive Server Enterprise 15.0

Fast Track UNIX Scripting

UNIX Systems Administration 1

Fast Track to Adaptive Server Enterprise Replication Server 12.0

Fast Track to Adaptive Server Enterprise 12.0

Performance and Tuning: Configuring Adaptive Server Enterprise

SQL Server 2000 Overview for SQL Server Administrator and Developers

Upgrading SQL Server 7.0 to SQL Server 2000

System and Database Administration: MS SQL Server 2000

MS SQL Server 7 Database Design

Advance SQL Server 7.0 Administration

Installing, Configuring and Upgrading SQL Server 2000

Transferring and Transforming Data in SQL Server 2000

Logical Database Design

Relational Analysis and Design

Project Management

Effective Communication

EZEKIEL DULGUIME VERGARA

8N Magnolia Tower Peninsula Garden Midtown Homes, Barangay 826, Penafrancia St., Paco, Manila

Contact Nos: +632 999-***-****

Email: adjcu0@r.postjobfree.com

Negotiation Skills

References

George Adamson - Head of IT Sports Wagering Solutions at The Hong Kong Jockey Club Albert Corpus - DevOps Lead of Sportsbook at Betsson, Malta

Contact this candidate