Role Overview

We are looking for a Backend Database Engineer to design, build, secure, and optimize the backend data architecture of a multi-tenant Shopify embedded public application. The engineer will be responsible for ensuring that the PostgreSQL database and backend services remain secure, tenant-isolated, scalable, reliable, and cost-efficient while processing large volumes of Shopify data.

Responsibilities

Design scalable PostgreSQL schemas for a multi-tenant Shopify public application ensuring strict tenant isolation.
Analyze and optimize PostgreSQL and Prisma ORM queries using EXPLAIN and EXPLAIN ANALYZE.
Design safe transactions, implement idempotency protections, and eliminate race conditions.
Build and maintain a durable local mirror of Shopify data using Shopify Bulk Operations and webhooks.
Develop and maintain backend services using Node.js and Express.
Design database-safe BullMQ and Redis job-processing workflows.
Enforce strict security protocols to prevent SQL injection and unauthorized data access.

Requirements

Strong expertise in PostgreSQL, Node.js, Express, and Prisma ORM.
Experience with database transactions, concurrency control, and background-job processing.
Deep understanding of Shopify Admin GraphQL integrations and webhooks.
Proven ability to design scalable, multi-tenant database architectures.
Experience with Redis and queue management systems like BullMQ.

Skills

PostgreSQL
Node.js
Prisma ORM
Redis
GraphQL