Database (Backend) Engineer (Express, Supabase, PostgreSQL)

About the Role
We are looking for a highly skilled Backend Engineer to design, develop, and maintain the backend infrastructure of our AI-powered platform. You will play a critical role in shaping our database architecture, optimizing API performance, and ensuring scalability. The ideal candidate has deep experience with Express.js, Supabase, and PostgreSQL, including advanced PostgreSQL features like pg_cron, pg_crypto, and other extensions that enhance performance, security, and automation.

Please review the job description thoroughly. To apply, please fill out this form: Upgrade to see actual info

Responsibilities
• Design & optimize backend architecture: Create scalable, efficient, and maintainable database schemas in PostgreSQL (Supabase).
• Develop robust REST APIs: Build and optimize Express.js APIs that serve our frontend and external integrations.
• PostgreSQL optimization: Implement and maintain pg_cron for scheduled tasks, pg_crypto for security, and other extensions to improve efficiency.
• Database migrations & indexing: Optimize database performance through proper indexing, caching strategies, and schema design.
• Authentication & security: Implement authentication using Supabase Auth and ensure backend security best practices.
• Scaling & monitoring: Build efficient query patterns, optimize Supabase functions, and ensure system reliability.
• Testing & CI/CD: Implement unit and integration tests for APIs and database functions.
• Collaboration: Work closely with frontend, AI engineers, and product teams to ensure seamless data flow.

Requirements
• 3+ years of backend development experience with Node.js & Express.js.
• Strong expertise in PostgreSQL, including experience with:
• pg_cron (scheduling tasks)
• pg_crypto (encryption, hashing)
• Row-level security (RLS) and Supabase policies
• Materialized views, indexing, and query optimization
• Hands-on experience with Supabase, including storage, authentication, and real-time subscriptions.
• Understanding of database replication, partitioning, and performance tuning.
• Experience designing and documenting RESTful APIs.
• Knowledge of Supabase Edge Functions and how they interact with the backend.
• Experience with Redis, Cloudflare Workers, or queue-based architectures (Cloudflare Queues, BullMQ, etc.) is a plus.
• Familiarity with testing frameworks for backend applications (Jest, Supertest, etc.).
• Strong problem-solving skills and ability to work in a fast-paced environment.

Bonus Skills
• Experience with GraphQL APIs.
• Knowledge of AI-related APIs or LLM integrations.
• Familiarity with Serverless frameworks.
• Prior experience in building analytics or logging systems.