senior-backend - Backend System Design, API Scaffolding, Database Optimization & Security Hardening
Designs and implements backend systems including REST APIs, microservices, database architectures, authentication flows, and security hardening with tooling for API scaffolding, database migrations, and load testing.
Tags
Updated: 2026-06-30Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Generate API route handlers from OpenAPI spec
- Generate OpenAPI spec from existing routes
- Analyze database schemas and detect changes
- Generate database migration files
- Perform API load testing
- Suggest database index optimizations
- Generate validation middleware
- Compare API endpoint performance
Inputs
- OpenAPI spec file (YAML/JSON)
- Database connection string
- Database schema files
- API endpoint URL
- Load test configuration
Outputs
- Route handler source files
- Validation middleware source files
- TypeScript type definitions
- OpenAPI specification files
- Database migration files
- Schema diff reports
- Performance test reports
Requirements
- Python runtime environment
- Node.js with Express, Fastify, or Koa framework
- PostgreSQL database access for migration tools
- Network access to target API endpoints for load testing