Generate a CV for this Job!
Based on your profile and this job description, you can create a tailored CV to apply directly.
Backend Developer with Geospatial Expertise (Supabase, Postgresql, Node.js, SQLite)
Upwork • , US • Remote
Posted on: 21st March, 2025
Employment Type: CONTRACTOR
Job Description
We're dev. a social app.. Our application features interactive maps, real-time messaging, user discovery, and meetup coordination to help people,.
We're building a scalable MVP with Supabase as the backend, Flutter for the frontend, and SQLite for offline caching. Map tiles (PMTiles) are stored on a separate database and rendered in Flutter.
We are looking for a backend developer with expertise in geospatial queries, Supabase optimization, and Node.js API development. The ideal candidate will optimize our Supabase backend for geospatial performance, implement a lightweight Node.js middleware for future extensibility, and collaborate with our Flutter developers to integrate SQLite for offline caching.
Responsibilities
Geospatial Query Optimization in Supabase:
Design and optimize geospatial queries using PostGIS (e.g., ST_DWithin, ST_Intersects).
Implement proximity search queries for user discovery and location-based features.
Ensure geospatial queries are performant and scalable for real-time use cases.
Node.js Middleware Implementation (basic future proof)
Set up a lightweight Node.js API layer to act as middleware between the frontend and Supabase.
Create RESTful API endpoints for geospatial queries and other backend functionality.
Document the API for frontend developers to integrate seamlessly.
SQLite Integration for Offline Caching:
Collaborate with Flutter developers to design a caching strategy for geospatial data.
Define synchronization logic between Supabase and SQLite for offline-first functionality.
Ensure efficient data persistence for critical app features (e.g., user locations, recent queries).
Collaboration with Frontend Developers:
Work closely with Flutter developers to ensure smooth integration of backend APIs.
Provide guidance on geospatial data structures and caching strategies.
Performance Testing:
Conduct load testing for geospatial queries in Supabase.
Identify and resolve bottlenecks in the backend architecture.
Required Skills
Geospatial Expertise:
Strong experience with PostGIS for geospatial queries and indexing.
Knowledge of geospatial data formats (e.g., GeoJSON).
Familiarity with proximity searches, distance calculations, and geospatial optimizations.
Supabase and PostgreSQL:
Experience with Supabase's real-time features, authentication, and APIs.
Understanding of Row Level Security (RLS) for geospatial data privacy.
Expertise in PostgreSQL performance tuning.
Node.js Development:
Ability to create lightweight API services with Express.js.
Experience integrating Node.js with PostgreSQL or Supabase.
Understanding of RESTful API best practices.
SQLite and Offline Caching:
Knowledge of SQLite for mobile applications.
Experience with offline-first architecture and data synchronization.
Collaboration:
Ability to work closely with frontend Flutter developers.
Clear communication and documentation skills.
Nice-to-Have Skills
Familiarity with PMTiles or similar map tile formats.
Experience with Flutter or mobile app development.
Background in social or location-based applications.
Knowledge of real-time systems and high-concurrency applications.
Deliverables
Optimized geospatial queries for user location features in Supabase.
Lightweight Node.js API layer connected to Supabase.
SQLite caching strategy implemented in collaboration with Flutter developers.
Documentation of backend architecture and API endpoints.
Performance test results demonstrating system scalability.
Please submit:
Your relevant experience with Supabase, PostgreSQL/PostGIS, Node.js, and SQLite
Examples of previous geospatial or real-time application work
Your approach to building scalable database architectures
Availability over the next 2-3 weeks
This position offers a great long-term relationship over the next 12 months to help optimize performance.
We're building a scalable MVP with Supabase as the backend, Flutter for the frontend, and SQLite for offline caching. Map tiles (PMTiles) are stored on a separate database and rendered in Flutter.
We are looking for a backend developer with expertise in geospatial queries, Supabase optimization, and Node.js API development. The ideal candidate will optimize our Supabase backend for geospatial performance, implement a lightweight Node.js middleware for future extensibility, and collaborate with our Flutter developers to integrate SQLite for offline caching.
Responsibilities
Geospatial Query Optimization in Supabase:
Design and optimize geospatial queries using PostGIS (e.g., ST_DWithin, ST_Intersects).
Implement proximity search queries for user discovery and location-based features.
Ensure geospatial queries are performant and scalable for real-time use cases.
Node.js Middleware Implementation (basic future proof)
Set up a lightweight Node.js API layer to act as middleware between the frontend and Supabase.
Create RESTful API endpoints for geospatial queries and other backend functionality.
Document the API for frontend developers to integrate seamlessly.
SQLite Integration for Offline Caching:
Collaborate with Flutter developers to design a caching strategy for geospatial data.
Define synchronization logic between Supabase and SQLite for offline-first functionality.
Ensure efficient data persistence for critical app features (e.g., user locations, recent queries).
Collaboration with Frontend Developers:
Work closely with Flutter developers to ensure smooth integration of backend APIs.
Provide guidance on geospatial data structures and caching strategies.
Performance Testing:
Conduct load testing for geospatial queries in Supabase.
Identify and resolve bottlenecks in the backend architecture.
Required Skills
Geospatial Expertise:
Strong experience with PostGIS for geospatial queries and indexing.
Knowledge of geospatial data formats (e.g., GeoJSON).
Familiarity with proximity searches, distance calculations, and geospatial optimizations.
Supabase and PostgreSQL:
Experience with Supabase's real-time features, authentication, and APIs.
Understanding of Row Level Security (RLS) for geospatial data privacy.
Expertise in PostgreSQL performance tuning.
Node.js Development:
Ability to create lightweight API services with Express.js.
Experience integrating Node.js with PostgreSQL or Supabase.
Understanding of RESTful API best practices.
SQLite and Offline Caching:
Knowledge of SQLite for mobile applications.
Experience with offline-first architecture and data synchronization.
Collaboration:
Ability to work closely with frontend Flutter developers.
Clear communication and documentation skills.
Nice-to-Have Skills
Familiarity with PMTiles or similar map tile formats.
Experience with Flutter or mobile app development.
Background in social or location-based applications.
Knowledge of real-time systems and high-concurrency applications.
Deliverables
Optimized geospatial queries for user location features in Supabase.
Lightweight Node.js API layer connected to Supabase.
SQLite caching strategy implemented in collaboration with Flutter developers.
Documentation of backend architecture and API endpoints.
Performance test results demonstrating system scalability.
Please submit:
Your relevant experience with Supabase, PostgreSQL/PostGIS, Node.js, and SQLite
Examples of previous geospatial or real-time application work
Your approach to building scalable database architectures
Availability over the next 2-3 weeks
This position offers a great long-term relationship over the next 12 months to help optimize performance.
Responsibilities
- The ideal candidate will optimize our Supabase backend for geospatial performance, implement a lightweight Node.js middleware for future extensibility, and collaborate with our Flutter developers to integrate SQLite for offline caching
- Design and optimize geospatial queries using PostGIS (e.g., ST_DWithin, ST_Intersects)
- Implement proximity search queries for user discovery and location-based features
- Ensure geospatial queries are performant and scalable for real-time use cases
- Node.js Middleware Implementation (basic future proof)
- Set up a lightweight Node.js API layer to act as middleware between the frontend and Supabase
- Create RESTful API endpoints for geospatial queries and other backend functionality
- Document the API for frontend developers to integrate seamlessly
- SQLite Integration for Offline Caching:
- Collaborate with Flutter developers to design a caching strategy for geospatial data
- Define synchronization logic between Supabase and SQLite for offline-first functionality
- Ensure efficient data persistence for critical app features (e.g., user locations, recent queries)
- Collaboration with Frontend Developers:
- Work closely with Flutter developers to ensure smooth integration of backend APIs
- Provide guidance on geospatial data structures and caching strategies
- Conduct load testing for geospatial queries in Supabase
- Identify and resolve bottlenecks in the backend architecture
- Optimized geospatial queries for user location features in Supabase
- Documentation of backend architecture and API endpoints
- This position offers a great long-term relationship over the next 12 months to help optimize performance
Requirements
- We are looking for a backend developer with expertise in geospatial queries, Supabase optimization, and Node.js API development
- Geospatial Expertise:
- Strong experience with PostGIS for geospatial queries and indexing
- Knowledge of geospatial data formats (e.g., GeoJSON)
- Familiarity with proximity searches, distance calculations, and geospatial optimizations
- Experience with Supabase's real-time features, authentication, and APIs
- Understanding of Row Level Security (RLS) for geospatial data privacy
- Expertise in PostgreSQL performance tuning
- Ability to create lightweight API services with Express.js
- Experience integrating Node.js with PostgreSQL or Supabase
- SQLite and Offline Caching:
- Knowledge of SQLite for mobile applications
- Experience with offline-first architecture and data synchronization
- Ability to work closely with frontend Flutter developers
- Clear communication and documentation skills
- Familiarity with PMTiles or similar map tile formats
- Experience with Flutter or mobile app development
- Background in social or location-based applications
- Knowledge of real-time systems and high-concurrency applications
- Lightweight Node.js API layer connected to Supabase
- SQLite caching strategy implemented in collaboration with Flutter developers
- Your relevant experience with Supabase, PostgreSQL/PostGIS, Node.js, and SQLite
- Examples of previous geospatial or real-time application work
- Your approach to building scalable database architectures
Upwork
Technology
Job Type
CONTRACTOR
Loading...
Loading...
AI Cover Letter Generator
Generate a Tailored Cover Letter!
Our AI will analyze your profile and create a personalized cover letter that highlights your relevant skills and experience.
Related Jobs
Upwork
3 weeks ago
Optimize and Fix Performance Issues in a MERN/MEAN Stack Application
, US
View Job