Service Data

ANGELO FONTANILLA

Dubai, United Arab Emirates E-mail: ***************@*****.***

Contact: +971********* ***********@*****.***

************.**********@**********.**

OBJECTIVE

To impart my knowledge in a growing company that will allow me to expand and fully utilize highly competitive skills.

PRIMARY SKILLS AND QUALIFICATIONS

SQL Database Administration and Development using

MS SQL Server 2017

MS SQL Server 2016

MS SQL Server 2014

MS SQL Server 2012

MS SQL Server 2008 / 2008R2

High Availability with Disaster Recover (SQL Server Clustering, LogShipping, Mirroring, AlwaysOn, Replication)

MS Access, Transact SQL, PowerShell, VB Script

SSRS installation and configuration / SSAS / SSIS

SQL Trace

Full Text indexing

Spotlight / Foglight Monitoring on SQL

AWS EC2 and RDS Instances deployment, Elastic Search

Azure

JASON and XML manipulation using TSQL code

DevOps Model

Jenkins, Bitbucket, Github

VMWare Administration

Veeam Backup and Replication Administration

Linux basic commands

Basic Oracle Administration (10G and up)

Qlik Sense Scripting and Reporting

Nutanix Admnistration basics

Dockers

RESUME DETAILS

Summary

15 years of professional experience on the IT Industry as a SQL Database Administrator, IT Senior Staff and a TeamLeader. Recognizes changing needs and effectively modifying systems while maintaining work flow for seamless transitions, designed process and procedures. Skilled and experienced in SQL Database Administration and Scripting, SQL Server High Availability with Disaster Recovery Plans, System Analysis/Design, Centralize Backup Management, Basic Networking, Server Management (Windows and Linux Operating Systems), Basic PowerShell scripting. Comprehensive knowledge of software programs in areas including programming, database, data transformations, tracking, spreadsheets, and word processing. Additional software program knowledge and experience includes the following: LightSpeed, Quest FogLight, Red Gate SQL Compare, DB Launch, and database infrastructure for ERP systems such as JDEdward OneWorld and Microsoft Dynamics.

Professional Experience

Database Manager (acting) Serco Middle East

Rashidiya Metro Depot, Dubai, United Arab Emirates

Oct. 21, 2018 – Present

Responsible for maintaining and optimizing database infrastructure of Rail and Transportation Authority (RTA) for Dubai Metro and Tram. These are combinations of SQL Server 2012, SQL Server 2014, SQL Server 2016 and Oracle 11G. Ensuring that proper and reliable backup are in-place and DR site are up-to-date with the production servers. Also responsible for monitoring and maintaining the Primary and secondary Data Center status.

Involved with the Expo 2020 infrastructure upgrade into Nutanix Systems having Qlik as the reporting tool and SQL Server 2017 as the backend Database server.

Primary Responsibilities:

Provides 24/7 support for the overall system including VMWare and Veeam issues.

Provides 24/7 support for performance and system errors.

Primary escalation during the actual production disaster recovery.

Ensures that VM backup of all the servers are in place.

Design, implemented and maintain Database Backup system.

Design and implemented utility database for SQL Server 2016

Implemented and maintain Ola Hallengren Maintenance plan for SQL Server 2016

Ensures the availability of the database server 24/7

Ensures that database servers are performing fast.

Performance tuning of slow running queries

Infrastructure Engineer 3

(Senior SQL DBA/ Junior Oracle DBA) Asurion HonkKong Limited - ROHQ

17F Ascendas Accralaw Tower 30th St. cor 2nd Ave. Crescent Park West, Bonifacio Global City, Taguig 1634 Philippines

Nov. 04, 2013 – Oct 20, 2018

A Senior DBA of Asurion's Infrastructure and Operations team. Asurion is a privately held company based in Nashville, Tennessee that provides device protection and support services. A Senior DBA works closely with other Asurion locations (US, India, Japan, China) to deliver high-quality support and solutions for Asurion’s database operations which includes troubleshooting of SQL Database issues. This role has a broad responsibility for ensuring that Asurion databases are up 24x7, plans, research, evaluates, and develops database solutions.

