Summary: The role involves developing a backend database for an innovative social app, requiring a specialist in database architecture and optimization, particularly with PostgreSQL and PostGIS. The candidate will focus on advanced database optimization, geospatial indexing, and middleware development using Node.js. The project offers a chance to shape the architecture of a promising startup with potential for ongoing collaboration. Immediate engagement is expected, with a focus on delivering optimized database solutions and efficient API services.

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 SQLite and offline-first architecture
• Experience in database optimization and geospatial work
• Strong documentation and performance testing skills

Salary (Rate): 550

City: undetermined

Country: United Kingdom

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: Junior

Industry: IT