This opportunity
CAP Index is seeking a talented and experienced SQL and C# application developer to join our team. The ideal candidate will have a strong understanding of SQL and application development principles and practices and full-stack development experience using C# and Angular/TypeScript. 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 will be required to travel up to 3 times a year.
In this role, you will:
- Develop, maintain, and troubleshoot applications using Angular 15+, 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 users.
- 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.
- 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.
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
- 2+ years working with Angular / TypeScript 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 organization skills and calm under pressure
- Excellent attention to detail
- Strong interpersonal skills and mature judgment
- Ability to communicate technical issues to all levels
Job Type: Full-time
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Flexible schedule
- Health insurance
- Paid time off
- Tuition reimbursement
- Vision insurance
Schedule:
Application Question(s):
- Do you have any experience working with Microservices in Azure?
Education:
Experience:
- SQL: 5 years (Required)
- .NET: 5 years (Preferred)
- C#: 5 years (Required)
- Angular: 2 years (Preferred)
Language:
Work Location: Remote