Lovable/Supabase code refining x performance

1. Fractional Full-Stack "Vibe" Engineer Focus: Transforming [login to view URL] output into scalable, production-ready code. Role Overview We are looking for a senior-level Full-Stack Developer comfortable working in a high-velocity environment where initial UI and logic are generated via Lovable.dev. Your job is not just to "write" code, but to audit, refactor, and harden AI-generated code to support 14,000 users and 1.2k concurrent audio/video streams. Key Responsibilities • Code Hardening: Take Lovable-generated React/TypeScript code and refactor for performance, specifically focusing on memoization and efficient state management (Zustand/Context) for media playback. • Supabase Architecture: Implement and manage Row Level Security (RLS) to ensure strict multi-tenant isolation.  • Database Optimization: Write and optimize complex Postgres queries, ensuring proper indexing for high-concurrency scenarios. • Media Integration: Lead the integration of audio/video streaming via Supabase Storage using Signed URLs and heartbeat mechanisms.  Technical Requirements • Expertise: React, TypeScript, and Tailwind CSS. • Supabase Pro: Deep experience with Postgres, RLS, and Edge Functions. • AI-Native Workflow: High proficiency in Prompt Engineering—you must know how to guide AI to produce clean, modular code. • Performance: Experience in reducing "N+1" query issues and frontend re-rendering lag. 2. Fractional DevOps & CI/CD Engineer Focus: Building the "Safety Net" and global delivery pipeline on Netlify. Role Overview As our CI/CD lead, you will build the infrastructure that allows our "vibe coding" team to deploy rapidly without breaking the experience for our 14,000 users. You will be responsible for the "Quality of Service" (QoS) and the automated testing pipeline. Key Responsibilities • Netlify Infrastructure: Configure Netlify High-Performance Edge, Edge Functions for tenant-based routing, and advanced caching strategies (SWR).  • Automated QA: Implement and maintain a comprehensive regression suite using [login to view URL] to protect core "Golden Paths" like login and playback. • Load Testing: Execute and report on K6 load tests to simulate 1,200+ concurrent users, identifying bottlenecks in the Supabase/Netlify handshake. • Deployment Pipeline: Establish a CI/CD workflow that uses Netlify Deploy Previews for staging and rapid QA cycles. Technical Requirements • Infrastructure: Netlify (Enterprise features preferred), including Edge Functions and Firewall/Rate-limiting. • Testing: Mastery of K6 (load) and [login to view URL] (e2e/regression). • Database Operations: Experience with Supavisor or similar connection pooling tools for high-concurrency Postgres environments. • Monitoring: Experience setting up Sentry or LogSnag for real-time error tracking in production

Projektin tunnus (ID): 40256636