Backend Dev: PostgreSQL (Supabase) & Node.js Optimisation (Startup)
Project Type: Fixed-scope, short-term contract (approximately 40 hours)
Budget: £500 total (not per day, so just above min. wage if it was per hour but each individual will differ - so as a startup, we are limitd to fixed cost)
Location: Remote
Project Overview
We're seeking an backend developer to optimize our existing Supabase implementation and develop a complementary NestJS component for our location-based social mobile application. This is a focused optimization project, not a complete rebuild.
Current State
• Existing Supabase/PostgreSQL implementation is mostly complete but requires auditing and optimization
• Basic database schema is in place but needs performance tuning
• PostGIS geospatial functionality is implemented but needs optimization for scale
• Need complementary NestJS implementation for enhanced real-time features (basic setup for future expansion
THIS IS NOT FOR FRONT-END DEVS WITH BASIC SQL KNOWLEDGE OR DATA ENGINEERS WHO NEVER BUILT A DB PROPER.
Budget: £500 total (not per day
Primary Responsibilities
• Supabase/PostgreSQL Optimization (16 hours)Audit existing database schema and structure
• Optimize PostGIS queries for location-based user discovery
• Implement proper indexing and query optimization
• Verify Row Level Security (RLS) implementation
• Perform load testing and performance tuning
• SQLite Client Database Consultation (5 hours)Design SQLite schema for client-side persistence
• Create synchronization architecture between Supabase and SQLite
• Document implementation patterns for frontend developer
• NestJS Implementation (19 hours)Set up NestJS project with proper architecture
• Implement WebSocket connections for enhanced real-time features
• Create selective broadcasting for location updates
• Implement message throttling and connection management
• Document integration approach for frontend developer
Deliverables
• Optimized database queries with performance documentation
• NestJS project with WebSocket implementation
• SQLite schema design and synchronization architecture
• Postman collection documenting API endpoints
• Performance test results and integration documentation
Required Skills & Experience
• Strong experience with Supabase and PostgreSQL
• Experience with PostGIS for geospatial queries
• Proficiency with NestJS framework
• Experience implementing WebSocket connections for real-time applications
• Understanding of mobile app backend requirements
• Knowledge of SQLite for mobile offline data storage
• Excellent problem-solving skills with focus on performance optimization
Budget: £500 total (not per day
Ideal Candidate
• Has previously optimized Supabase implementations
• Has worked on location-based applications using PostGIS
• Understands real-time communication patterns
• Can work efficiently within a focused timeframe
• Communicates clearly about technical decisions
Timeline
• Expected duration: 2 weeks (part-time) or 1/1.5 ful time
• Start date: Immediate, potential for 12+ month ongoing relationship
What We Offer
While compensation is modest:
Professional references from our company and on LinkedIn
Opportunity to shape the architecture of a promising social startup
Potential for on-going relationship as we scale
Application Process
Please include:
• Your relevant experience with Supabase, PostgreSQL, and NestJS
• Example of previous optimization work you've done
• Preferred working hours and availability
Qualified candidates will be contacted for a brief technical discussion about the project scope.
Budget: £500 total (not per day)
Project Type: Fixed-scope, short-term contract (approximately 40 hours)
Budget: £500 total (not per day, so just above min. wage if it was per hour but each individual will differ - so as a startup, we are limitd to fixed cost)
Location: Remote
Project Overview
We're seeking an backend developer to optimize our existing Supabase implementation and develop a complementary NestJS component for our location-based social mobile application. This is a focused optimization project, not a complete rebuild.
Current State
• Existing Supabase/PostgreSQL implementation is mostly complete but requires auditing and optimization
• Basic database schema is in place but needs performance tuning
• PostGIS geospatial functionality is implemented but needs optimization for scale
• Need complementary NestJS implementation for enhanced real-time features (basic setup for future expansion
THIS IS NOT FOR FRONT-END DEVS WITH BASIC SQL KNOWLEDGE OR DATA ENGINEERS WHO NEVER BUILT A DB PROPER.
Budget: £500 total (not per day
Primary Responsibilities
• Supabase/PostgreSQL Optimization (16 hours)Audit existing database schema and structure
• Optimize PostGIS queries for location-based user discovery
• Implement proper indexing and query optimization
• Verify Row Level Security (RLS) implementation
• Perform load testing and performance tuning
• SQLite Client Database Consultation (5 hours)Design SQLite schema for client-side persistence
• Create synchronization architecture between Supabase and SQLite
• Document implementation patterns for frontend developer
• NestJS Implementation (19 hours)Set up NestJS project with proper architecture
• Implement WebSocket connections for enhanced real-time features
• Create selective broadcasting for location updates
• Implement message throttling and connection management
• Document integration approach for frontend developer
Deliverables
• Optimized database queries with performance documentation
• NestJS project with WebSocket implementation
• SQLite schema design and synchronization architecture
• Postman collection documenting API endpoints
• Performance test results and integration documentation
Required Skills & Experience
• Strong experience with Supabase and PostgreSQL
• Experience with PostGIS for geospatial queries
• Proficiency with NestJS framework
• Experience implementing WebSocket connections for real-time applications
• Understanding of mobile app backend requirements
• Knowledge of SQLite for mobile offline data storage
• Excellent problem-solving skills with focus on performance optimization
Budget: £500 total (not per day
Ideal Candidate
• Has previously optimized Supabase implementations
• Has worked on location-based applications using PostGIS
• Understands real-time communication patterns
• Can work efficiently within a focused timeframe
• Communicates clearly about technical decisions
Timeline
• Expected duration: 2 weeks (part-time) or 1/1.5 ful time
• Start date: Immediate, potential for 12+ month ongoing relationship
What We Offer
While compensation is modest:
Professional references from our company and on LinkedIn
Opportunity to shape the architecture of a promising social startup
Potential for on-going relationship as we scale
Application Process
Please include:
• Your relevant experience with Supabase, PostgreSQL, and NestJS
• Example of previous optimization work you've done
• Preferred working hours and availability
Qualified candidates will be contacted for a brief technical discussion about the project scope.
Budget: £500 total (not per day)
