Summary: The role involves developing a backend database for an innovative social app, requiring a specialist with advanced skills in database optimization and architecture, particularly with PostgreSQL and PostGIS. The candidate will be responsible for implementing sophisticated indexing strategies, optimizing query performance, and integrating SQLite for offline capabilities. This position is aimed at someone who can contribute significantly to the app's backend infrastructure and ensure scalability. The project offers the potential for ongoing collaboration as the startup grows.

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
• Node.js Middleware Architecture
• Build a scalable Node.js layer connecting to Supabase
• Design API endpoints supporting future growth
• Document architectural patterns
• SQLite Integration
• Design offline-first caching with the Flutter team
• Create synchronization between Supabase and SQLite
• Implement efficient data persistence for critical features
• 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 using Node.js
• Knowledge of offline-first architecture and SQLite synchronization
• Experience in performance testing and optimization

Salary (Rate): 550

City: undetermined

Country: United Kingdom

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: Entry Level

Industry: IT