DB & Backend Dev: PostgreSQL, SQLite, Node.js for App (Startup)
We're developing an innovative social app with interactive maps, real-time messaging, user discovery, and meetup coordination. We need a true backend database specialist if junior - not just someone who can set up tables and write basic queries, but an expert who understands advanced database optimization, indexing strategies, and scalable architecture.
THIS IS NOT FOR FRONT-END DEVS WITH BASIC SQL KNOWLEDGE OR DATA ENGINEERS WHO NEVER BUILT A DB PROPER.
We need someone with deep expertise in:
* Database architecture and optimization (particularly PostgreSQL) - we are doing this on supabase so already much is done.
* Geospatial indexing with PostGIS is a big bonus!
* SQLite integration for offline-first mobile applications
Stack
Primary Backend: Supabase with PostgreSQL/PostGIS
Middleware: Node.js for scalability and custom logic (basic implementation)
Mobile Database: SQLite for offline caching in Flutter
Current Project Status
Most Database schema established in Supabase
Authentication system implemented
Basic chat functionality operational
Frontend development happening concurrently
Core Responsibilities
* Database Optimization (Priority #1)
* Implement sophisticated indexing, partitioning strategies
* Optimize query performance for complex operations
* Design efficient data access patterns for scale
* 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 our 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
Performance Testing
* Conduct load testing for geospatial operations
* Optimize multi-user real-time connections
* Identify and resolve bottlenecks before launch
In summary:
* PostgreSQL/PostGIS: Deep understanding of query optimization, indexing strategies, and performance tuning
* Supabase: Experience with real-time capabilities and Row Level Security
* Node.js: Ability to create efficient API services with proper resource management
* SQLite: Knowledge of offline-first architecture and synchronization
What We Offer
While compensation is modest:
Professional references from our company and on LinkedIn
Opportunity to shape the architecture of a promising social startup
Potential for on-going relationship as we scale
Project Timeline
Immediate start
1-2 week initial engagement then for ongoing scaling with new features and continued optimisation
Regular collaboration with our Flutter team
Potential for 12+ month ongoing relationship
To Apply, Please Submit:
Please attach resume
Your specific experience with Supabase, PostgreSQL/PostGIS, Node.js, and SQLite
Examples of previous database optimization or geospatial work
Your approach to building scalable database architectures
Your availability in the next 2-4 weeks
This is an opportunity to make a significant architectural impact on an exciting social app with potential for long-term collaboration as we grow.
Seniority level
* Entry level
Employment type
* Contract
* Industries: Higher Education
#J-18808-Ljbffr