We are building a high-performance, multi-tenant B2B SaaS application designed for massive-scale bulk data processing. Our platform mirrors large catalogs of external data for thousands of tenants, requiring the system to handle millions of rows and execute complex filters. Our backend is powered by Node.js, distributed task queues, and a serverless PostgreSQL database hosted on Neon.

The Role

We are seeking a highly motivated Junior PostgreSQL Database Engineer (with ~1 year of experience) to help build, support, and optimize our Neon database architecture. You will work closely with our backend engineering team to bridge the gap between our Node.js environment, our ORM, and raw SQL. This is a high-growth prospect where you will get hands-on experience dealing with extreme concurrency, multi-tenant data modeling, and serverless Postgres at scale.

Key Responsibilities

- Query Development: Write, test, and optimize complex SQL queries, learning to build efficient filtering logic using subqueries and specific indexing.
- Schema Support: Work within our multi-tenant schema structure, ensuring queries maintain strict data isolation between tenant accounts.
- Data Ingestion: Assist in writing and optimizing upsert logic (INSERT ... ON CONFLICT DO UPDATE) to handle high-volume webhooks without locking tables.
- ORM to SQL Translation: Help identify when generated ORM queries (Prisma)



are slowing down the system and rewrite them into highly performant raw SQL for our background worker jobs.
- Database Operations: Use Neon’s database branching features to safely test schema migrations and support the team in monitoring connection pooling limits.

Required Qualifications

- Database Foundations: ~1 year of hands-on, professional experience working with PostgreSQL.
- Core SQL Skills: Strong grasp of relational database fundamentals, joins, constraints, and basic indexing strategies.
- Backend Familiarity: Experience working alongside Node.js environments and an understanding of how backend code interacts with databases via ORMs.
- Growth Mindset: A strong desire to learn advanced Postgres topics (like analyzing EXPLAIN plans, fillfactor tuning, and partial indexing) and serverless database architecture.
- Problem Solving: Ability to debug slow queries and a basic understanding of why massive tables slow down under load.

Nice-to-Haves

- Any prior exposure to serverless Postgres platforms (like Neon or Supabase).
- Familiarity with managing JSON/JSONB data within PostgreSQL.
- Basic knowledge of Redis, message brokers, or background job queues.
- Side projects or experience demonstrating an interest in database optimization.

Pay: ₹200,000.00 - ₹1,470,000.00 per year

Work Location: In person

📌 PostgreSQL DBA (Thrissur)
🏢 Zen Meraki Private
📍 Thrissur