Problem
An expanding recruitment agency required a modernized platform capable of handling high concurrent traffic and complex, multi-faceted search queries. Their legacy system suffered from severe database locking issues and slow response times as their dataset grew.
My Role
Full Stack Architect & Backend Lead.
Technical Challenges
- Search Optimization: Querying millions of job records based on geolocation, skill matching, and full-text search was overloading the primary database.
- Concurrency: Handling traffic spikes during massive hiring events without degrading platform responsiveness.
- Real-time Tracking: Implementing a seamless candidate tracking pipeline for employers to manage applications instantly.
Solution
I led the migration from a monolithic legacy system to a decoupled, API-first architecture:
- Advanced Searching: Integrated the Laravel backend with a dedicated search index (similar to Elasticsearch) and utilized Redis for heavily aggressive caching of frequent queries.
- Frontend Performance: Rebuilt the frontend using Next.js with Server-Side Rendering (SSR) for public job listings to guarantee SEO, while keeping employer dashboards interactive with React.
- Database Refactoring: Re-architected the MySQL database utilizing advanced normalization and read-replicas to reduce load on the primary write database.
Tech Stack
- Frontend: Next.js, React, TypeScript, Tailwind CSS
- Backend: Laravel, PHP, REST APIs, Redis
- Data Layer: MySQL (Read/Write Replicas), Full-Text Indexing
- DevOps: Docker, Linux VPS, Nginx
Outcome
Reduced average search query times from over 4 seconds to under 150 milliseconds. The platform successfully scaled to support a 400% increase in daily active users with zero downtime.