Backend Developer

CAP Index is seeking a skilled backend developer with a strong foundation in API design and SQL database management to join our team and build robust, scalable backend systems. The ideal candidate will have a strong understanding of SQL and application development principles/practices using C#. Additionally, the candidate will have experience migrating business logic from SQL procedures into the application layer. They will also be able to work independently and as part of a team to deliver high-quality results. 

Candidate must be well versed with SQL scripting, stored procedures, C# and REST API development. 

  

Location: This position is eligible for fully remote work; however, Philadelphia area is preferred. Candidate may be required to travel up to 3 times a year. 

  

  

In this role, you will: 

• Develop, maintain, and troubleshoot applications using Microsoft .NET 7.0 or above (C#) with MS SQL Server as the database backend in an agile environment. 

• Help architect and migrate current SQL-based logic into the application layer using C#. 

• Understand how a business system interacts with the database to perform advanced troubleshooting. 

• Work with other developers to perform root cause analysis related to application issues reported by the user community. 

• Understand the application database architecture (SQL, Stored Procedures, Functions) 

• Audit, evaluate and understand existing stored procedures and database scripts to support the application and ongoing enhancements. 

• Create new and modify existing stored procedures/scripts to support application operations and maintenance. 

• Implement back-end functionalities using C# programming language and related frameworks. 

• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. 

• Refine and automate regular processes, track issues, and document changes. 

• Assists other team members with complex query tuning and schema refinement. 

• Perform scheduled maintenance and support release deployment activities after hours. 

• Ensure all scheduled jobs such as backups, ETL loads, and other items, have been executed correctly. 

• Perform data analysis and reporting. 

  

Education and Experience Requirements: 

• Bachelor’s Degree in Computer Science, Information Technology, Engineering, or a related field 

• 5 years of experience working on an application development team 

• 5 years creating, modifying, and implementing database-stored procedures and scripts 

• Experience working with .NET 8 preferred 

• Strong understanding of MS SQL 

• Understanding of Azure Microservices 

• Understanding of MySQL, Postgres, and other database platforms a plus 

• Proficiency in C# programming language and related frameworks 

• Understanding of HTML and JavaScript 

• Must be a team player, process-driven, self-motivated, and able to work independently to meet deadline 

• Position requires strong business/technical verbal and written communication skills 

• Ability to adapt to sudden changes in priorities and requirements 

• Good communication skills, both written and oral 

• Excellent attention to detail 

• Ability to communicate technical issues to all levels