SDE 2 — Backend & Database Engineer

MediBuddy · Bengaluru, India · Full-time · On-site

We're looking for a backend engineer who thinks in query plans, not just code. This is not a typical SDE 2 role, you will own the database layer end-to-end, partnering with SRE and platform teams to keep our Postgres clusters fast, reliable, and resilient at scale.

This is not a typical SDE 2 role. You’ll own both the application layer and the database layer, ensuring systems are correct, performant, and resilient at scale.

Roles and Responsibilities

• Design and develop scalable backend services and APIs for high-throughput, low-latency use cases

• Own end-to-end service performance, from request handling to database execution

• Write clean, maintainable, and testable code with strong production-readiness

• Architect and evolve PostgreSQL schemas for systems handling millions of records

• Model data for correctness, extensibility, and future use cases (not just current state)

• Drive decisions on normalization, denormalization, and data access patterns

• Optimize queries using EXPLAIN ANALYZE, indexing strategies, and execution plan analysis

• Solve real-world issues like slow queries, lock contention, deadlocks, and connection exhaustion

• Tune vacuuming, autovacuum, and storage behavior for sustained performance

• Manage PostgreSQL on AWS RDS & Aurora — parameter tuning, Multi-AZ, read replicas, failover

• Understanding of connection pooling and efficient resource usage

• Plan and execute zero-downtime migrations and schema changes

• Build end-to-end observability across services and databases

• Create dashboards and alerts using CloudWatch (or similar tools)

• Monitor and act on key metrics like latency, connections, storage, and replication lag

• Set up and manage streaming replication and failover mechanisms

• Run failover drills and validate RTO/RPO in practice

• Debug production issues across application, database, and infrastructure layers

• Use CloudWatch, Enhanced Monitoring, Secrets Manager, and S3 effectively

• Ensure secure and reliable credential management and backups

• Define and enforce best practices for backend and database development

• Mentor engineers on API design, data modeling, and performance thinking

• Drive a culture of measuring, debugging, and improving systems continuously

What We’re Looking For

• Strong experience building backend services (C#, node, python)

• Solid hands-on experience with PostgreSQL in production

• Deep understanding of APIs, system design, and service architecture

• Strong grasp of query optimization, indexing, and execution plans

• Experience with transactions, concurrency, and data consistency models

• Familiarity with AWS (RDS/Aurora, CloudWatch, etc.)

• Ability to debug complex production issues end-to-end