Summary
Overview
Work History
Education
Skills
Timeline
Generic

DANIEL ASARE

Summary

Results-driven Database Administrator with over 8 years of specialized expertise in MySQL and PostgreSQL systems. Proficient in capacity planning, performance optimization, and database maintenance, with hands-on experience in user management, high-availability replication, including Galera Cluster, monitoring, and troubleshooting. Skilled at optimizing cloud infrastructures, including AWS and GCP, to enhance system performance and reliability. Adept at MySQL/PostgreSQL programming, including functions, views, partitioning, stored procedures, and triggers. Proven track record in deploying scalable database solutions, reducing operational costs, and integrating cutting-edge technologies to drive efficiency. Experienced in utilizing monitoring and ticketing tools to ensure seamless service delivery and operational excellence.

Overview

9
9
years of professional experience

Work History

Database Administrator

Data Heart Consulting
03.2022 - Current
  • Handled general DBA duties such as creating databases, managing storage, maintaining schemas, and resolvingdata-related issues, ensuring reliable database performance.
  • Specialized in MySQL backup and recovery using third-party tools like mydumper and myloader, providing quick and efficient data recovery.
  • Conducted Sysbench tests for database benchmarking, identifying performance bottlenecks and optimizing configurations, ensuring peak system efficiency.
  • Successfully upgraded MySQL from versions 5.0 to 8.0 on Linux, minimizing downtime and ensuring seamless transitions.
  • Assisted with database sizing, query optimization, and buffer tuning, enhancing performance and resource efficiency.
  • Leveraged Unix/Linux shell commands to streamline database management and troubleshooting, boosting operational effectiveness.
  • Acted as a system manager, troubleshooting and reviewing databases, promptly addressing issues to maintain system integrity.
  • Configured and maintained Master-Slave and Master-Master replication setups, guaranteeing high availability and data synchronization.
  • Provided in-depth expertise on MySQL versions 5.0 and later, ensuring optimal performance and compatibility across environments, ensuring smooth operations across systems.
  • Managed user permissions and accounts, implementing access control aligned with organizational policies, fortifying database security.
  • Administered IP restrictions, enhancing security by preventing unauthorized access, ensuring strong protection of sensitive data.
  • Developed Linux scripts using Percona XtraBackup, ensuring data recovery aligns with disaster recovery strategies and enhancing overall system resilience.
  • Installed MySQL using RPM and binary files, customizing setups to meet performance requirements, optimizing for specific operational needs.
  • Expert in MyISAM, INNODB, and Memory Engine, optimizing data storage and retrieval processes, improving query and storage efficiency.
  • Optimized and tuned queries to resolve slow performance, reducing query execution times and improving system responsiveness.
  • Utilized ticketing tools like Jira, Kintana, ServiceNow, and CRM, managing and tracking activities, enhancing workflow organization.
  • Collaborated with the development team, providing prioritization and guidance on transformations and implementations, ensuring smooth project delivery.
  • Analyzed logs (general, error, and binary) to maintain system reliability, addressing any issues that arose, boosting troubleshooting efficiency.
  • Managed backup operations with customized parameters, ensuring appropriate data protection strategies, ensuring robust data protection.
  • Monitored the health of replication setups, addressing potential issues proactively, maintaining replication integrity and performance.
  • Implemented partitioning and optimized indexing strategies, boosting data retrieval speed and scalability.
  • Deployed and managed Galera Cluster for MySQL, ensuring high availability, data redundancy, and real-time synchronization, improving system reliability.
  • Reviewed and enhanced documentation, ensuring it aligns with best practices, maintaining up-to-date and accurate records.
  • Applied AWS security groups, setting up RDS PostgreSQL instances, and using SSL with PostgreSQL DB, ensuring secure cloud operations.
  • Proficiently managed RDS MySQL and PostgreSQL environments, using EC2 instances to enhance scalability, optimizing cloud operations.
  • Configured and maintained Amazon S3 buckets for scalable, secure data storage, reducing storage costs while ensuring data safety.
  • Designed and managed VPC environments, isolating networks and securing database systems, ensuring compliance with organizational security requirements.
  • Set up multi-region replication and multi-AZ deployment of RDS instances, providing robust disaster recovery solutions.
  • Leveraged AWS Performance Insights and Enhanced Monitoring, offering proactive monitoring for improved performance tracking, ensuring high database availability.

Database Administrator

Aarons of CT LLC.
04.2020 - 12.2021
  • Configured SSL for PostgreSQL DB Instances, ensuring secure connections.
  • Imported data into Amazon RDS PostgreSQL and set up instances for optimal operation.
  • Set up parameter groups and features, understanding best practices for instance management.
  • Established high availability and failover support for AWS RDS PostgreSQL, enhancing uptime.
  • Proficient in AWS security groups, ensuring secure RDS PostgreSQL operations.
  • Monitored activity and performance of AWS RDS using CloudWatch for proactive management.
  • Managed PostgreSQL roles and access, ensuring proper security and permissions.
  • Utilized Performance Insights and Enhanced Monitoring for in-depth AWS RDS performance tracking.
  • Understanding of instance classes, storage types, and Provisioned IOPS in Amazon RDS for effective resource allocation.
  • Coordinated PostgreSQL database administration to ensure accurate, effective data use.
  • Installed, configured, monitored, and upgraded PostgreSQL databases, optimizing performance.
  • Reduced downtime by implementing proactive monitoring and automated procedures.
  • Proactively identified and resolved live database system issues, minimizing disruption.
  • Applied knowledge of disaster recovery principles, including planning, testing, and recovery.
  • Monitored and optimized PostgreSQL performance, diagnosing and resolving issues promptly.
  • Managed and monitored database indexes for enhanced query performance.
  • Performed schema management, database sizing, and privilege maintenance, ensuring efficiency.
  • Reviewed and implemented database schema changes, enhancing system performance.
  • Experienced in PostgreSQL monitoring tools for tracking database health and performance.
  • Proficient in Unix/Linux shell commands, automating routine tasks and troubleshooting.
  • Implemented and monitored replication for high availability and disaster recovery scenarios.
  • Performed database upgrades, reducing downtime by testing in dev and test environments.
  • Efficiently worked with tools like PgAdmin and Putty for database management.
  • Skilled in designing database structures, views, indexes, and partitioning for scalability.
  • Monitored databases using tools like PMM, identifying and addressing performance issues.
  • Executed logical and physical backup and recovery, ensuring data integrity.
  • Experience with backup utilities like pg_dump, pg_dumpall, pg_basebackup, and pg_barman for reliable recovery.
  • Provided 24x7 on-call support, working as part of a team to ensure database uptime.
  • Experience with Point-In-Time Recovery, ensuring quick restoration of databases.
  • Implemented monitoring solutions for both on-premise and cloud servers, maintaining uptime.
  • Developed operating procedures, documenting issues and solutions for enhanced troubleshooting and security.
  • Collaborated effectively with cross-functional teams, facilitating clear communication and task execution.

