Senior .NET Developer (Contract) – SQL Modernization & Microservices
Location: Remote (Philadelphia area preferred) Travel: not required Type: Contract
CAP Index is seeking a highly experienced Senior .NET Backend Developer (Contract) to support a major modernization initiative for our customizable risk assessment and guarding management platform. This platform enables our clients to assess security risks using weighted factors and configure it to meet their unique operational requirements. We’re transitioning from a SQL-driven monolithic backend to a modern microservices architecture, and we need a technical expert to help lead that effort.
This is a critical role for someone who thrives in decoupling legacy logic, building scalable APIs, and designing robust data solutions that support configurable client-facing products.
This is a 6-month contract role ideal for a seasoned developer with extensive experience migrating SQL logic into microservices, optimizing databases, and building scalable APIs. Based on performance and project needs, there is strong potential for a contract extension or full-time hire.
Project Overview
You’ll work on the backend of a highly customizable, client-facing platform used by large enterprises to evaluate risk and manage physical security measures. The system allows for the dynamic weighting of security factors, custom rule sets, and tailored reporting, making flexibility and performance essential. We’re migrating business logic from a SQL-heavy structure into a more maintainable, modular service-based architecture.

In this role, you will:

• Lead the migration of SQL stored procedures and database logic into .NET-based microservices
• Design and implement scalable, maintainable RESTful APIs using C# (.NET 8) and modern backend frameworks
• Analyze existing stored procedures, functions, and complex T-SQL scripts to translate business logic into clean, testable application code
• Refactor and optimize existing business-logic in SQL Server for better performance and maintainability
• Collaborate with developers and architects to evolve a monolithic architecture into modular services
• Provide technical leadership and guidance on SQL optimization, microservices design, and best practices
• Participate in troubleshooting, root cause analysis, and post-release support
• Ensure reliability of scheduled backend processes, ETL jobs, and database maintenance routines
• Occasionally assist in query tuning, schema changes, and cross-database migration ef

Required Experience:

• 5+ years of hands-on experience with C# and .NET application development (preferably .NET 7/8)
• Strong expertise in SQL Server, including stored procedures, indexing, performance tuning, and data modeling
• Demonstrated experience migrating business logic from SQL to the application layer
• Proficiency in designing and building RESTful APIs and backend services
• Solid understanding of microservices architecture in Azure
• Ability to work independently and take ownership of end-to-end backend system functionality
• Experience in troubleshooting production issues, reviewing logs, and identifying performance bottlenecks
• Excellent written and verbal communication skills, with the ability to explain complex technical issues to both technical and non-technical audiences
• Experience with Azure microservices, containerization (Docker, Kubernetes), or CI/CD pipelines

Nice-to-Haves

• Familiarity with additional RDBMS platforms like MySQL or PostgreSQL
• Background in building configurable or multi-tenant enterprise systems
• Exposure to frontend technologies (HTML, JavaScript) for integration support

Why Join This Project?

• High-impact work: Your efforts will directly drive the modernization of a platform used by top-tier enterprises to make critical security decisions.
• Flexible remote environment with minimal travel
• Initial 6-month contract with high potential for extension or full-time hire
• Collaborate with a smart, dedicated team on a high-visibility initiative
• Influence architectural decisions and leave a lasting mark on a major system upgrade

• Lead the migration of SQL stored procedures and database logic into .NET-based microservices
• Design and implement scalable, maintainable RESTful APIs using C# (.NET 8) and modern backend frameworks
• Analyze existing stored procedures, functions, and complex T-SQL scripts to translate business logic into clean, testable application code
• Refactor and optimize existing business-logic in SQL Server for better performance and maintainability
• Collaborate with developers and architects to evolve a monolithic architecture into modular services
• Provide technical leadership and guidance on SQL optimization, microservices design, and best practices
• Participate in troubleshooting, root cause analysis, and post-release support
• Ensure reliability of scheduled backend processes, ETL jobs, and database maintenance routines
• Occasionally assist in query tuning, schema changes, and cross-database migration e