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
nThis 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
nWhat You'll Do
n
- n
- Own Our platform's canonical PostgreSQL data modeln
- 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 migrationsn
- Develop migration rollback and recovery strategiesn
- Design database audit/history patterns appropriate for a re