Job Description
We are looking for a Senior PostgreSQL Database Engineer to own Our platform's relational data architecture, data integrity, query performance and database evolution.
n
n This is not a traditional DBA role.
n
nWe 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 Engineers and Senior Backend Engineers.
n
n What You'll Do
n
n
Own Our platform's canonical PostgreSQL data model n
Design schemas for investors, identity/KYC, organizations, properties, ownership, transactions, wallets, documents and audit/history recordsn
Define relationships, primary and foreign keys, constraints and appropriate data typesn




Design tenant-aware data architecture and appropriate tenant-isolation patternsn
Establish database-level integrity controls for sensitive financial and ownership recordsn
Design transaction boundaries and consistency guaranteesn
Handle concurrency using appropriate PostgreSQL isolation and locking strategiesn
Diagnose and prevent race conditions, lock contention and deadlocksn
Design indexing strategies using:n
B-treen
composite indexesn
partial indexesn
GIN/GiST/BRIN where justifiedn
Use EXPLAIN and EXPLAIN ANALYZE to diagnose and optimize production queriesn
Identify inefficient joins, N+1 access patterns and poor query plansn
Review Prisma-generated SQL and identify when raw SQL or database-specific optimization is appropriaten
Design secure, backward-compatible zero/low-downtime migrations n
Develop migration rollback and recovery strategiesn
Design database audit/history patterns appropriate for a

📌 Senior Postgresql Database Engineer North Goa
🏢 MeridianSquare
📍 North Goa