Senior Backend Engineer (TypeScript, API, SQL)

View full description

Requirements:

• Proven backend development experience with TypeScript and Node.js.
• Strong expertise in building and managing APIs using Fastify and OpenAPI.
• Extensive experience working with large, complex SQL databases, supporting both Oracle SQL and Microsoft SQL Server.
• Proficiency in writing optimized SQL queries without using an ORM, ensuring efficiency across multiple database platforms.
• Deep understanding of SQL performance optimization, including best practices for handling large datasets.
• Hands-on experience with Knex.js for database query building.
• Strong testing skills, including writing and maintaining unit and integration tests.
• Ability to work independently, following clearly documented tickets and delivering high-quality solutions.

Responsibilities:

• Develop, maintain, and optimize backend services using TypeScript and Node.js.
• Design and implement RESTful APIs with Fastify and OpenAPI, ensuring scalability and performance.
• Work with large-scale legacy SQL databases (Oracle SQL & Microsoft SQL Server) containing hundreds of tables and millions of records.
• Write and optimize complex SQL queries using Knex, ensuring compatibility across multiple database systems.
• Address SQL performance considerations, optimizing queries involving joins, unions, and aggregations for large datasets.
• Implement unit and integration tests to ensure the reliability and stability of backend services.
• Collaborate with cross-functional teams to analyze business requirements and translate them into technical solutions.
• Work independently, efficiently handling clearly defined development tasks from project tickets.