Thor Jan Dagman
Database Administrator
Paniqui
Summary
Accomplished Database Administrator with a proven track record. Expert in MySQL optimization and administration and excels in collaborative environments. Skilled in technical advancements and team mentorship, I deliver efficient database solutions and foster productive team dynamics. Currently learning python to enhance my skills and diving to data engineering.
Overview
12
12
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work History
Database Administrator
Archax
11.2022 - 05.2024
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Coordinated with project management on database development timelines.
- Modified databases to meet needs and goals determined during planning process.
Database Administrator
Digital Room Inc.
07.2021 - 11.2022
- Administered, supported and monitored various AWS Database deployments (RDS, EC2 ,MySQL Aurora, Sql Server, PosgreSQL, Redshift) by proactively resolving database issues and maintaining servers.
- Setup and maintained native, multi source, and AWS RDS MySQL replication.
- Prepare and facilitate RDS and Aurora MySQL version upgrade
- Setup and optimize RDS MySQL parameter groups
- Closely coordinate with project management, developers and DevOps in preparing and deploying of database updates or changes
- Setup and maintained MySQL user access and coordinate with DevOps for the related AWS secrets.
- Proactively monitor slow SQL queries using AWS cloudwatch, percona pt-query-digest and Moyog then prepare optimized alternative SQL for flagged SQL queries.
- Monitor RDS MySQL and MySQL Aurora audit log and error log using AWS cloudwatch
- Setup and maintained various types of DMS tasks in in AWS Database Migration Service
- Setup data archiving process for MySQL databases using pt-archive
- proactively monitor, develop and maintained various MySQL objects like tables,events, triggers and stored routines and make suggestions for any changes that could benefit the database
- Worked with various steams to develop and optimize application SQL statements .
- Create shell scripts with varying requirements and schedule it via crontab
- Prepare ETL scripts using talend
Database Developer
Leekie Enterprises Incorporated
02.2015 - 02.2021
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers in coordination with system administrator.
- Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
- Coordinate with other software development teams to deliver applications with efficient and optimized database usage.
- Coordinate with project management staff on database development timelines and project scope.
- Established open and professional relationships with team members which helped resolve issues and conflicts quickly.
- Conducted training and mentored team members to promote productivity, accuracy and collaboration between other teams.
- Set up and controlled database users and access levels to protect important data.
- Created scripts and processes for data integration and maintenance.
- Created and implemented database designs and data models.
- Continually improved knowledge, skills and performance based on feedback and self-identified professional developmental needs.
- Worked to maintain outstanding attendance record, consistently arriving to work ready to start immediately.
- Designed efficient databases in accordance to software specifications
- Created and maintain database warehouses
- Optimized existing databases. Able increase performance up to 200% of most problematic queries
- Optimized SQL queries by identifying slow queries
- Develop multiple stored routines for multiple applications
Programmer
Provincial Government of Tarlac
01.2013 - 02.2015
- Designed, Develop and maintained web based inventory application. Sped up creation of major reports by 47900% (from days to minutes).
- Designed, Develop and maintained HR information system using MS access.
- Operated and maintained SMS messaging software which is used for sending news and job alerts around province.
- Assisting Accounting Department with their SQL queries.
- Advices Technical specifications for computer hardware procurement.
- Occasional computer repair and maintenance when there is no computer technician available.
Virtual Library Administrator
Pfizer Incorporated
10.2012 - 01.2013
- Computer troubleshooting and maintenance.
- Assisted Doctors on how to effectively use internet for medical journal research.
- Prepares office for big power point presentations
Education
Bachelor of Science - Information Technology
Saint Louis University
Baguio 06.2007 - 10.2011
Skills
SQL
MySQL Database Development and Design
MySQL Query Optimization
MySQL Administration
Shell Scripting
Database Migration and ETL using Talend
Data Warehousing Design and Development
Python
Certification
Oracle Certified Associate, MySQL 5
Accomplishments
Outstanding Performance Awardee - 2020
Employee of the Year Awardee - 2019
Employee of the Year Awardee - 2018
Employee of the Year Awardee - 2016
Trainings
MySQL for Database Administrators Ed 5.1 - May 2020
Languages
Tagalog
Upper intermediate
English
Intermediate
Character References
David Allen
Chief Technology Officer
Vista Resource Group
https://www.linkedin.com/in/requnix/
david.allen@requnix.com
(US) 775.235.8465
Dipl.-Inf. Rio Jusuf
IT Manager
Leekie Enterprises Incorporated
r.jsu@leekie.com
+639178839338
Aldrin Gauran
Senior Application Development Specialist
Accenture
aldrin.gauran@gmail.com
+639152387859
Timeline
Database Administrator
Archax
11.2022 - 05.2024
Database Administrator
Digital Room Inc.
07.2021 - 11.2022
Database Developer
Leekie Enterprises Incorporated
02.2015 - 02.2021
Programmer
Provincial Government of Tarlac
01.2013 - 02.2015
Virtual Library Administrator
Pfizer Incorporated
10.2012 - 01.2013
Oracle Certified Associate, MySQL 5
10-2011
Bachelor of Science - Information Technology
Saint Louis University
06.2007 - 10.2011
Similar Profiles
Edmar BacaniEdmar Bacani
VIRTUAL ASSISTANT at LOTUS TICKETS LLCVIRTUAL ASSISTANT at LOTUS TICKETS LLC
KATHLEEN LOMBOYKATHLEEN LOMBOY
Government Compliance Staff/Taxation Staff at Philippine Spring Water Resources, Inc.Government Compliance Staff/Taxation Staff at Philippine Spring Water Resources, Inc.
LEMA ISLALEMA ISLA
Financial Accountant at Oscars Hotels GroupFinancial Accountant at Oscars Hotels Group