Summary
Overview
Work History
Education
Skills
Certification
Timeline
John Alfred Alcantara

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

Colegio De San Lorenzo, Metro Manila, Philippines
07.2016 - 05.2018

Associate of Science - Computer Science

Asian Institute of Computer Studies, Metro Manila, Philippines
07.2012 - 05.2014

Skills

    Database Management Systems (DBMS)

undefined

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

Microsoft Certified: Azure Data Engineer Associate

Microsoft Certified: Azure Database Administrator Associate

Microsoft Certified: Azure Data Fundamentals

Microsoft Certified: Azure Fundamentals

Oracle Cloud Data Management 2023 Certified Foundations Associate

ITIL 4 Foundation

John Alfred AlcantaraSystem Engineer - Database