Well-structured databases that power reliable, fast applications
Relational Databases (MySQL / Oracle)
Normalised relational schemas, foreign key constraints, indexing strategies, and complex queries with MySQL and Oracle PL/SQL.
- Schema design & normalisation
- Foreign keys & constraints
- Indexing for performance
- Oracle PL/SQL stored procedures
NoSQL (MongoDB)
Document-oriented data modelling with MongoDB — schema design, aggregation pipelines, and Atlas cloud integration.
- Document schema design
- Aggregation pipelines
- MongoDB Atlas cloud
- Mongoose ODM
Migrations & Seeders
Version-controlled database migrations and seeders for reproducible environments across development, staging, and production.
- Laravel Eloquent migrations
- Hibernate / JPA schema management
- Seed data for development
- Rollback & versioning
Query Optimisation
Identifying and fixing N+1 problems, adding appropriate indexes, and optimising complex joins for fast page loads.
- Eager loading to prevent N+1
- Query analysis & EXPLAIN
- Composite & covering indexes
- Caching slow queries
FAQ
Frequently Asked Questions
MySQL, MongoDB, and Oracle PL/SQL are my primary databases. I have used SQLite for smaller projects.
Yes — I can plan and execute database migrations, including data transformation and validation.
Yes — I have training and hands-on experience with Oracle PL/SQL including stored procedures, triggers, and cursors.
I use migrations (Laravel or Hibernate) so that every schema change is version-controlled and reproducible across environments.
Yes — I analyse slow queries, identify missing indexes, fix N+1 issues, and add caching where appropriate.
Related services