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 application processes large volumes of Shopify product, variant, metafield, inventory, bulk-edit, import, export, scheduling, audit, and synchronization data. The engineer will be responsible for ensuring that the PostgreSQL database and backend services remain secure, tenant-isolated, scalable, reliable, and cost-efficient.

This role requires strong expertise in PostgreSQL, Node.js, Express, Prisma ORM, database transactions, concurrency control, background-job processing, and Shopify Admin GraphQL integrations.

Key Responsibilities

Database Architecture

Design scalable PostgreSQL schemas for a multi-tenant Shopify public application.

Ensure every merchant-owned record is strictly scoped using the Shopify store identifier.

Design tenant-secure primary keys, foreign keys, unique constraints, indexes, and relations.

Prevent cross-store data access through internal IDs, Shopify GIDs, job IDs, relation IDs,



or browser-provided identifiers.

Design schemas for product mirrors, filter indexes, bulk-edit jobs, previews, snapshots, audit logs, imports, exports, subscriptions, schedules, idempotency records, and transactional outboxes.

Plan data retention, archival, partitioning, cleanup, and database-growth controls.

Query Performance and Optimization

Analyze and optimize PostgreSQL and Prisma queries.

Identify slow queries, missing indexes, sequential scans, N+1 queries, unnecessary joins, over-fetching, and inefficient pagination.

Use EXPLAIN and EXPLAIN ANALYZE to diagnose query performance.

Design effective composite, covering, partial, expression, GIN, and BRIN indexes where appropriate.

Optimize filtering, sorting, search, counts, facets, and exports against a local Shopify product mirror.

Reduce database compute usage, connection pressure, storage growth, network transfer, and Neo

📌 Backend/Data Engineer (Thrissur)
🏢 Zen Meraki Private
📍 Thrissur