We are looking for a Senior PostgreSQL Database Engineer to own Our platform's relational data architecture, data integrity, query performance and database evolution.
This is not a traditional DBA role.
We are not primarily looking for someone to administer database servers, patch installations or manage user accounts. We need a hands-on PostgreSQL engineer who can design a production schema from the ground up, enforce data integrity at the database layer, analyze query execution plans, solve performance and concurrency problems, and safely evolve a live database as the platform scales.
You will work closely with our Lead Full Stack Platform Engineer and Senior Backend Engineer.
What You'll Do
Own Our platform's canonical PostgreSQL data model
Design schemas for investors, identity/KYC, organizations, properties, ownership, transactions, wallets, documents and audit/history records
Define relationships, primary and foreign keys, constraints and appropriate data types
Design tenant-aware data architecture and appropriate tenant-isolation patterns




Establish database-level integrity controls for sensitive financial and ownership records
Design transaction boundaries and consistency guarantees
Handle concurrency using appropriate PostgreSQL isolation and locking strategies
Diagnose and prevent race conditions, lock contention and deadlocks
Design indexing strategies using:
B-tree
composite indexes
partial indexes
GIN/GiST/BRIN where justified
Use EXPLAIN and EXPLAIN ANALYZE to diagnose and optimize production queries
Identify inefficient joins, N+1 access patterns and poor query plans
Review Prisma-generated SQL and identify when raw SQL or database-specific optimization is appropriate
Design secure, backward-compatible zero/low-downtime migrations
Develop migration rollback and recovery strategies
Design database audit/history patterns appropriate for a regulated platform
Establish connection-pooling strategies using PgBouncer or equivalent
Establish database performance

📌 Senior PostgreSQL Database Engineer (India)
🏢 MeridianSquare
📍 India