Summary: The role involves developing a backend database architecture for an innovative social app, focusing on advanced database optimization and scalable architecture using PostgreSQL and PostGIS. The candidate must possess deep expertise in database management, middleware development with Node.js, and SQLite integration for offline capabilities. This position is critical for ensuring efficient data access and real-time functionalities within the app. The project offers a chance for long-term 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 API services with Node.js
• Knowledge of offline-first architecture and synchronization with SQLite
• Experience in performance tuning and architectural documentation

Salary (Rate): undetermined

City: undetermined

Country: United Kingdom

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT