Hi, I’m
Allan Faylona
System And Database Administrator
Guiguinto,Bulacan
Summary
Results-driven database engineer specializing in development and implementation of robust database architectures. Expertise encompasses performance optimization and data integrity, consistently driving substantial enhancements in system efficiency. Dedicated to collaboration and adaptability in dynamic environments, utilizing strong analytical and problem-solving capabilities.
Overview
20
years of professional experience
4
Certificates and awards
Work History
MAYA, INC.
SENIOR DATABASE ENGINEER SPECIALIST
01.2017 - 07.2023
Job overview
- Spearhead automated data ingestion and transformation processes which has led to an increase in team productivity. Enhance the efficiency and robustness of ETL/TL by utilizing AWS services like Glue, Apache Pyspark, and Databricks.
- Led database architecture design and implementation, enhancing data accessibility and system performance across multiple platforms.
- Mentored junior database engineers, fostering skills development and ensuring adherence to best practices in database management.
- Implemented automated database backup and recovery strategies, significantly minimizing downtime during system failures.
- Conducted performance tuning and optimization of existing databases, leading to increased operational efficiency and system reliability.
- Lead the operation support and development of various Amazon Cloud RDS, EC2, S3, glue, Apache Pyspark, and other Amazon services for automating data extraction, streaming, and manipulation.
- Conducts research and development for new products that are centered around database management systems, data warehouse, data cataloguing, and system integration.
- Having a collaborative relationship with diverse groups like data architects, data scientists, marketing, and application developers.
- Primary DBA who oversees PCI-DSS projects.
- Supervise the maintenance, management, and operations of systems and databases.
- Developed and optimized complex SQL queries, resulting in improved data retrieval efficiency and reduced processing times.
- Spearheaded the migration of legacy database systems to modern architectures, ensuring seamless data integrity and continuity.
- Collaborated with cross-functional teams to identify and resolve database-related issues, enhancing overall project outcomes and stakeholder satisfaction.
- Reduced query execution time by analyzing and fine-tuning SQL statements in complex applications.
- Served as a trusted advisor to stakeholders on matters related to database architecture, best practices, and optimization strategies.
- Contributed significantly to the organization''s productivity by maintaining high availability and reliability of critical database systems.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Developed custom scripts to automate routine tasks, resulting in significant time savings for the team.
- Led successful migration projects from legacy systems to modern database platforms while minimizing downtime risks.
- Identified opportunities for cost savings through effective capacity planning and resource allocation decisions in large-scale database environments.
PAYMAYA, INC.
SENIOR DATABASE ENGINEER
01.2016 - 12.2016
Job overview
- Improve data collection by automating workflows by Installing, deploying Apache Airflow.
- Creation of ETL scripts using shell, python, Pyspark. Creating, building, maintaining and monitoring data pipelines from multiple data sources into central location like data lake and data warehouse.
- Collaboration with diversified teams like data architects, data scientists, marketing, and application developers on projects relevant to Big Data, Machine Learning, and AI.
- Manages and oversees the operation of on-premises database management systems like MySQL, Oracle, PostgreSQL and AWS Redshift.
- Formulates automated backup and restoration using Bash and Python for all on-premises Oracle and MySQL databases.
- Primary representative in charge of DBA compliance with PCI-DSS.
- Automate the data collection and processing and transformation and conversion of various data format like excel, CSV, text, Jason files using AWS services, such as AWS SNS, Lambda, Data Lake Formation, and Microsoft PowerApps.
VOYAGER INNOVATIONS, INC.
SENIOR DATABASE ADMINISTRATOR
01.2015 - 12.2015
Job overview
- Configured the server to protect, strengthen, and improve the system according to the Company's security standards by using secured ports, eliminating unnecessary access controls, activating firewalls, and following best-practice procedures.
- Manage on-premises systems and databases such as Oracle Red hat 8, Oracle 12, MySQL and PostgreSQL.
- Manages daily system and database operations, as well as managing, patching, and upgrading. Actively inspect the database's health and performance to prepare for future growth and modifications to the system.
- Configured the server to protect, strengthen, and improve the system according to the Company's security standards by using secured ports, eliminating unnecessary access controls, activating firewalls, and following best-practice procedures.
- Delivered several PL/SQL for certain projects. Review developer SQL queries and optimize scripts if needed. Review table indexes and structure to ensure optimal database usage.
- Design, plan, create, and test backup and recovery(non-man) procedures for databases to ensure data integrity and availability and data disaster preparedness.
- Part and oversee of 24/7 rotational operation and maintenance database support.
- Handle Oracle Tablespace and Datafile management for on-premises Oracle Storage.
- Install, configure, deploy MySQL Master-Slave replication.
CHIKKA PHILS.
LEAD DATABASE ADMINISTRATOR
05.2011 - 12.2014
Job overview
- Perform wide variety of responsibilities as a MySQL Database Administrator Leader working primarily on Maintaining more than 100 MySQL and 5 Oracle Database of all Chikka Services and micro-services.
- Develop, deploy, and maintain MySQL master-slave replication to increase database availability.
- Provides basic SQL and optimization training to the NOC group. By the user workshops and mentoring programs provided by our team, ensure that database technical and functional designs and operations meet business requirements. Produced operational and monitoring manuals for NOC.
- Spearhead Research and Development and perform POC that pertains database management system including SAN storage backup using LVM/ISCSI and data warehousing using AWS Redshift.
- Develop backup and recovery strategies for databases that have been designed, planned, created, and tested to guarantee data integrity and availability. Regularly tests the ability of the developed backup recovery to be restored and utilized in disaster recovery procedures.
- Part and oversee of 24/7 rotational operation and maintenance database support.
CHIKKA PHILS.
DATABASE ADMINISTRATOR
12.2008 - 04.2011
Job overview
- Manage Oracle and MySQL Databases.
- Performs regular tests on the backup recovery that has been developed to confirm its ability to be restored and utilized in disaster recovery procedures. Handle regular database backup.
- Regularly evaluates the capacity of the developed backup recovery to be restored and used in disaster recovery procedures.
- Conduct routine maintenance, including patching and upgrades, and handle issues with database connectivity.
- Part and oversee of 24/7 rotational operation and maintenance database support.
- Install and configure MySQL, Oracle, PostgreSQL databases. Deploy and configure MySQL Master-slave replications.
NEXTEL PHILIPPINES
DATABASE ADMINISTRATOR
10.2007 - 12.2008
Job overview
- Team Lead for VoIP Service Group. Oversee system/database and telephony operations and maintenance.
- Part and oversee 24/7 operation, maintenance, IP telephony and DID number provisioning.
- Manages and operate VoIP Billing and pre-paid system running on MySQL and MS SQL Server databases and servers respectively.
- Installs and configures UNIX/Oracle/SQL Server-based infrastructure for in-house software development team.
- Provide basic training to other staff as required.
- Evaluate and oversee the daily activities of the rank-and-file staff.
- Handed out work modules, operational manuals, and daily duties to the staff.
- Direct Coordination with Vendor and partner and reseller for VoIP services on operational support, installation.
NEXTEL PHILIPPINES
DATABASE ADMINISTRATOR
10.2003 - 09.2007
Job overview
- Team Maintenance of Nextel's prepaid and postpaid database servers, which run on MS-SQL 2000.
- Manage and install Oracle Databases (versions 7.3.4 and 8.0), which also involves maintaining Nextel's Billing and Rating Database.
- Create Backup Process for Oracle Database. Maintains Nextel's prepaid system.
- Installs and configures UNIX/Oracle/SQL Server-based infrastructure for in-house middleware/application development team.
- Perform routine maintenance, which includes patching and upgrades, and address database connectivity issues.
- Implement and enforce database security policies and procedures, including access controls, to protect against vulnerabilities. Establish privileges based on roles for both users and applications users.
- Provides technical recommendations to Management. Team Lead on UNIX and Oracle Database administration team.
- Part of 24/7 Operation Support.
- Ensure that backup copy is compliant with the disaster and recovery and database cloning by actively testing backup files.
NEXTEL PHILIPPINES
ASSOCIATE DESKTOP ENGINEER
06.2003 - 09.2003
Job overview
- Team Performs hardware and software evaluation, installation, configuration, and maintenance of the end users' desktop computers.
- Creates and implements end user support plans and strategies. Performs network installation and cabling.
- Provides on-site, off-site and helpdesk support from remote users.
- Supervises and provides hands-on training for interns detailed at the company.
- Performs system backup of HP-UX and Oracle database systems. Administers Lotus Domino/Notes groupware system.
- Identify, evaluate, and fix printers at 4 Nextel business centers.
- Handles day-to-day on-premises Desktop/application support for Call Center.
- Installation and deployment of Desktop, cabling, printers for Business Centers.
- Installation and configuration of Oracle Forms and applications.
Education
NIIT MAKATIMakati City, Metro Manila, Philippines
No Degree from Web Programming with Java
04.2001
UNIVERSITY OF THE EASTCaloocan City, Metro Manila, Philippines
Bachelor of Arts from Communication Arts
04.2001
ARELLANO UNIVERSITYMalabon, Metro Manila, Philippines
High School Diploma
04.2001
Skills
Experience with UNIX/Linux systems
Proficient in MySQL, Oracle, and PostgreSQL
Python and Bash automation
Database administration
ETL workflow management
SQL query enhancement techniques
Data analysis
Server virtualization expertise
Skilled in implementing containerization solutions
Experience with AWS cloud solutions
Experience with Databricks
Data migration
Performance tuning
Disaster recovery planning
Collaborative project engagement
System architecture
Team mentorship
Operational support
Database performance optimization
Python programming
SQL and databases
Certification
RCHSA Dec 11, 2014 (license 140-233396)
Timeline
SENIOR DATABASE ENGINEER SPECIALIST
MAYA, INC.
01.2017 - 07.2023
SENIOR DATABASE ENGINEER
PAYMAYA, INC.
01.2016 - 12.2016
SENIOR DATABASE ADMINISTRATOR
VOYAGER INNOVATIONS, INC.
01.2015 - 12.2015
LEAD DATABASE ADMINISTRATOR
CHIKKA PHILS.
05.2011 - 12.2014
DATABASE ADMINISTRATOR
CHIKKA PHILS.
12.2008 - 04.2011
DATABASE ADMINISTRATOR
NEXTEL PHILIPPINES
10.2007 - 12.2008
DATABASE ADMINISTRATOR
NEXTEL PHILIPPINES
10.2003 - 09.2007
ASSOCIATE DESKTOP ENGINEER
NEXTEL PHILIPPINES
06.2003 - 09.2003
NIIT MAKATI
No Degree from Web Programming with Java
04.2001
UNIVERSITY OF THE EAST
Bachelor of Arts from Communication Arts
04.2001
ARELLANO UNIVERSITY
High School Diploma
04.2001
TRAININGS AND WORKSHOP
- CCNA Masterclass Apr 17-23 2023
- MySQL Tuning Oct 14-18 2013
- MySQL High-Availability Nov 7-9 2012
- Mysql 5 Jan 9-13 2010
- Administration Asterisk VoIP Fundamentals April 24-28 2006
- Oracle 9i Fundamental 2 May 21-27 2005
- Oracle 9i Fundamental 1 Nov 8-12 2004
- HP-UX System and Network Administration 1 May 17-21 2004
- Administering MS SQL Server 2000 Apr 19-23 2004