John Alfred Alcantara
System Engineer - Database
Quezon City
Summary
Dedicated Data Admin/Engineer with a proven track record in optimizing database performance, designing robust data architectures, and implementing efficient ETL processes. Skilled in database security management, disaster recovery planning, and data warehouse design. Adept at leveraging innovative technologies to ensure data integrity, reliability, and availability for informed decision-making. Strong problem-solving abilities coupled with a commitment to continuous improvement and delivering high-quality solutions.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
6
6
Certifications
Work History
Associate System Engineer
Grundfos
08.2021 - Current
- Optimized database performance by analyzing query execution plans, identifying bottlenecks, and implementing indexing strategies.
- Involved on data migration projects, ensuring smooth transition of data from legacy systems to modern platforms.
- Implemented robust security measures to safeguard sensitive data, including role-based access control, encryption, and data masking techniques.
- Designed and implemented disaster recovery strategies to minimize data loss and ensure business continuity in event of system failures or disasters.
- Designed and maintained data warehouse architectures to support analytical reporting and business intelligence initiatives.
- Implemented proactive monitoring solutions to detect and address performance issues, database errors, and resource utilization anomalies.
Database Administrator
Land Registration Systems Inc
06.2018 - 07.2021
- Implement proactive monitoring solutions to ensure health and performance of SAP Sybase ASE and MS SQL instances.
- Oversee installation and configuration of Sybase DB, PostgreSQL, MSSQL DB, and Replication servers across Red Hat Linux and Windows Server platforms.
- Execute routine maintenance tasks, including database upgrades, patching, and backup/restore operations, for over 1000+ databases.
- Implement space management strategies to optimize database storage utilization and prevent data fragmentation.
- Manage SQL Server databases hosted on AWS Relational Database Service (RDS), ensuring efficient utilization and integration of cloud resources.
- Conduct thorough performance tuning and optimization activities across database environment to enhance overall system performance.
Education
Bachelor of Science - Computer Science
07.2016 - 05.2018
Associate of Science - Computer Science
07.2012 - 05.2014
Skills
Database Management Systems (DBMS)
SQL and Query Optimization
ETL Tools and Data Integration
Database Security
Data Modeling and Warehousing
Monitoring and Performance Tuning
Scripting and Automation
Certification
Microsoft Certified: Azure Data Engineer Associate
Timeline
Associate System Engineer - Grundfos
08.2021 - Current
Database Administrator - Land Registration Systems Inc
06.2018 - 07.2021
Colegio De San Lorenzo - Bachelor of Science, Computer Science
07.2016 - 05.2018
Asian Institute of Computer Studies - Associate of Science, Computer Science
07.2012 - 05.2014