senior-backend

You can scaffold REST API routes by generating route handlers, validation middleware, and TypeScript types directly from OpenAPI specifications. This automated API scaffolding instantly creates the foundational structure for your backend systems.

The best way to identify N+1 query risks is by analyzing your database schema for performance bottlenecks. This process evaluates schema performance and generates migration files with rollback support to optimize PostgreSQL queries.

You load test API performance by validating endpoints under stress with configurable concurrency and latency reporting. This performance load testing ensures your production backend systems maintain expected response times.

Yes, you can use Express and Fastify patterns for secure authentication flows. The skill designs scalable backend architectures integrating Node.js development patterns with security hardening practices using Helmet.

Zod validation middleware works seamlessly with generated API route handlers. The skill scaffolds validation middleware alongside route handlers and TypeScript types to ensure data integrity across your REST APIs.

You need database migration files with rollback support when optimizing PostgreSQL schema performance or refactoring legacy APIs. This ensures safe schema evolution while identifying missing database indexes for production environments.