Database Administrator

Tom's LLC
10.2015 - 03.2020
  • Spearheaded MySQL backup and restoration processes, ensuring data integrity and swift recovery in critical scenarios.
  • Implemented Galera Cluster for MySQL, achieving high availability and fault tolerance, ensuring continuous database operations even in the event of node failures.
  • Configured GTID (Global Transaction ID) replication in MySQL, simplifying failover and ensuring seamless data consistency across replicated databases.
  • Conducted timely MySQL database upgrades, minimizing disruption and maintaining optimal system performance, including version migrations and patching for smooth transitions.
  • Automated MySQL backup procedures using cron jobs and Bash scripting, streamlining the process and ensuring reliable data protection.
  • Optimized MySQL configurations and server variables, significantly enhancing database performance and efficiency.
  • Implemented point-in-time recovery using MySQL binlogs, allowing precise recovery to a specific moment and minimizing data loss.
  • Managed the installation and routine maintenance of MySQL on Linux systems using RPM and binary files, ensuring optimal server configuration.
  • Implemented and maintained MySQL Master-Slave and Master-Master replication, providing high availability and redundancy.
  • Performed routine database maintenance tasks, including backups, restores, and patching, to ensure the health and reliability of MySQL environments.
  • Applied expertise across various MySQL versions, ensuring compatibility and up-to-date security standards.
  • Prioritized data protection in MySQL, implementing security measures to prevent unauthorized access and data breaches.
  • Executed MySQL performance tuning and query optimization, improving data retrieval speed and application response times.
  • Monitored MySQL databases, identifying and resolving performance bottlenecks to ensure high uptime.
  • Assisted senior DBA in managing and troubleshooting complex MySQL database systems, providing valuable support and expertise.
  • Performed in-depth query analysis and optimization, enhancing overall database responsiveness and meeting business needs.
  • Documented MySQL database processes and procedures, ensuring consistency in management practices and knowledge sharing.
  • Applied patches and updates regularly to maintain security and stability in MySQL environments, minimizing vulnerabilities and ensuring compliance.
  • Performed MySQL data backup and restoration using mysqldump, ensuring consistent data preservation and recovery.
  • Troubleshot and resolved MySQL production issues, minimizing operational impact and enhancing system reliability.
  • Addressed real-time MySQL database incidents, providing rapid solutions to maintain continuous service availability.
  • Communicated effectively with team members on MySQL-related issues, promoting a collaborative and informed work environment.
  • Led the installation and management of multiple MySQL instances on single servers, improving resource utilization and service segmentation.

Education

Associate in Science - Nursing

GOODWIN UNIVERSITY
East Hartford, USA
05.2015

Associate in Science - Health Science

GOODWIN UNIVERSITY
East Hartford, USA
05.2011

Skills

  • Proficient in administering MySQL and PostgreSQL RDS on AWS, with experience in database installation, configuration, and performance tuning
  • Skilled in implementing MySQL and PostgreSQL security measures, including IP restrictions, user account creation, and privilege management to ensure data protection
  • Expert in configuring high-availability solutions for MySQL, managing Master-Slave and Master-Master replication for seamless operation and disaster recovery
  • Experienced in database optimization, including data migration, performance tuning, and executing critical data recovery across Linux platforms
  • Competent in utilizing Percona Toolkit for MySQL and PostgreSQL to enhance efficiency and harden server security
  • Proficient in using monitoring tools to oversee database health, ensuring high uptime and resolving issues proactively
  • Skilled in utilizing collaboration tools, including Skype for Business, Google Meet, Zoom, and Microsoft Teams, to facilitate effective communication
  • Well-versed in project management and documentation tools, including Jira, Confluence, and Miro, for efficient team coordination
  • Proficient in automating tasks using Bash scripting, streamlining database operations and system administration
  • Experienced in setting up and managing GTID for MySQL, ensuring consistent and reliable replication
  • Skilled in performing query optimization, reducing execution times and enhancing database efficiency
  • Extensive experience in orchestrating MySQL 57 & 80 upgrades, fine-tuning databases for optimal performance under varying workloads

Timeline

Database Administrator

Data Heart Consulting
03.2022 - Current

Database Administrator

Aarons of CT LLC.
04.2020 - 12.2021

Database Administrator

Tom's LLC
10.2015 - 03.2020

Associate in Science - Nursing

GOODWIN UNIVERSITY

Associate in Science - Health Science

GOODWIN UNIVERSITY
DANIEL ASARE