During my time at LeadExpo, I was granted significant autonomy over the technical direction of the core product. I primarily engineered a robust backend architecture using Node.js, PostgreSQL, and Redis, while frequently crossing over to contribute to the mobile user interface built on Expo & React Native. This freedom provided an incredible environment to rapidly learn and dictate critical system design.
Key Engineering Contributions
Core Platform & API Design
- Listing Architecture: Spearheaded the backend development for a comprehensive listing platform. This included architecting the system end-to-end—from initial schema design to formulating and maintaining resilient API contracts.
- Security: Designed, integrated, and maintained secure user authentication and authorization pipelines.
Database Optimization & Native Search
- Advanced Indexing Operations: Evolved standard data querying into highly performant operations. Implemented advanced geographical search functionalities by leveraging PostGIS for location-based listing discovery.
- Text & Vector Search: Integrated sophisticated text search indexing and utilized pgvector to handle complex, heavily-dimensional search queries efficiently across the database.
- System Optimizations: Routinely analyzed database bottlenecks, optimizing read/write efficiencies. Employed Redis caching mechanisms to massively reduce RESTful API response times and alleviate relational database contention.
Technologies & Skills Mastered
- Node.js
- PostgreSQL (PostGIS / GIS, pgvector)
- Redis
- React Native / Expo
- API & Schema Design
- Spatial & Vector Search Algorithms