Postgres Data Architect for Multi-Tenant SaaS

seRevel; New York (NY); Remote; USD 120,000 - 170,000; Full time

Job summary

seRevel is an AI-native POC management platform built by Sales Engineers for Sales Engineers. The data lives in Postgres and you will own the database, including schema, performance, migrations, backups, and tenant isolation.

The team is small, early stage, and the data model is yours to shape. What you will do focuses on schema design for multi-tenant SaaS, enforcing isolation at the database layer, and running zero-downtime migrations while collaborating with Next.js and Node code.

Qualifications

• Hands-on PostgreSQL in production: schema design, indexing, query tuning, and day-to-day operations.
• Experience designing multi-tenant data models and explaining trade-offs.
• Migrations on live systems and real restoration from backups.
• Proficiency in TypeScript and Node.js to read and adjust queries.

Responsibilities

• Own schema design for a multi-tenant SaaS: POCs, use cases, customer portals, synced integration data, and AI outputs.
• Enforce tenant isolation at the database layer so no cross-workspace queries occur.
• Design and run zero-downtime migrations alongside Next.js/Node code dependencies.
• Tune performance for connector syncs and AI worker reads; optimize indexes and query plans.
• Build and test backups, restores, and recovery processes.
• Set up encryption at rest, TLS to the database, and least-privilege roles for services.
• Plan for growth: partitioning, archiving, and capacity for increased data.

Skills

PostgreSQL

Schema design

Indexing

Query tuning

Tenant isolation

TypeScript

Node.js

Tools

Docker

Job description

seRevel is an AI-native POC management platform built by Sales Engineers for Sales Engineers. The data lives in Postgres and you will own the database, including schema, performance, migrations, backups, and tenant isolation.

The team is small, early stage, and the data model is yours to shape. What you will do focuses on schema design for multi-tenant SaaS, enforcing isolation at the database layer, and running zero-downtime migrations while collaborating with Next.js and Node code.