Why Standard Indexes Fail: The Architecture of the Covering Index
It documents how to force an Index-Only Scan using a Covering Index, dropping query execution time on a 1-million-row table from 217ms to 0.106ms.
Backend Developer · Freelance Web Developer
I build the systems that power web products from APIs, databases, and server-side logic. Based in Nigeria, I also help local businesses get online with clean, functional websites that convert visitors to customers.
Tech Stack
A selection of projects and systems exploring software architecture, performance, and technical problem-solving.
A simple and efficient RESTful API built with FastAPI and SQLModel. It provide endpoints to shorten URLs, manage links, and perform admin-level operations. Designed as a backend practice project to strengthen skills in API design, authentication, and database management.
A website for Eaglespoint Horizon Ltd., a real estate and travel company in Nigeria. Built using the Django Web Framework.
Engineering a proactive defense for Sickle Cell patients. I developed a high-concurrency FastAPI system that processes real-time biometric streams (HRV, Temp, HR) into a proprietary Stability Index for prodromal crisis prediction. By bridging the gap between wearable data and clinical intervention, the system provides automated emergency SMS alerts and an Offline-First QR Triage interface designed for hospital environments with zero connectivity. Awarded 4th Place at the HSIL Lagos Hub 2026
Technical writing and deep dives into software engineering concepts, trade-offs, and implementation details.
It documents how to force an Index-Only Scan using a Covering Index, dropping query execution time on a 1-million-row table from 217ms to 0.106ms.
An analysis of ensuring data integrity in multi-table operations using Django’s transaction.atomic(). It demonstrates how to prevent "orphaned" records by enforcing database atomicity during complex user registration flows.
A deep dive into the $O(\log n)$ efficiency of B-Trees versus the $O(n)$ cost of full table scans. It explores the critical trade-off between read speed and write overhead that every backend engineer must master.
A technical retrospective on moving from Django’s "batteries-included" environment to the unopinionated architecture of FastAPI. It covers implementing custom database seeding, JWT authentication, and Role-Based Access Control (RBAC) in a modular system.
Got a project you need built, a role, or just want to talk backend? I'm available for freelance work and open to full-time opportunities.
Quick questions, project ideas, or any collaboration — fastest way to get a response.
Start a WhatsApp chatFor detailed inquiries, formal opportunities, or anything that needs a longer reply.
Send an email