Backend Developer (Node.js + MS SQL + SSRS)

Freelancing Opportunity

Job Title: Backend Developer (Node.js + MS SQL + SSRS)
Experience: 5–6 years

Job Summary

We are looking for a skilled Backend Developer who can build and optimize API services that power data retrieval for multiple reports, including Contracts List, Chart of Accounts, and Register of Directors/Officers. The ideal candidate will be proficient in Node.js, MSSQL, SSRS, and must be able to implement dynamic filtering, pagination, and stored procedure–based data retrieval.

Key Responsibilities

• Develop and maintain REST APIs in Node.js to serve data for reporting modules.
• Implement dynamic filter parameters, search conditions, and pagination for large datasets.
• Write, optimize, and maintain MSSQL stored procedures, functions, and queries.
• Integrate backend services with SSRS reports for data extraction.
• Ensure APIs correctly call the required stored procedures and return processed results.
• Implement error handling, input validation, and performance optimization.
• Collaborate with front-end and reporting teams to define data requirements and expected outputs.
• Troubleshoot and resolve issues related to data fetching, SQL performance, and API response times.
• Maintain documentation for APIs, database procedures, and data workflows.

Required Skills & Experience

• 3+ years of backend development experience.
• Strong hands-on experience in Node.js (Express/NestJS preferred).
• Proficiency in MS SQL Server, including:
• Stored procedures
• Joins & indexing
• Query optimization
• Views & functions
• Experience with SSRS (SQL Server Reporting Services).
• Ability to implement server-side pagination, filtering, and sorting.
• Familiarity with API security, authentication, and authorization.
• Working knowledge of Git, Postman, and debugging tools.

Preferred Skills

• Experience with enterprise data systems or reporting tools.
• Understanding of data modeling and ETL concepts.
• Exposure to Azure SQL or cloud-hosted SQL environments.

What You’ll Work On

• APIs that fetch data for legal and financial reports.
• Endpoints that support complex filter parameters (date, status, type, entity, etc.).
• Backend logic that interacts heavily with SQL stored procedures.
• Pagination logic to handle large datasets efficiently.

Job Types: Part-time, Freelance
Contract length: 12 months

Pay: ₹30,000.00 - ₹40,000.00 per month

Benefits:

• Work from home

Experience:

• total work: 6 years (Required)

Shift availability:

• Night Shift (Required)
• Overnight Shift (Required)

Work Location: Remote