Senior Backend Engineer
Senior Backend Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
The Opportunity
A growth-stage B2B / Saas / Data Platform client of ours processes 10k req/s and 3TB of relational data today; customer onboarding this quarter will push volumes 5100. Hotspots already appear in Sequelizegenerated queries throttling Aurora PostgreSQL and driving up AWS spend.
Why Is this role open
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!).
Current Stack
(v16) / TypeScript Sequelize ORM
Aurora PostgreSQL 15 primary Redis/ElastiCache for lowlatency cache
AWS ECS Fargate Docker GitHub Actions CI/CD
Observability: New Relic pgstatstatements autoexplain
Auth: JWT today migration to Stytch planned Q4
Tests: Jest (unit integration with TestcontainersPostgres)
What Youll Do (Key Outcomes)
Profile & eliminate the top 10 slow queries; target p95 <150ms and 50% CPU drop on RDS.
Refactor ORM hotspots fall back to raw SQL CTEs lateral joins or PL/pgSQL where warranted.
Evolve schema & datamodel: 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 failover drills.
Raise code quality: enforce ESLint rules increase Jest coverage >85% mentor two midlevel devs.
MustHave Experience
5years building production backends in PostgreSQL performance tuning: EXPLAIN/ANALYSE index strategy lock contention VACUUM/ANALYSE scheduling.
AWS Aurora/RDS operations (scaling snapshots parameter groups).
Handson 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 multistage builds).
NicetoHave
Experience integrating thirdparty auth providers (Stytch/Auth0).
Costoptimisation mindset in lean startups (rightsizing RDS spot instances).
New Relic or Datadog custom dashboards.
Exposure to GraphQL OpenAPI/Swagger or eventdriven patterns (SNS/SQS).
If this sounds like something youd enjoy and be great at then please apply! This is a remote freelance opportunity paid via fixed day-rate (negotiable)
Employment Type
Full Time
