Temporary Senior Supabase / SQL Developer (Audit, Remediation & Handover)

I am looking for an experienced temporary developer to audit, remediate and future-proof an existing automated coaching platform built using **Supabase, PostgreSQL, Edge Functions, Slack, Stripe and Lovable**. The platform is already live and operational. It was originally built using AI-assisted ("vibe coded") development and now requires an experienced engineer to review the entire architecture, identify weaknesses, improve reliability and security, and hand the system back to me in a production-ready state. This is **not** a long-term development position. The objective is to leave the platform secure, scalable, fully documented and easy for the owner to maintain and expand. ## Existing Technology * Supabase * PostgreSQL * SQL * Supabase Edge Functions (Deno) * pg_cron scheduled workers * Slack API * Stripe Webhooks * Lovable frontend/admin interface * GitHub ## Project Objectives You will: * Audit the complete system architecture. * Understand the intended business logic before making recommendations. * Identify technical debt and potential failure points. * Review database design, SQL, Edge Functions and scheduled jobs. * Assess security, permissions and production readiness. * Review integrations between Stripe, Supabase, Slack and Lovable. * Recommend improvements for scalability and maintainability. * Produce a remediation plan with priorities. * Implement agreed improvements. * Thoroughly test all functionality. * Produce clear technical documentation. * Handover complete ownership back to the business owner. ## Current Functionality The system currently automates: * Stripe payment onboarding * Participant enrolment * Slack workspace onboarding * Automated 90-day coaching programme delivery * Scheduled message sequencing * Participant progress tracking * Daily scheduling * Administrative dashboard * Program management * Reporting Future expansion is expected to include: * Multiple programmes * Improved reporting and analytics * Additional automation * More payment options * Enhanced admin functionality * Greater scalability * Improved monitoring and alerting ## Proposal Requirements Please submit: * Your experience with Supabase and PostgreSQL * Previous automation or workflow projects * Experience with SQL optimisation * Experience with Edge Functions and scheduled workers * Experience integrating third-party APIs (Slack, Stripe etc.) * Your initial assessment approach * What you would audit first * Any immediate concerns based on the project description * Estimated timeline * Estimated cost * Examples of similar projects ## Ideal Candidate You have experience with: * Supabase * PostgreSQL * Advanced SQL * Database architecture * Backend systems * API integrations * Security hardening * Performance optimisation * Scalable system design * Technical documentation You are comfortable reviewing AI-generated code and transforming it into a robust production-quality platform without unnecessarily rebuilding working components. ## Deliverables The successful developer will provide: * Full architecture audit * Risk assessment * Prioritised remediation plan * Implemented improvements * Security review * Performance improvements * Testing documentation * System documentation * Operational handover documentation * Recommendations for future expansion ## Success Criteria At project completion the platform should be: * Secure * Reliable * Scalable * Fully documented * Easily maintainable * Ready for future feature expansion * Straightforward for the owner to manage without ongoing developer dependency. This engagement is focused on leaving the platform in a stable, production-ready state with a clean handover to the owner.