## Description

• Profile & eliminate the top 10 slow queries; target p95 < 150 ms and 50 % CPU drop on RDS.

• Refactor ORM hot‑spots – fall back to raw SQL, CTEs, lateral joins, or PL/pgSQL where warranted.

• Evolve schema & data‑model : partitioning/ sharding, BRIN/GiST indexes, materialised views, retention/archive tables. 

• Design & implement caching strategy (Redis key design, TTL, invalidation hooks). 

• Protect throughput : connection pooling (PgBouncer), read replicas, fail‑over drills. 

• Raise code quality : enforce ESLint rules, increase Jest coverage > 85 %, mentor two mid‑level devs.

## Requirements

• 5+ years building production back‑ends in Node.js/TypeScript/Javascript 

• Deep PostgreSQL performance tuning : EXPLAIN/ANALYSE, index strategy, lock contention, VACUUM/ANALYSE scheduling. 

• AWS Aurora/RDS operations (scaling, snapshots, parameter groups).

• Hands‑on Redis for read caching and rate limiting.

• Comfortable bypassing ORMs to craft, test, and ship raw SQL (incl. migrations). 

• Practical CI/CD knowledge (GitHub Actions, Docker multi‑stage builds).

Senior Backend Engineer

Description

Requirements