Pinuno Consultancy — Staff Profile
Database Administrator
MySQL & PostgreSQL specialist · Schema design · Performance tuning · Data integrity
Request This DBA
Professional Summary
Database administrator with four years of experience designing, optimising, and managing MySQL and PostgreSQL databases for web applications and business systems deployed in Ghana. Works across the full database lifecycle — schema design and normalisation, query performance tuning, replication and backup strategy, security hardening, and migration from legacy systems. Experienced supporting PHP/Yii2 and integration platform (WSO2 MI) data layers in production environments.
Experience
Database Administrator
Pinuno · Buduatta Junction, Central Region- Designed and maintains the MySQL schema for the Pinuno Academy platform — 19-table normalised schema covering users, courses, registrations, payments, articles, and certificates; optimised for Yii2 ActiveRecord query patterns
- Implemented MySQL replication (primary/replica) for a Ghanaian microfinance institution, achieving sub-second replication lag and enabling read-scale for reporting queries without touching the primary
- Performed a full database rescue for a wholesale distributor whose MySQL instance had no backups, an unindexed 4 million-row orders table, and queries taking 40+ seconds — resolved within 48 hours through index analysis, query rewriting, and enabling the slow query log with automated alerting
- Migrated a client from MySQL 5.7 to MySQL 8.0 on a live production server using zero-downtime replica promotion, then cleaned up deprecated SQL modes and utf8 charset issues across the codebase
Database Developer — Client Projects
Pinuno · Buduatta Junction, Central Region- Designed PostgreSQL schema for a document management system serving a law firm in Accra — JSONB for flexible metadata, full-text search with tsvector, and row-level security for per-client data isolation
- Built automated daily backup pipeline using mysqldump + rclone to push encrypted backups to a remote object store; verified restores quarterly
- Configured Redis caching layer for a high-traffic PHP application, reducing database round-trips by 60% and cutting average page response time from 1.2 s to 280 ms
Database Instructor
Pinuno Academy · Buduatta Junction, Central Region- Teaches database design and MySQL in the PHP Development programmes — PHP & MySQL Foundations, PHP Application Developer, PHP Framework Developer, and PHP Solutions Engineer
- Covers schema normalisation (1NF–3NF), indexing strategy, transaction management, stored procedures, and security best practices
- Students leave with a working normalised schema they designed and populated, plus hands-on EXPLAIN analysis of their own queries
Certifications & Education
Database Design & Administration Programme Certificate
Pinuno Academy · Buduatta Junction, Central Region
Linux Administration Programme Certificate
Pinuno Academy · Buduatta Junction, Central Region
PHP Development Programme Certificate
Pinuno Academy · Buduatta Junction, Central Region
Available for Projects
Database design, optimisation, and rescue engagements across Ghana.
Request This DBACore Skills
Engagement Types
- Database design for new applications
- Performance rescue and query tuning
- Legacy data migration and clean-up
- Replication and backup strategy
- Ongoing managed DBA support