Database Optimization for Rails: From Slow Queries to Lightning Fast
Your Rails app was fast at launch. Now it's slow. The database is almost always the culprit. Here's how to find slow queries, fix N+1 problems, ...
Derrick Orare
Senior Software Engineer
Senior Software Engineer with expertise in Ruby on Rails, Java, Python, React, cloud infrastructure, and DevOps. Experienced in leading cross-functional teams, architecting scalable systems, and delivering mission-critical software.
Fintech Systems
Distributed Architecture
API Scalability
Cloud Infrastructure
Terminal
derrick@portfolio
$
Technical Leadership Philosophy
I architect systems that are resilient by design, build APIs that are contracts first, and lead teams that value clarity over cleverness. My approach balances immediate business needs with long-term technical vision.
Core Skills
Mongo
DevOps
11+
Years Experience
Backend / APIs
Focus
Ruby on Rails
Primary Stack
Nairobi
Location
Open to roles
Availability
Hybrid
Work Preference
Docker / Kubernetes
DevOps
CI/CD
Workflow
Career Highlights
Key roles and achievements that define my professional journey
Senior Software Engineer | Founding Developer |
NdovuCloud Technologies, Nairobi, Kenya
- Build the first prototype for the backend through API development in Ruby on Rails postgres and later MongoDB
- Crafted and curated database architectures from the ground up, sculpting models tailored for MongoDB and architecting the inventory service.
- Orchestrated seamless integrations with Mpesa and Visa payment gateways
Key Technologies:
Ruby on Rails
Postgres ★
Mongo ★
Senior Software Engineer
Engie Energy Access, Kampala Uganda
- Orchestrated seamless collaboration with stakeholders, resulting in precise delivery timelines and meticulous risk assessment
- Spearheaded autonomous delivery of mission-critical software solutions, adhering rigorously to engineering best practices and stringent deadlines
- Engaged in high-stakes architectural dialogues to fortify software performance and reliability, proactively identifying and mitigating risks.
Key Technologies:
Ruby on Rails
Postgres ★
Grape
Docker
Backend Software Engineer
- Engineered innovative features in lockstep with the engineering corps, ensuring an uninterrupted stream of value delivery.
- Championed the fortification of backend systems, emphasizing security, scalability, and peak performance.
- Architected software blueprints with surgical precision, maintaining the sanctity of code quality and organizational integrity.
Key Technologies:
Ruby on Rails
Postgres ★
MySql
React
Software Engineer
Lipalater Limited, Nairobi, Kenya
- Architected and executed backend infrastructures, amplifying administrative efficiencies and turbocharging sales support.
- Revamped and fortified authentication systems, databases, and critical controllers, laying a bulletproof foundation for the core platform.
- Engineered bespoke notification and email systems, revolutionizing inter-team communication and streamlining operational workflows.
Key Technologies:
Ruby on Rails
Postgres ★
CoffeeScript
React
Latest Blog Posts
Insights and thoughts on software engineering and architecture
Testing Background Jobs in Rails: A Complete Guide
Background jobs run outside your normal tests. When they fail, your users don't see it. They just don't get their welcome email. Here's how to t...
Background Jobs in Rails: From Zero to Hero
Your users shouldn't wait for emails to send or images to process. Move slow work out of the request cycle. Rails 8's Solid Queue handles it wit...
Free Email Testing in Rails with RSpec
Broken emails lose users. Password reset links that go to localhost. Invoices with missing attachments. Welcome emails that never ar...
Get In Touch
I'd love to hear from you! Please fill out the form below.