senior-backend

To design and secure a RESTful API with Node.js and PostgreSQL, you can scaffold endpoints, implement authentication using bcrypt and jsonwebtoken, and optimize database queries using Prisma or Knex.

To optimize PostgreSQL queries in a Node.js backend, you can analyze and refine database operations using query builders like Knex or ORMs like Prisma and TypeORM to ensure data integrity and efficient retrieval.

You can implement authentication and session management in microservices by using jsonwebtoken for stateless tokens, bcrypt for password hashing, and connect-redis with express-session for distributed session caching.

While Prisma and TypeORM are separate ORMs, you can manage database migrations and ensure data integrity using either tool alongside PostgreSQL to handle schema changes and query optimization in your backend architecture.

You can load test APIs to measure performance under stress and harden backend security against XSS by integrating isomorphic-dompurify and xss libraries to sanitize inputs, alongside express-rate-limit to prevent abuse.

Yes, the backend skill supports managing application secrets using node-vault and leveraging Redis for rate limiting and session caching to build scalable and secure microservices architectures.