As part of the DBA team, a senior also coaches and develops junior engineers.

Primary Responsibilities:

Works with other support teams and provides assistance and resolution for SQL database issues

Develop, recommend, and assist with implementation of upgrades and DB improvements

Develop solutions to complex database problems

Display a high level of thinking in bringing successful resolution to high-impact, complex and/or cross-functional problems

Responsible for training junior engineers on existing/new solutions and technologies

Plan, implement, and/or engineer solutions based on project requirements

Monitoring/tracking databases

Work with all support teams on escalated critical DB alerts and drives efficient resolution for incidents

Upgrading and Migrating of SQL databases

Reviews log files and monitoring data for problems and perform proactive maintenances

Participates in Root Cause Analysis for production issues and be responsible to provide one for DB issues.

Ensures the availability of databases 24x7.

Ensures a proper backup are in place.

Develop and Implement Maintenance Plans

Support includes Setup and maintenance of Replication / Logshipping / Mirroring / Always-On/ Clustering / and Adhoc Backup and Restore

Basic Oracle Administration starting with Oracle 10G up to 12C

SQL Database Administrator - Team Leader T-Systems Malaysia

2250 Century Square 2, Jalan Usahawan,

63000 Cyberjaya, Selangor D.E., Malaysia

January 11, 2011 – November 1, 2013

Team Leader of 10 T-Systems SQL DBA workforce specializing in SQL Server 2012/2008R2/2008/2005/2000 database administrations and services under ITSM Processes for top IT performance, supporting Philips IT Infrastructure. Such processes include Incident Management, Change Managements and Problem Management to ensure best possible levels of service quality and availability are maintained. Request Management comes into place covering the cataloguing, request and fulfillment of predictable and repeatable DBA services.

Primary Responsibilities:

Acting as the 3rd level of support for problem resolutions on DB related isuses.

Manages the SQL DBA Team to cover 24/7 operational issues supporting Asia Pacific, Europe and US regions.

Provides consultancy to Senior and Junior DBA’s.

Ensure availability of valid SQL Server databases at all times and resolve all problems within targets as specified in the Service Level Agreement.

Participate in identifying the root cause analysis of repeating problems. Prevents the recurrence of incidents related to database errors within the business IT infrastructure by finding the root cause of the incidents.

Monitor problem/query resolution where necessary and ensure appropriate escalation actions are taken, using the global tools (such as Service Centre) and processes available.

Comply with Incident Management goal to restore normal operations as quickly as possible and minimize adverse impact of database related errors on business operations.

Ensure that standardize methods and procedures are used for efficient and prompt handling of all changes, in order to minimize that impact of change-related incidents upon service quality, and consequently to improve the day-to-day operations of the organizations.

Performs SQL Server 2000/2005/2008/2012 Installations, Patching/Upgrades and Performance Tuning.

Designing and implementing a thorough Database Backup process that provides the best chance of successfully recovering a production environment in the quickest amount of time in case there is a disaster situation.

Create Failover Database for disaster recovery and high availability by implementing SQL Server Data Replication, Log shipping, Database Mirroring, SQL Server Clustering and customized Backup and Restore.

Performance Tuning and Root Cause Analysis

Resolve issues in SQL Server Database involving Data Corruptions, Backup/Job failures, Logshipping / Mirroring / Replications / SQL Clustering.

Ensure any potential problems such as performance degradation, reliability and security issues are addressed proactively.

SQL Server Database Administrator JP Morgan Chase

AVP Level Net Plaza, 31st Street, Zamora Circle,Fort Bonifacio Global City, Taguig City

Feb 11, 2010 – January 10, 2011

SQL DBA for financial firm specializing in SQL Server 2000/2005/2008 database administrations and services supporting JP Morgan Financial Data. Main rule is to ensure best possible levels of service quality and availability of databases are maintained.

Primary Responsibilities:

Provide a high level of support for SQL Database related problem resolutions.

Resolve incidents involving in-depth analysis for issues such as :

oData Corruptions

oBackup / Job failures

oDisaster covery failures involving Logshipping / Mirroring / Replications / SQl Clustering and Backup and Recovery.

Ensure any potential problems such as performance degradation, reliability and security issues are addressed proactively.

