Flutter & Supabase Developer for App Optimization -- 2

I am looking for a highly experienced Flutter developer with expertise in Supabase and Riverpod to help optimize the backend and data management logic of my app. The app is already well-developed, with significant progress made on core features, but some critical functionalities, particularly around match-making and chatting, need to be fixed and optimized. This role focuses on optimizing all functions interacting with the Supabase database, ensuring efficient, scalable, and cost-effective solutions. The developer must have a strong understanding of when to use real-time subscriptions, caching, and other database strategies, balancing performance with cost. While the match-making functionality is the core priority, the entire app backend will require review and refinement. Responsibilities: - Fix and optimize match-making functionality: Ensure the match-making logic is reliable, efficient, and scalable, as it is the app’s core feature. - Review and refactor all functions interacting with Supabase to minimize unnecessary queries and reduce latency. - Implement real-time subscriptions only where they are genuinely needed (e.g., critical tables such as chats), avoiding expensive and unnecessary subscriptions for less dynamic data. - Use a combination of caching and periodic fetches for non-critical tables to improve performance and reduce real-time costs. - Ensure efficient use of Supabase edge functions, database functions, and triggers to offload complex operations to the server when appropriate. - State management: Refine the use of Riverpod to handle app state more efficiently, particularly for real-time updates and user interactions. - Local vs. server-side processing: Determine which operations are best run locally on the client versus offloaded to the server or Supabase functions, ensuring optimal responsiveness and cost-efficiency. - Cost-efficiency: Proactively identify and suggest cost-saving strategies for Supabase queries, real-time subscriptions, and storage without compromising performance. - Debugging and troubleshooting: Identify and resolve backend issues affecting performance or reliability. - Collaboration: Provide regular updates on progress and collaborate as needed to align with project goals and expectations. Requirements: - Extensive experience with Flutter, focusing on busines logic and optimization. - Advanced knowledge of Supabase, including real-time subscriptions, edge functions, triggers, and database optimization. - Expertise in balancing real-time vs. non-real-time solutions to ensure cost-effective performance. - Strong proficiency in Riverpod for scalable and efficient state management. - Proven ability to optimize existing codebases. - Experience implementing caching strategies and offline-first solutions. - Ability to write clean, maintainable, and efficient code tailored to existing app architectures. Project Status: The app is already well-developed, with much of the functionality in place. The match-making functionality is the primary focus for fixes and optimization, but all database-interacting functions need to be reviewed to ensure efficient use of Supabase’s capabilities. This includes deciding when to use real-time subscriptions, caching, triggers, or server-side processing for each table, balancing performance and cost. Deliverables: - Fully functional and optimized match-making functionality. - Refactored and optimized backend logic for all services interacting with Supabase, reducing unnecessary database calls and improving performance. - Strategic use of real-time subscriptions, with clear rationale for when they are applied. - Enhanced Supabase integration for real-time functionality, caching, and server-side processing. - Refined Riverpod-based state management for responsiveness and scalability. If you’re an expert in Supabase, Riverpod, and backend optimization, and you have a deep understanding of balancing cost and performance in real-time applications, I’d love to hear from you!