Summary: The role involves developing a backend database architecture for an innovative social app, focusing on advanced database optimization and scalable architecture using Supabase with PostgreSQL/PostGIS. The ideal candidate will possess deep expertise in database management, geospatial indexing, and Node.js middleware development. This position is critical for ensuring efficient data access patterns and real-time functionalities within the app. The project offers the potential for ongoing collaboration as the startup scales.

Key Responsibilities:

• Database Optimization (Priority #1)
• Implement sophisticated indexing and partitioning strategies
• Optimize query performance for complex operations
• Design efficient data access patterns for scale
• Geospatial Performance Engineering
• Fine-tune PostGIS indexes for location-based discovery
• Create high-performance proximity queries
• Optimize real-time location sharing
• SQLite Integration
• Design offline-first caching with the Flutter team
• Create synchronization between Supabase and SQLite
• Implement efficient data persistence for critical features
• Node.js Middleware Architecture
• Build a scalable Node.js layer connecting to Supabase
• Design API endpoints supporting future growth
• Document architectural patterns
• Performance Testing
• Conduct load testing for geospatial operations
• Optimize multi-user real-time connections
• Identify and resolve bottlenecks before launch

Key Skills:

• Deep understanding of PostgreSQL/PostGIS query optimization and indexing strategies
• Experience with Supabase and its real-time capabilities
• Ability to create efficient Node.js API services
• Knowledge of SQLite and offline-first architecture
• Experience in geospatial indexing with PostGIS
• Strong performance testing and optimization skills

Salary (Rate): 550

City: undetermined

Country: United Kingdom

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT