Supabase Expert Needed - Skills Assessment & Production Fixes Job Type: Fixed Price / Hourly Duration: 2-6 weeks - Full Time Ongoing --- About the Project We're an AI/SaaS company with 15+ production applications built on Next.js 14 + Supabase. We need an experienced Supabase developer to: 1. Complete a skills assessment (test project provided) 2. Fix deployment issues across our production apps 3. Standardize our Supabase architecture --- Required Skills (Must Have) - 3+ years PostgreSQL experience - 2+ years Supabase production experience - Row Level Security (RLS) - design, debug, optimize - Supabase Auth - sessions, JWT, middleware - Supabase Storage - buckets, policies, CORS - Next.js 14 App Router - Server/Client components, @supabase/ssr - Database migrations - schema versioning, rollbacks - Serverless deployment - Vercel, Netlify --- Nice to Have - Auth0 integration with Supabase - Stripe payment integration - TypeScript proficiency - Experience with AI/LLM applications --- HOW TO APPLY - QUALIFICATION REQUIRED Step 1: Go to https://aivisaevaluation.online Step 2: Complete the evaluation assessment Step 3: Score 50% or higher to qualify Step 4: Take a screenshot of your score and attach it to your application Applications without a qualifying screenshot (50%+) will NOT be considered. --- After Qualification - The Technical Assessment 1. We provide a test Supabase project with 10 intentional issues 2. You identify and fix each issue 3. Document your solutions 4. Best performer gets the full contract Test covers: - RLS policy debugging (403 errors) - Storage bucket permissions - Auth session handling - Query optimization - Migration scripts - Client initialization patterns --- Scope of Work (After Assessment) Phase 1: Audit (1 week) - Review 15+ repos using Supabase - Document all schemas, RLS policies, storage buckets - Identify security vulnerabilities Phase 2: Fixes (2-3 weeks) - Resolve all 403/401 deployment errors - Fix RLS policy conflicts - Configure storage correctly - Standardize client patterns Phase 3: Optimization (1 week) - Add missing indexes - Optimize slow queries - Implement connection pooling --- Deliverables - Working production deployments (zero errors) - Documentation of all changes - Shared utility library for Supabase operations - Migration scripts for future updates --- Tech Stack - Next.js 14 (App Router) - Supabase (PostgreSQL, Auth, Storage, Edge Functions) - TypeScript - Vercel / Netlify deployment - Stripe payments - AI APIs (Claude, GPT-4) --- To Apply (REQUIRED) 1. Screenshot of 50%+ score from aivisaevaluation.online (MANDATORY) 2. Share your Supabase portfolio (live projects) 3. Describe a complex RLS policy you've implemented 4. Explain how you'd debug a 403 storage upload error 5. Your hourly rate or fixed price estimate Bonus: Experience with immigration, legal tech, or document generation systems --- Timeline - Applications reviewed: 48 hours - Skills assessment: 3-5 days - Decision: Within 1 week - Start date: Immediately after selection --- We're looking for a long-term partner, not just a one-time fix. Top performers will be offered ongoing retainer work.