Tech Stack
AWSDockerGraphQLJavaScriptJestNode.jsPostgresRedisSQLTypeScript
About the role
- A growth-stage B2B / Saas / Data Platform client of ours processes ~10 k req/s and ~3 TB of relational data today; customer onboarding this quarter will push volumes 5–100× . Hotspots already appear in Sequelize‑generated queries, throttling Aurora PostgreSQL and driving up AWS spend.
- Our client needs a senior engineer who lives and breathes SQL performance to get them ahead of that curve (I.e. prep & plan to scale up data volumes immensely!).
- Duration : 4 months estimated (extension possible)
- Weekly Commitment : 5 days per week, full-time (Freelance)
- Current Stack Node.js (v16+) / TypeScript · Express.js · Sequelize ORM
- Aurora PostgreSQL 15 primary, Redis/ElastiCache for low‑latency cache
- AWS ECS Fargate · Docker · GitHub Actions CI/CD
- Observability: New Relic, pg_stat_statements, auto_explain
- Auth: JWT today, migration to Stytch planned Q4
- Tests: Jest (unit, integration with Testcontainers‑Postgres)
Requirements
- 5+ years building production back-ends in Node.js/TypeScript
- Deep PostgreSQL performance tuning : EXPLAIN/ANALYSE, index strategy, lock contention, VACUUM/ANALYSE scheduling.
- Comfortable bypassing ORMs to craft, test, and ship raw SQL (incl. migrations).
- Practical CI/CD knowledge (GitHub Actions, Docker multi‑stage builds).
- Nice‑to‑Have Experience integrating third‑party auth providers (Stytch/Auth0).
- Cost‑optimisation mindset in lean start‑ups (right-sizing RDS, spot instances).
- New Relic or Datadog custom dashboards.
- Exposure to GraphQL, OpenAPI/Swagger, or event‑driven patterns (SNS/SQS).