BUCHI OKOLOJI
Saskatoon,SK
Summary
PROFESSIONAL OBJECTIVE
A T-shaped database administrator professional with over 8+ years of experience in financial industry with history of creating system architectures that reduce costs and streamline operations. Well grounded in the use of nascent technologies to create stress-free operations both on site and via remote locations and online. Talent for creative problem-solving and exceptional service delivery, maintaining 99.99% availability by leveraging high availability technology across cloud-based and on-premise RDMBSs.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Senior Database Architect
BONI IT CONSULTING
10.2023 - Current
- Enhanced database performance by optimizing query design and indexing strategies for more than 10databases.
- Implemented data warehousing solutions for improved analytics and reporting capabilities.
- Increased system reliability with the development of comprehensive backup and recovery plans.
- Reduced data storage costs by designing and implementing efficient database partitioning strategies.
- Migrated 5 legacy systems to newer technologies, reducing costs and enhancing efficiency of computing tasks.
Senior Database Administrator
Central Bank of Nigeria
10.2022 - 09.2023
- Good exposure and deep understanding of database architecture and relational database management systems using MSSQL clustering and high availability solutions
- Developed alerting monitoring system with PowerShell for 20 applications and DBs, monitoring the health of the SQL Server environment, includes disk space management, memory optimization and system uptime, especially during start of business day
- Ensured database access control through implementation of security measures to safeguard databases and sensitive data
- Migrated On-premise 5 SQL server databases to Azure with minimal downtime
- Successfully drafted disaster recovery plans and performed disaster recovery, testing, and execution for business continuity in three sites within expected 15 minutes RTO and RPO, managing business risk
- Ensure data integrity and implemented backup and database recovery strategies with the use of automated jobs
Senior Database Engineer
Nigeria Interbank Settlement System
06.2018 - 09.2022
- Designed, implement and maintained more than 10 product application databases (OLTP and OLAP) to ensure optimal database performance across production and non-prod systems, integrating alerting scripts for backups and administration
- Troubleshooting MSSQL Server performance issues including server configuration, server crashes, deadlocks, and process blocking, indexes, queries, as well as being able to identify network and disk related issues and working on SQL server reporting services
- Implemented SolarWinds DPA database monitoring solution, creating an active overview of the database farm
- Supported upgrades of software packages that work with SQL Server databases for seamless operation and provided administrative support for these packages as required
- Maintained between 99.98%-99.99% service uptime and achieved revenue generation growth by 200% using either Master-slave or active-active replication, ensuring high availability for various RDBMSs
- Documented database management best practices, procedures, and standards within the IT service management framework for reference purposes
- Periodically conducted regular database maintenance tasks such as updates and patches to ensure database security
IT Support/Database Administrator
Nigeria Interbank Settlement System
12.2014 - 05.2018
- Effectively worked with VMware to implement VMware solution for NIBSS reducing bare-metal server purchases by 50%
- Collaborated with development and infrastructure teams to support application requirements, while also providing guidance on database design and best practices ensuring efficient and optimized database operations
- Designed and implemented ETL processes; provide technical design, coding, testing, implementation, maintenance, system, and technical support for data initiatives using industry standard ETL tools
- Provided technical support for SQL Server SSIS, SSAS, SSRS, transaction processing, data access, performance tuning and database recovery
- Carried out capacity review, installed, and configured 20 Database engines (MySQL and SQL server) based on high availability specifications in a large-scale enterprise environment of sizes up to 16TB
- Created, managed, and tested database objects such as stored procedures, functions, triggers, views before deployment using flyway version control to meet urgent business needs and requirements
- Provided on-call operations support and supported hardware/software upgrade projects with impact analysis, fixes, and end-to-end testing
- Supported and collaborated with application team, system administrators and network engineers, provided technical support and expert judgment in design of efficient database structures, and troubleshot database issues
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
- Developed scripts and processes for data integration and maintenance.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Standardized database object naming conventions across multiple systems, resulting in easier management of objects during troubleshooting sessions.
IT Support Specialist
Quantum Digital Technologies
03.2013 - 11.2014
- Responsible for IT asset management for proper streamlined operations
- Provided technical support on time to over 20 users in person or remotely, ensuring quality customer care
- Interfaced with vendors, 3rd-party, OEMs, and contractors to procure IT infrastructure and services within the agreed SLA, increasing sales and customer satisfaction by 98%
Education
M.Sc. - Information technology
University of Lagos, WES CANADA VERIFIED
Lagos2019
B.Sc. - Computer science
Nnamdi Azikiwe University
Awka2011
Skills
- Database Management; Backup and Recovery, Security and Performance Tuning, High Availability; Big Data/Automation; Disaster Recovery, MS SQL clustering and replication; SSAS, SSIS/SSRS (ETL Data pipeline)
- MSSQL server replication (Always-ON, Mirroring, and Log Shipping), Redis/Memcached replication, Linux Administration/Bash Scripting
- Database performance tuning and optimization; Troubleshooting, Windows/Linux Server Administration and replication; VMware Administration,
- Technologies: JIRA, T-SQL, API, JSON, Git; Agile/Waterfall, DevOps, Cloud Tech, Tools: Grafana, AppDynamics, DPA, Confluence, Commvault
- Excellent Communication (verbal, written, presentation), Problem-solving and conceptual skills
- Collaborative skills, Active listening skills, Great attention to detail, Negotiation skills, Mentorship, Learning and Coaching skills
- Organizational & Time Management skills; Interpersonal skills
- Ability to prioritize and multi-task; Adapts easily to change; Ability to work under pressure and inventiveness; Strong analytical skills
Accomplishments
• Maintained between 99.98%-99.99% service uptime and achieved revenue generation growth by 200% using either Master-slave or active-active replication, ensuring high availability for various RDBMSs.
• Deployed web application SSL certificates, ensuring web portals encrypted connection.
• Involved in the building and development of a Tier III data center and the cutover migration of over 200 Servers to the newly built data center.
• Part of the core team that implemented and migrated services to hyperconverged infrastructure for NIBSS to achieve Private cloud.
• Played a key role in the implementation of VMware virtual desktop infrastructure (VDI) on premise to enable
remote work for staff at the start of the COVID-19 pandemic.
• Played a key role in the PCIDSS certification of NIBSS working with QSA 2018,2020 and 2022.
Certification
Microsoft Certified: Azure Database Administrator Associate (DP-300)
AWS Certified Cloud Practitioner (AWS CCP)
Microsoft AZ 900 Certification — Microsoft
Azure Fundamentals
ITIL 4 Foundation - IT Service Management Certification (ITIL V4)
Languages
English
Full Professional
Timeline
Senior Database Architect
BONI IT CONSULTING
10.2023 - Current
Senior Database Administrator
Central Bank of Nigeria
10.2022 - 09.2023
Senior Database Engineer
Nigeria Interbank Settlement System
06.2018 - 09.2022
IT Support/Database Administrator
Nigeria Interbank Settlement System
12.2014 - 05.2018
IT Support Specialist
Quantum Digital Technologies
03.2013 - 11.2014
M.Sc. - Information technology
University of Lagos, WES CANADA VERIFIED
B.Sc. - Computer science
Nnamdi Azikiwe University
Similar Profiles
Deepinder KaurDeepinder Kaur
Early Childhood Educator Assistant at Boni Montessori SchoolEarly Childhood Educator Assistant at Boni Montessori School
Aryan SharmaAryan Sharma
Logistics Assistant at Depanneur Boni SoirLogistics Assistant at Depanneur Boni Soir
JASHANDEEP KaurJASHANDEEP Kaur
Internship at Boni Montessori SchoolInternship at Boni Montessori School