Production ATS, CRM & AI recruitment platform for a Spanish recruitment company
Built at Soraia (Italian AI/software agency) for a Spanish recruitment company · 2024–2026
- Owned major parts of the Xano schema and data model: relationships, REST APIs, business logic, migrations, imports and logging.
- Took ownership of backend performance when important APIs reached 5–40+ seconds under load: PostgreSQL, GIN and geospatial indexes, pagination, direct database queries, rewritten joins and smaller, access-aware responses.
- Fixed looping triggers and heavy add-ons; some flows that generated 100+ database operations became a single consolidated query.
- Redesigned a synchronous ~32-second CV workflow so the candidate is created immediately and OCR/AI enrichment finishes asynchronously a few seconds later.
- AI candidate matching: persisted OpenAI embeddings, trigger-based re-indexing, language and distance filters.
- Backend RBAC: reusable authorization functions, endpoint-level role checks, rate limiting and SQL-injection protection.