About the Project I Can Swim LLC provides adaptive swim lessons for children with special needs. We have 800+ families on our waitlist and have outgrown our current system. I've built a custom operations platform (Enrollment, Booking, Progress Tracking, State-funded/VMRC workflows) that is 80–90% complete. I need an experienced developer to get us across the finish line fast. The enrollment and booking system is the immediate priority. Tech Stack: 15 (App Router), Supabase, React Query, TypeScript, shadcn/ui, Tailwind CSS. Current State of the Build This is not a build-from-scratch job. The heavy lifting is done: Database: 32+ tables with RLS, triggers, functions, and stored procedures. Auth: Supabase Auth with 4-role RBAC (Parent, Instructor, Admin, VMRC Coordinator) fully implemented. Features: 10-section modular enrollment form, Staff Mode (iPad) for real-time skill tracking, and a full Admin Dashboard are built. Architecture: React Query migration is 90% done; Edge Functions for crons and emails are live. Critical Blocking Issues (Priority 1) We need these four items resolved to launch: Assessment Booking Save Failure: UI works, but handleConfirm() logs to console instead of creating records (Booking, Assessment, and VMRC POS records). RLS Gaps: Coordinators and parents are locked out of specific tables (swimmers, purchase_orders, progress_notes). We have a completed audit report with exact SQL fixes documented. Auth Hook Migration: Two pages still call () directly instead of our useAuth() hook, causing state/caching issues. Security Fix: One query returns mock data to unauthenticated users; needs to be restricted immediately. Full Scope of Work Supabase RLS Standardizing: Apply documented SQL fixes for 15+ tables via migration files. Auth Flow Cleanup: Ensure all auth calls use the centralized hook and verify PKCE flows. Feature Completion: Finalize the VMRC onboarding workflow (Referral → Approval → POS → Lessons). Testing/QA: Set up Playwright E2E tests for critical paths (Enrollment, Booking) across all 4 roles. Refactoring: Migrate remaining sequential queries in to parallel React Query hooks. Ideal Candidate Supabase Power User: Deeply comfortable with PostgreSQL RLS and migration files. 15 Expert: Mastery of App Router, Server Components vs. Client Components, and React Query. Detail-Oriented: We handle state-funded client data and medical info; accuracy is non-negotiable. Fast Mover: We want this live in days, not weeks. What You'll Receive Full GitHub and Supabase Dev environment access. Completed RLS Audit Report with exact SQL fixes already documented. Direct access to me for fast context and architecture overviews. Generic proposals will be ignored. If you can start immediately, please mention it. Contract duration of 1 to 3 months. with 30 hours per week. Mandatory skills: JavaScript, React, , CSS, PHP