Lead дизайнер · betting, igaming

Sign in Sr. SQL Server DBA Location: Manila, Philippines Salary: 170,000 Philippine pesos Posted: January 12, 2021 Contact this candidate Resume: EZEKIEL DULGUIME VERGARA *N Magnolia Tower Peninsula Garden Midtown Homes, Barangay 826, Penafrancia St., Paco, Manila Contact Nos: +632 999-***-**** Email: *********@*****.*** 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: *********@*****.*** 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: *********@*****.*** 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: *********@*****.*** 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: *********@*****.*** 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 PostJobFree Delete or Update my resume About Terms of Service Privacy FAQ Contact us