Designing and implementing a thorough Database Backup process that provides the best chance of successfully recovering a production environment in the quickest amount of time in case there is a disaster situation.

Implements Change Management for new production deployments.

Performance Tuning and Root Cause Analysis

Senior SQL Server Database Administrator T-Systems Malaysia

2250 Century Square 2, Jalan Usahawan,

63000 Cyberjaya, Selangor D.E., Malaysia

June 30, 2008 – Feb 9, 2010

Key member of 22 T-Systems DBA workforce specializing in SQL Server 2000/2005/2008 database administrations and services under ITSM Processes for top IT performance, supporting Shell Information Technology. Such processes include Incident Management, Change Managements and Problem Management to ensure best possible levels of service quality and availability are maintained. Request Management comes into place covering the cataloguing, request and fulfillment of predictable and repeatable DBA services.

Primary Responsibilities:

Acting as the 2nd level of support for problem resolutions on DB related isuses.

Developed and design new databases for new application system use on production / development or test environment.

Provides consultancy for Junior DBA’s and customer.

Ensure availability of valid SQL Server databases at all times and resolve all problems within targets as specified in the Service Level Agreement.

Participate in identifying the root cause analysis of repeating problems and escalate to the responsible party for recovery and future prevention.

Monitor problem/query resolution where necessary and ensure appropriate escalation actions are taken, using the global tools (such as Service Centre) and processes available.

Comply with Incident Management goal to restore normal operations as quickly as possible and minimize adverse impact of database related errors on business operations.

Ensure that standardize methods and procedures are used for efficient and prompt handling of all changes, in order to minimize that impact of change-related incidents upon service quality, and consequently to improve the day-to-day operations of the organizations.

Prevents the recurrence of incidents related to database errors within the business IT infrastructure by finding the root cause on the incidents.

Performs SQL Server 2000/2005/2008 Installations, Patching/Upgrades and Performance Tuning.

Designing and implementing a thorough Database Backup process that provides the best chance of successfully recovering a production environment in the quickest amount of time in case there is a disaster situation.

Create Failover Database for disaster recovery and high availability by implementing SQL Server Data Replication, Snapshot, Log shipping, Database mirroring and SQL Server Clustering.

Performance Tuning and Root Cause Analysis

SQL Server Database Administrator Shell Information Technology International

2250 Century Square 2, Jalan Usahawan,

63000 Cyberjaya, Selangor D.E., Malaysia

May 14, 2007 – June 29, 2008

Key member of 18 Shell DBA workforce specializing in SQL Server 2000/2005 database administrations and services under ITSM Processes for top IT performance support. Such processes include Incident Management, Change Managements and Problem Management to ensure best possible levels of service quality and availability are maintained. Request Management comes into place covering the cataloguing, request and fulfillment of predictable and repeatable DBA services.

Primary Responsibilities:

Ensure availability of valid SQL Server databases at all times and resolve all problems within targets as specified in the Service Level Agreement.

Ensure any potential problems such as performance degradation, reliability and security issues are addressed proactively.

Participate in identifying the root cause analysis of repeating problems and escalate to the responsible party for recovery and future prevention.

Monitor problem/query resolution where necessary and ensure appropriate escalation actions are taken, using the global tools (such as Service Centre) and processes available.

Comply with Incident Management goal to restore normal operations as quickly as possible and minimize adverse impact of database related errors on business operations.

Ensure that standardize methods and procedures are used for efficient and prompt handling of all changes, in order to minimize that impact of change-related incidents upon service quality, and consequently to improve the day-to-day operations of the organizations.

Prevents the recurrence of incidents related to database errors within the business IT infrastructure by finding the root cause on the incidents.

Performs SQL Server 2000/2005 Installations, Patching/Upgrades and Performance Tuning.

Performs monitoring of Microsoft Server 2000/2005 instance availability in the Windows 2000 Group Infrastructure Desktop environment.

Enabling SQL Mail Checks and SQL Agent Mail Checks on jobs.

Designing and implementing a thorough Database Backup process that provides the best chance of successfully recovering a production environment in the quickest amount of time in case there is a disaster situation.

