Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

MARTINS ADEDIPE

York,PA

Summary

I am a highly skilled and experienced Database Administrator (DBA) with 8 years of dedicated expertise in Microsoft SQL Server (MSSQL) and MariaDB database management. My career objective is to leverage my extensive knowledge and proficiency in both MSSQL and MariaDB to contribute significantly to an organization’s success while continuously expanding my skill set.

  • Dedicated and highly skilled DBA with a proven track record in MySQL, MSSQL, Postgres, and cloud-based database administration.
  • Seven-plus years of expertise in database design, performance optimization, and disaster recovery planning.
  • The adept user of advanced tools such as gh-ost and PT-OSC for online schema changes.
  • Quick learner, team-oriented, and experienced in a fast-paced, cloud-centric environment (AWS).
  • Proficient in various programming languages, automation tools, and networking protocols.
  • Committed to continuous learning and excellence in all aspects of database administration.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Application Database Administrator

TNS
Reston, VA
02.2022 - Current
  • Replication Manager and Cluster Monitoring: Utilized Replication Manager to monitor applications across large clusters.
    Managed semi-sync replication between a single master and slave setup.
  • Database Partitioning: Partitioned 2TB databases using the HARSH partitioning method.
    Improved query performance and optimized storage utilization.
  • Performance Optimization and Monitoring: Daily monitoring of slow queries using Pt-query-Digest.
    Optimized fragmented tables resulting from frequent DML statements.
    Implemented database AUDIT for all production databases.
    Monitored the Imported Database daily to ensure all Tables were successfully imported
  • High Availability and Disaster Recovery: Set up and troubleshooted MariaDB GTID replication in both production and non-production environments.
    Set up AlwaysOn Availability Group(MSSQL) using both automatic seeding and joint methods of database synchronization. Configure Pglogical (PostgreSQL)bidirectional replication to meet high availability customer requests and policy.
  • MariaDB Replication: Provided expert-level support and guidance on both traditional asynchronous replication and cutting-edge features like Galera Cluster.
    Enabled seamless data replication and failover capabilities across geographically dispersed data centers.
  • Continuous Learning and Knowledge Sharing Actively participated in forums and training programs to stay abreast of the latest advancements and best practices in database administration and replication technologies.Proactively engaged in knowledge sharing within the team.

Snr Database Administrator/Developer Consultant

BOFFMOBILE
Texas City
01.2019 - 02.2022
Managed Services and Cloud Deployment
  • Complete managed services for all aspects of MySQL database and application infrastructure.
  • Collaborated with various clients to maintain and manage their MySQL databases both on-premises and in AWS.
  • Played a key role in the team that successfully migrated MySQL from on-premises to the cloud.
Backup and Recovery Strategies
  • Developed robust backup and recovery strategies for MySQL databases.
  • Conducted MySQL health checks and ensured data integrity.
Disaster Recovery and High Availability
  • Restored MySQL RDS instances via automated snapshots during disaster recovery scenarios.
  • Set up MySQL High Availability by creating replicas for RDS instances.
  • Configured alarms for MySQL RDS to proactively monitor database health.
Database Creation and Performance Optimization
  • Created various RDS MySQL databases to support the environment.
  • Collaborated with clients to resolve performance issues and enhance database efficiency.
24x7 Support and Production Management
  • Provided 24x7 on-call support for database performance as needed.
  • Supported, managed, and troubleshooted live production systems.
Maintenance and Backup Solutions
  • Maintained, monitored, tuned, and supported existing MySQL database environments for production, staging, QA, and development.
  • Set up, troubleshooted, and fixed backups using tools such as Mydumper and Percona Xtrabackup.

Database Administrator

PHONEDEPOT/TOPUPBILLS
New Jersey
12.2016 - 12.2018
MySQL Administration and Troubleshooting
  • Installation, configuration, maintenance, and troubleshooting of MySQL databases.
  • Created robust backup and recovery strategies to ensure data integrity.
  • Addressed issues related to log files reaching capacity and database size exceeding thresholds.
Performance Optimization and Upgrades
  • Implemented performance optimization procedures for efficient database applications.
  • Successfully upgraded MySQL database servers from one version to another.
  • Developed action plans for various projects, including upgrades, patching, and backups.
Collaboration and Monitoring
  • Collaborated with development and application teams for database-related changes.
  • Monitored databases for potential issues and proactively resolved them.
Query Optimization and Table Management
  • Fixed slow-running queries to enhance developer productivity.
  • Partitioned various tables to improve overall database performance.
  • Optimized tables to prevent database and table fragmentation.

Education

Bachelor of Science - Software Engineer

Western Governors University
Salt Lake City, UT
01-2024

Some College (No Degree) - Botany

OAU
Ile-Ife Osun State
05-2012

Skills

Technical Skills Database Management System
  • MariaDB
  • MySQL
  • MSSQL
  • PostgreSQL
Programming Languages
  • T-SQL
  • C
  • Python
  • Java
  • HTML
Scripting and Operating Systems
  • Bash Scripting
  • Windows 2008/2010 Servers
  • Linux
  • MacOS
Additional Skills
  • Strong passion for learning new skills
  • Excellent communication skills
  • Attention to detail
Database and Tools
  • Ansible
  • Git
  • MySQLdump/MySQLimport
  • Pg_dump/Pg_restore
  • SSIS (SQL Server Integration Services)
Replication Technologies
  • SQL Server Always On Availability Groups
  • PostgreSQL Streaming Replication
  • PostgreSQL Pglogical Replication
  • MariaDB Replication
  • MariaDB Galera Cluster

Certification

  • MTA Database Foundation
  • ITIL 4 Foundation (ITIL 4)

Timeline

Application Database Administrator

TNS
02.2022 - Current

Snr Database Administrator/Developer Consultant

BOFFMOBILE
01.2019 - 02.2022

Database Administrator

PHONEDEPOT/TOPUPBILLS
12.2016 - 12.2018

Bachelor of Science - Software Engineer

Western Governors University

Some College (No Degree) - Botany

OAU
MARTINS ADEDIPE