Ellison Bartolome
MCT | Database Administrator
Languages
Filipino | English
Skills
Microsoft Azure, Database Administration, DB2, MySQL, Teradata, ITIL 4, Linux/Unix/Windows Systems
Professional Experiences
Microsoft Certified Trainer
September 2021 – Present
Conducts and facilitates courses:
- AZ-900Azure Fundamentals
- AZ-104 Azure Administration
- PowerBI Fundamentals
Senior DB2/MySQL Database Administrator – Manulife IT Delivery Center Philippines
April 2022 – Present
- Advanced database administration for DB2 Version 11.1.x and MySQL 8.x on Linux, Unix and Windows
- Subject-matter Expert and Solutions Architect on Azure Cloud database platforms
- Trainer for Azure Cloud
Senior Teradata Database Administrator – Teradata/EClaro February 2016 – April 2022
- Lead DBA for North American accounts
- Resolve data warehouse physical design inconsistencies by applying multi-dimensional database modeling best practices
- Implement Performance Tuning best practices and techniques using EXPLAIN and Stats collection, table indexing, SQL code rewrites, and spool allocation
- Resolve incidents related to workload performance, ETL batch job failures, high availability, backup and database recovery
- Implement automation by creating LINUX Shell scripts and Teradata SQL for monitoring user logons, password expiry, database objects
- Perform planning and coordination of major database Production changes
- Implement stringent database security, identity and access management measures
Faculty – Computer Science Department, University of Santo Tomas
August 2013 – May 2018
- Instructor, Consultant and Thesis Adviser
- Authored and implemented syllabi for elective courses in Database Management and Administration, Data warehousing, Knowledge Management, and Business Analytics Tools and Techniques
- Recognition: Best Thesis Adviser Awardee 2018 in Computer Science Department entitled: “HIVE: An Epidemic Tool Predicting HIV Cases in NCR using Support Vector Machines for Regression and K-Means Clustering”
Senior DB2 Database Administrator
- Seven Seven Global Services (2013-2016)
- Safeway Philtech (2013)
- SC Johnson Philippines ROHQ (2010-2012)
ETL Developer/Database Designer – Hewlett-Packard Philippines ROHQ
April 2008 – April 2010
- Designing and implementing ETL solutions for data migration using Informatica PowerCenter and TIBCO BusinessWorks
- Create multi-dimensional database models, lookup tables, staging and target tables
Technical Support Engineer – Concentrix Philippines
January 2007 – March 2008
- Phone and email service desk support for North America for Netgear networking devices
Certificates
- Microsoft Azure Cloud Certifications
- Microsoft Certified Trainer
- Azure Certified Solutions Architect Expert (2021)
- Azure Certified Administrator Associate (2021)
- Azure AI Engineer Associate (2021)
- Azure AI Fundamentals (2021)
- Azure Data Fundamentals (2021)
- Azure AZ-900 Fundamentals (2020)
- Oracle Cloud Infrastructure Certified Associate (2020)
- ITIL 4 Foundations Certified (2019)
- Teradata Version 16 Vantage Certified Professional (2019)
- Teradata Version 14 Certified Professional (2016)
- IBM DB2 9 Certified Associate (2013)
Education
University of Santo Tomas – BS Computer Science 2006.