Backend Developer
6 days ago
Backend Developer (API & SQL)
This opportunity
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 API development principles and practices. 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.
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:
Bachelors 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 is a plus
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
remote work