Create and implement SQL Server Maintenance activities and provide appropriate measures to ensure data integrity of internal data storage are properly maintained.

Create Failover Database for disaster recovery and high availability by implementing SQL Server Data Replication, Snapshot, Log shipping, Database mirroring and SQL Server Clustering.

Focal Point for Microsoft Office SharePoint Service (MOSS) Database design and implementation.

Database Administrator/Application Developer Advantek Inc., CIP II, Industrial Park

August 2, 2004 – May 12, 2007

Three years of Database Administration experience for major ERP Systems, providing systems programming, and software development for major projects. Lead Database administrator within the Information Technology Department responsible for logical and physical design with a significant effort towards application and database tuning of the company’s ERP System. Major activities include advance performance tuning, database design, capacity planning and establishing standards for SQL installations, maintenance, tuning and coding standards.

Primary Responsibilities:

Established and wrote a performance tuning guidelines for the IT Department to enhance the performance of the ERP Backend System for current and future code developments. This guideline includes hints for SQL and Database performance tuning, application tuning methodologies, determining instance and I/O efficiency, and using tools like PERFMON, PROFILER, SQL Process Information and RE-INDEXING Standards.

Redesigned a thorough backup and recovery strategy for all major production systems. This initiative involves the design and development of several SQL scripts used for both physical and logical backups. Also included in this effort was the development of various recovery strategies that included media failure, user failure and block corruption.

Designed and implemented an Error Tracking System (ERedLight Tracking System) for the production error analysis and reports using SQL Server 2000 as backend and Visual Basic for frontend interface. Involves over 150 client production computers generating text file error logs consolidated and converted into a SQL Database format for reporting and data analysis.

Created a Slitter Label Software that prints slitter barcode for product raw material inventory. The system was developed using Visual Basic 6 for front end interface connected to a SQL Server 2000 database via ODBC. The system stores and retrieves last access information into the clients registry setting as the initial value, it was rolled out and implemented on the following locations:

Philippine Plant

Shanghai, China Plant

Developed barcode label software’s that retrieves information from JDE Database using RDBMS, ADO and ODBC connection as per customer barcode requirements. This programs were implemented on the following locations:

Shanghai, China : GEM Barcode Generator

: KNOWLES Barcode Generator

Singapore : UTAC 2D Barcode System

California : AUTOSPLICE Box/Reel Barcode Generator

Philippines : INTEL/CYPRESS Pick Slip Barcode Generator

Developed a Material Review Report (MRR) Program for product review, analysis and security. The program generates MRR# for LOT # allocations on the ERP System, and reads all product dimensions and information from the central database. The system involves migration from one database platform to another using RDBMS, ODBC and SQL while maintaining work flow. Currently being used by all manufacturing plant: Taiwan, Shanghai, Philippines.

Created a Certificate of Compliance Report generating program that ensures that all products to be released met the specification standard on all dimensions, and was visually checked and free from all deformations/defects.

Configured an email based notification system, integrated with Exchanged profile accounts or via SMTP services for alerts or concurrent activities under Active Directory 2003 environment.

Work with outside consultants in solving existing issues for the current application systems such as Asset Tracking Software (MP2), Scheduling System (Tigersoft) and the Production Data Collector Systems (DSI) to fully utilize and maximized software capabilities.

Successfully upgraded and implement Electronic Data Interchange system (EDI) using Trusted Link on our California office for faster and more reliable transactions. Apart from this is the hardware upgrade and data migration.

Proposed and Implemented WebFocus 5.3.3 for a fully integrated enterprise business intelligence reporting tool where global users can personalize their reports for management presentations and design.

Develop and maintain Data Transformation Services, Stored Procedures, Views and Triggers.

Handles dcLink Tranbuilder 4.0 Scripting and Administration for streamline data collection by simplifying data entry, collecting data transfer and validating data and procedures in real time.

Other Job Functions:

Citrix Administration using Citrix Management Console for farm administration, security, and publish applications.

Wholly responsible for technical support operations in high-volume, 24x7 environment, including the supervision of at least 60 servers running on Active Directory 2003 under Citrix Metaframe Environment for technical issues involving network, hardware, and operating systems (Windows 2000 Advance Server, Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 Web Edition). Oversee network connectivity, implementation, integration, and troubleshooting for servers, routers, remote access, storage devices, printers, and scanners

