PostgreSQL Back-End Developer at MesaStrategy | Torre

PostgreSQL Back-End Developer

Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Full-time

Legal agreement: Contractor

Currency exchange and payroll taxes to be paid by:

Candidate

Compensation
USD1.2k - 2k/month
Non-negotiable
location_on
Remote (anywhere)
Posted over 1 year ago

Responsibilities


• Connect AI-generated front-end applications (built using Loveable and Cursor) to a PostgreSQL data backend. • Develop queries, views, functions, and supporting API layers that serve dynamic data to modern web applications. • Build database views and stored procedures to support front-end features. • Design and maintain PostgreSQL schemas, functions, and queries. • Optimize performance and indexing for live inventory and transactional data. • Integrate with Supabase or other Postgres-compatible platforms as needed. • Collaborate closely with our Spanish-speaking front-end team to ensure smooth data flow. • Handle data validation, transformation, and reporting logic within the database. • Document database structure and business logic for developer handoff. Technical requirements: • 3+ years of experience working with PostgreSQL in a production environment. • Strong SQL skills: joins, CTEs, window functions, indexes, and performance tuning. • Experience creating stored procedures, triggers, and functions. • Familiarity with REST APIs or Supabase Edge Functions. • Proficiency with Git and GitHub workflows for version control. Bonus skills: • Experience with Supabase or PostgREST. • Familiarity with JavaScript or front-end data needs (coding not required). • Experience with data modeling for e-commerce or ERP systems. • Strong reading and writing skills in English; speaking not required.