trclu-careers
Overview
Official recruitment portal of the Treatment and Rehabilitation Center - La Union (TRC-LU). Digitizes end-to-end CSC recruitment: job postings, multi-step applications, documentary review, exam scheduling, and hiring workflow.
Problem
TRC-LU's recruitment process was paper-based: applicants submitted physical documents, HR manually sorted and reviewed them, and tracking status required phone calls or visits. No online portal existed for job postings, applications, or status tracking.
Approach
Built a React 19 SPA deployed on Cloudflare Pages with serverless backend via Pages Functions. Google Sign-In + email/password auth. Multi-step application wizard with education, training, work experience, eligibility, and document upload sections (all configurable per job). HR dashboard with pipeline management, documentary review tools, and CSC-format Excel export.
Architecture
Dual-backend architecture: legacy Google Apps Script (archived, migration reference) replaced by Cloudflare Pages Functions + Neon Postgres + Cloudflare R2. Action-based API router dispatches by action field. HMAC-SHA256 signed tokens with HttpOnly refresh cookies. Cursor-based pagination for HR application lists. Version-aware caching with data version tracking per entity. PSGC address system with edge-cached data.
Challenges
Migrating from Google Apps Script + Sheets (no constraints, indexes, transactions) to proper Neon Postgres + R2 required a full rewrite while maintaining production uptime. Apps Script limitations (30s execution, 5,000 PBKDF2 iterations) forced architectural trade-offs. Multi-step form with per-job configurable sections required careful state management. Documentary review Excel export must match the official 15-column CSC format. Rate limiting at the edge via Cloudflare KV.
Results
A live recruitment portal at trclu-careers.pages.dev serving TRC-LU's hiring needs. Applicants submit once and track status online. HR manages the full pipeline from application review through exam scheduling and hiring decisions. CSC-compliant documentary review workbooks exported as Excel.