Position: Application Developer

Job Type: Full-Time, On-Site

Location: Troy, MI

Description

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. This 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.

Essential job functions:

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.

Qualifications

• 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 Microsoft web application development.
• Strong Microsoft SQL Server and T-SQL experience, including stored procedures, joins, data updates, troubleshooting, and query optimization.
• Experience supporting existing production applications and resolving application or data-related issues.
• Experience with the software development lifecycle, including requirements review, development, testing, deployment, and production support.
• Ability to analyze complex application and data-processing issues independently.
• Strong written, verbal, documentation, and collaboration skills.

Preferred Skills and Qualifications

• Experience developing solutions using .NET 8, .NET 9, or .NET 10.
• Experience modernizing applications from legacy .NET Framework platforms to current .NET technologies.
• Experience with REST APIs, SOAP web services, JSON, XML, SFTP, file-processing interfaces, or external integrations.
• Experience with Microsoft IIS-hosted applications and Git or other source control tools.
• Experience with application logging, exception management, troubleshooting tools, and production monitoring.
• Familiarity with scheduled processing or automation platforms such as VisualCron.
• Experience supporting client-facing business applications or systems with high data accuracy requirements.
• Familiarity with secure coding practices, access controls, and audit/compliance expectations.

Technical Skill Expectations

• C# and Microsoft .NET application development
• Legacy application maintenance using .NET Framework 4.8
• New development and modernization using .NET 10
• SQL Server development, stored procedures, and production troubleshooting
• IIS-hosted applications, APIs, web services, XML, JSON, and file-based integrations
• Application testing, deployment support, documentation, and root cause analysis

Key Competencies

• Strong problem-solving and analytical ability, including troubleshooting from both code and database perspectives.
• Ability to manage multiple priorities in a production-support environment.
• Sound judgment when making changes to business-critical applications and data.
• Clear communication with technical and non-technical stakeholders.
• Commitment to quality, testing, documentation, and data accuracy.
• Ability to work independently while collaborating effectively within a small IT and development team.

Physical Requirements:

• 100% onsite role (5 days/week)
• Occasional after-hours support as needed