Accomplished database specialist with extensive expertise in managing and optimising databases, including MS SQL Server, PostgreSQL, Cassandra, and MariaDB. Proficient in data migration, ETL processes, and data integration, ensuring seamless data flow and security. Demonstrates strong skills in database design, development, and administration with a focus on backup and recovery techniques. Committed to enhancing database performance through strategic optimisation and management. Aspires to leverage technical skills to drive innovative solutions in data management.
Overview
10
10
years of professional experience
2014
2014
years of post-secondary education
1
1
Certification
Work History
Database Architect
TeesoftTech Innovation Limited
Remote
01.2023 - 01.2025
Reviewed design of existing databases being used currently for optimization (MS SQL Server, PostgreSQL, Cassandra, and MySQL)
Developed and enforced database security measures to protect sensitive information
Evaluated emerging technologies for potential adoption in enhancing database architectures
Built highly available, secure and performance efficient database infrastructure to satisfy business needs
Implement high availability solution (Always On, Log Shipping, Mirroring and Replication)
Participate in migration scripts review, acceptance and optimization of queries
Work closely with developers to help design the needed database structures, solve problems and optimize the performance of key database component
Mentor and tutor other developers on effective SQL writing skills
Database monitoring and performance optimization (DMVs and DMFs, SQL Profiler, pgwatch2)
Migrations of Premise database to Azure using Azure using Data Migration Assistant (SQL server)
Migrations of MySQL and PostgreSQL to MS SQL Server using Data Migration Assistant (MySql), pgloader and Pentaho
Migration of data from SQL Server to Data warehouse using SSIS and SSDT
Senior Database Administrator
Renmoney Microfinance Bank
Ikoyi, Nigeria
07.2022 - 12.2022
Developed a disaster recovery and data protection plan to enable the continuation of infrastructure and prevent disruption/system failure for quick and easy data recovery in the event of a disaster or cyber-attack
Developing complex business reports
Processing data migration and replications for system implementation, upgrade, consolidation, and server replacements
Optimizing queries for retrieving and updating data
Utilizing MS SQL/MySQL, data warehousing programs, Power BI, Tableau and other dashboard/visualization toolsets for data intelligence and analysis
Enterprise business application support
Monitoring replication, performance and integrity of the entire database system
Automating EOD processes
Team-lead Database Administrator / Enterprise Application Support
NSIA Insurance LTD
Victoria Island, Nigeria
11.2019 - 06.2022
Ensured seamless operations of the enterprise system applications through management of all API software integrations
Developed complex business reports to display data and track performance
Data migration and replications
Utilized MS SQL, data warehousing programs, Power BI, Tableau and other dashboard/visualization toolsets for data intelligence and analysis
Developed a disaster recovery and data protection plan
Designed a secure database for customer portal to share, view, and update data
Enterprise business application support
Monitored replication, performance and integrity of the database
Team-lead Database Administrator / ERP Support
Berger Paints Nigeria PLC
Ikeja, Nigeria
11.2018 - 10.2019
Developed database designs for creating a visual representation of data according to database models
Supported core business solution (Microsoft Navision)
Utilized MS SQL, data warehousing programs, Power BI, Tableau and other dashboard/visualization toolsets for data intelligence and analysis
Monitored 100% replication, performance and integrity of the database
Specified user access levels for each segment of databases
Identified functional and business requirements to meet business needs
Developed and implemented security initiatives for data protection and security
Strictly monitored databases to quickly resolve database performance and ensure improved database performance
Team-lead Database Administrator / Enterprise Application Support
Intteck Global System LTD
Ikeja, Nigeria
11.2016 - 11.2018
Supervised and managed IT projects (as Team Lead)
Customized existing solution to meet organization need
Database design and management (MS SQL Server)
Development of DR Plans and implementation
Deployed and managed software applications
Business software requirement analysis
Developed a plan for coding, testing/debugging, and quality assurance
Developed and upgraded new and existing software system application
User requirement gathering and training
Troubleshot for identifying and resolving of technical issues
Database Administrator / Enterprise Application Support
Intteck Global System LTD
Ikeja, Nigeria
11.2015 - 11.2016
Supervised and managed IT projects (as Team Lead)
Customized existing solution to meet organization need
Database design and management (MS SQL Server)
Development of DR Plans and implementation
Deployed and managed software applications
Business software requirement analysis
Developed a plan for coding, testing/debugging, and quality assurance
Developed and upgraded new and existing software system application
User requirement gathering and training
Troubleshot for identifying and resolving of technical issues
Computer Science Teacher
Remedial College
Ise-Ekiti, Nigeria
11.2014 - 10.2015
Taught and wrote lesson notes for students
Supervised maintenance, repair, and installation of computers
Set examination questions and invigilated examination rooms
Marked and prepared assessment card to evaluate students' performance
Education
Bachelor of Science - Computer Science
University of Ilorin
Ilorin, Kwara State
Scrum Master - undefined
International Scrum Institute
Skills
Databases (MS SQL Server, PostgreSQL, Cassandra and MariaDB)
International Scrum Institute, Switzerland, Scrum Master, 45146622717380, 2021
Custom
Udemy, Microsoft SQL Server 2012-2019 Certification Training (2022), The Python Mega Course (2022), Data Warehouse Ultimate Guide (2022), Microsoft SQL Server 2012/2014 Certification Training 70-462 (2022), PostgreSQL Administration Certification Training (2022)
LinkedIn, Advanced SQL for Query Tuning and Performance Optimization (2021), Microsoft SQL Server 2019 Essential Training (2021)
Deloitte, Nigeria, Data Protection and Data Privacy (2020)
Performance Frontiers, Ilupeju, Lagos, Nigeria, Customer Service Training (2018)
Languages
English
Native
Timeline
Database Architect
TeesoftTech Innovation Limited
01.2023 - 01.2025
Senior Database Administrator
Renmoney Microfinance Bank
07.2022 - 12.2022
Team-lead Database Administrator / Enterprise Application Support
NSIA Insurance LTD
11.2019 - 06.2022
Team-lead Database Administrator / ERP Support
Berger Paints Nigeria PLC
11.2018 - 10.2019
Team-lead Database Administrator / Enterprise Application Support
Intteck Global System LTD
11.2016 - 11.2018
Database Administrator / Enterprise Application Support
Intteck Global System LTD
11.2015 - 11.2016
Computer Science Teacher
Remedial College
11.2014 - 10.2015
Scrum Master - undefined
International Scrum Institute
Bachelor of Science - Computer Science
University of Ilorin
Similar Profiles
RANJAN MPRANJAN MP
Program Lead - Offline Expansion at Vedantu Innovation Private LimitedProgram Lead - Offline Expansion at Vedantu Innovation Private Limited
Operations Executive at (2050 HEALTHCARE) INGENUITY AND INNOVATION GLOBAL EDUHEALTH PRIVATE LIMITEDOperations Executive at (2050 HEALTHCARE) INGENUITY AND INNOVATION GLOBAL EDUHEALTH PRIVATE LIMITED