Application Developer

Position Overview

The Application Developer – .NET/SQL Server is a mid-level development role responsible for maintaining, enhancing, and supporting business-critical applications and integrations used across the organization and by external clients.

This position will work primarily with applications built on .NET Framework 4.8 while participating in the design and development of new or modernized solutions using .NET 10. The role requires strong hands‑on experience with Microsoft SQL Server and T‑SQL, including stored procedures, data analysis, troubleshooting, query optimization, and data‑driven application workflows.

The developer will work closely with IT, business analysts, client‑facing teams, and other developers to resolve issues, deliver enhancements, support integrations, and improve system reliability.

• Position: Application Developer
• Job Type: Full‑Time, On‑Site
• Location: Troy, MI

Application Development and Maintenance

• Maintain, troubleshoot, and enhance existing applications developed using C# and .NET Framework 4.8.
• Develop new application functionality and modernized solutions using .NET 10 and current Microsoft development practices.
• Analyze business requirements and translate them into reliable, supportable application solutions.
• Modify and support web applications, background processes, scheduled jobs, APIs, web services, and system integrations.
• Develop clean, maintainable, testable, and documented code aligned with organizational standards.
• Participate in modernization efforts where legacy application functionality is transitioned into current .NET technologies.

SQL Server and Data Development

• Write, maintain, and troubleshoot complex T‑SQL queries, stored procedures, views, functions, and data‑processing routines.
• Investigate application and integration issues involving missing, incorrect, duplicated, or improperly processed data.
• Support data imports, exports, interfaces, automated processes, and client‑specific business workflows.
• Review SQL logic for accuracy, performance, reliability, and maintainability.
• Assist with SQL performance troubleshooting, including inefficient queries, blocking, execution delays, and large data operations.
• Perform controlled data corrections when required, with appropriate validation, documentation, and approvals.

Application Support and Production Issue Resolution

• Investigate production application issues, identify root cause when possible, and implement or coordinate corrective action.
• Support business‑critical line‑of‑business applications, including eGAMS and related client‑facing processes.
• Support incidents involving integrations, scheduled processing, web services, database procedures, application errors, and data discrepancies.
• Participate in prioritization and resolution of application‑related tickets based on business impact and client needs.
• Document findings, resolutions, workarounds, and preventive improvements.

Integrations, Testing, and Deployment

• Develop and support interfaces between internal applications, external client systems, databases, APIs, file transfers, and automated processing platforms.
• Troubleshoot inbound and outbound file processing, web service communication, API integrations, and scheduled application processes.
• Create and execute developer‑level unit, integration, and regression testing plans for application changes, enhancements, corrections, and integrations; coordinate independent user acceptance testing with business stakeholders or a designated testing resource.
• Support controlled deployments across development, testing, beta, and production environments.
• Document application changes, SQL changes, deployment instructions, rollback considerations, and technical procedures.
• Participate in post‑deployment validation and resolution of release‑related issues.

• Bachelor's degree in Computer Science, Information Systems, Software Development, or a related discipline; or equivalent relevant professional experience.
• Three to five years of professional application development experience in a Microsoft‑based environment.
• Strong development experience with C#, .NET Framework 4.8, ASP.NET and/or…