Evaluate new technologies, as required, to provide more realizable, cost effective Information System

Database Administrator/Systems Staff Isuzu Autoparts., Laguna Technopark, Inc.,

October 22, 2002 – August 1, 2004

Key member of the Information System Management Team for a major Specialty Automotive Manufacturing Corporation. Responsible for coding, analyzing and troubleshooting production information systems. Provide programming and DBA support for SAP Operations and network connectivity.

Primary Responsibilities:

Implemented Database system to track employee wages, time worked as well as personal information, working backgrounds, training and certificates. The system includes query options to track and find records faster based on the query parameters.

Developed production support software based on SAP text output for product record and analysis.

Inventory Support using SAP operations for Mid-Year and Year-End Inventory Management

Design and Implement a Wireless Network Communication between client computers considering security of information’s. Knowledge in connectivity and communication protocols.

Implement an automated asset tracking system for Desktop and Server Applications and Hardware

Established a centralized backup system for data security and recovery. Responsible for network backup integrity and recovery coordination along with disaster preparedness planning.

Norton Antivirus 2000 administration for redistribution server and client computers. Evaluate and Implement antivirus procedures and tools to minimize virus impact on group

Monitor performance, availability and capacity of servers and network devices.

Ability to perform advance server and network administration skills to include upgrades and maintenance of hardware, operating system, DNS, TCP/IP, WINS, DHCP, AD and IIS support functions.

Assembly Supervisor Andes Ionics Inc., Light Industry and Science Park

January, 2000 – November, 2001

Supervise at least 40 person’s union production line of machine operators and line mechanics/electricians in daily high speed semiconductor operations and weekly line start-ups. Accountable for maintenance/safety/troubleshooting of line and meeting all quality and efficiency objectives, measured hourly.

Primary Responsibilities:

Plan / schedule preparation & expediting of productions

Attend daily interdepartmental meetings, plan/schedule preparation and expediting of production, facilitate communication between departments; conduct liaison with all departments.

Direct production staff assignment/workload; act as a production/management liaison.

Perform process improvements and train others on methods.

Maintain product quality while aligning production to meet specified due dates and deadlines.

Trainings and Seminars

Administering and Maintaining SQL Server 2012 Nov, 2012

Maintaining SQL Server 2008R2 Nov, 2011

SQL 2008 Administration and Maintenance April, 2009

Snap Manager for SQL Server March, 2009

SQL 2005 Disaster Recovery Plans Sept, 2007

SQL Performance Tuning and Monitoring Nov, 2007

MP2 System Administration June, 2005

Shanghai, China

Software for work order tracking and management, preventive maintenance scheduling, Inventory Tracking, Equipment Cost Management, Equipment History Tracking, Part Requisition and confidential labor records maintenance.

Administering SQL Server 2000 May, 2005

MIS Net, Makati, Philippines

Performing SQL 2000 administrative Task

Programming with MS SQL Server 2000 June, 2005

MIS Net, Makati, Philippines

Creating and Managing Databases using Transact SQL Language

DSI Scripting and Administration August, 2005

Kansas City, USA

Automated data capture software solution, extends the reach and value of enterprise software applications by capturing accurate, real-time data in production, at the warehouse, and in the field.

WebFocus Report Development, September, 2005

Setup and Implementation Advantek, Phil., Inc.

Enterprise business intelligence reporting tool

Educational Background

1995 – 1999

Graduated Tertiary level in Saint Louis University ( SLU ), Gen. Luna Road, Baguio City 2600 Philippines, under the degree of Bachelor of Science in Computer Science ( BSCS ).

1991 – 1995

Graduated Secondary level in Don Mariano Marcos Memorial State University (DMMMSU – SLUC), Agoo, La Union 2504 Philippines. Being one of the top ten students in a class knowledgeable in computers.

1985 – 1991

Graduated Preliminary level in Agoo West Central School, San Nicolas, Agoo, La Union 2504 Philippines. With Honor.

Contact this candidate