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.
- Developed robust backup and recovery strategies for MySQL databases.
- Conducted MySQL health checks and ensured data integrity.
- 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.
- Created various RDS MySQL databases to support the environment.
- Collaborated with clients to resolve performance issues and enhance database efficiency.
- Provided 24x7 on-call support for database performance as needed.
- Supported, managed, and troubleshooted live production systems.
- 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.
- 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.
- Collaborated with development and application teams for database-related changes.
- Monitored databases for potential issues and proactively resolved them.
- 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, UT01-2024
Some College (No Degree) - Botany
OAU
Ile-Ife Osun State05-2012
Skills
Technical Skills
Database Management System
- MariaDB
- MySQL
- MSSQL
- PostgreSQL
- T-SQL
- C
- Python
- Java
- HTML
- Bash Scripting
- Windows 2008/2010 Servers
- Linux
- MacOS
- Strong passion for learning new skills
- Excellent communication skills
- Attention to detail
- Ansible
- Git
- MySQLdump/MySQLimport
- Pg_dump/Pg_restore
- SSIS (SQL Server Integration Services)
- 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