Job DescriptionWe 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 atraditional 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 records N
- Define relationships, primary and foreign keys, constraints and appropriate data types N
- Design tenant-aware data architecture and appropriate tenant-isolation patterns N
- Establish database-level integrity controls for sensitive financial and ownership records N
- Design transaction boundaries and consistency guarantees N
- Handle concurrency using appropriate PostgreSQL isolation and locking strategies N
- Diagnose and prevent race conditions, lock contention and deadlocks N
- Design indexing strategies using: N
- B-treen
- composite indexes N
- partial indexesn
- GIN/GiST/BRIN where justified N
- Use EXPLAIN and EXPLAIN ANALYZE to diagnose and optimize production queries N
- Identify inefficient joins, N+1 access patterns and poor query plans N
- Review Prisma-generated SQL and identify when raw SQL or database-specific optimization is appropriate N
- Design protected, backward-compatible zero/low-downtime migrations N
- Develop migration rollback and recovery strategies N
- Design database audit/history patterns