Emerald Resource Group
Sr Software Developer
About the role
Our client is hiring a Sr Software Developer to own features and fixes from start to finish on a workforce scheduling platform for professional services firms. The product runs on ASP.NET MVC 5 (.NET Framework 4.8), a jQuery era front end and SQL Server 2019, where nearly all business logic lives in stored procedures.
The role also covers a separate ASP.NET Core (.NET 10) service that exposes scheduling and request functions as tools for external AI agents such as Copilot and Claude. It shares no code with the legacy product, calls the same stored procedures through a thin data layer, and defines its endpoints as database catalog rows rather than controllers.
This is a database first role on a small team with continuous peer review and multiple forked client deployments. You will be as comfortable reading a 400 line stored procedure in SSMS as debugging a FullCalendar plugin.
What you will do
The job is to take a ticket from the Azure DevOps board and carry it through coding, peer review, and QA handoff, across every layer the ticket touches.
• Deliver features and fixes end to end. Trace a defect from the browser through the controller and provider to the stored procedure, fix it in the right layer (usually TSQL), and ship it via a repeatable migration.
• Write and maintain stored procedures, views, and functions in TSQL, and check each change against the database forks.
• Build and adjust dynamic UI through the template system (grids, forms, dashboards, reports) rather than hardcoding screens and know when a change needs a template edit versus a code change.
• Maintain the C# layers: MVC controllers, provider classes, Hangfire background jobs, SignalR hubs, MediatR notifications, and the OWIN authentication pipeline.
• Maintain the jQuery front end: the FullCalendar scheduler, ParamQuery grids, dynamic form field plugins, Select2, and DataTables reports.
• Build and maintain AI agent service endpoints (End points are database driven) as catalog rows (contract, operation, endpoint) in repeatable seed migrations for each install, with matching OpenAPI contracts.
• Write the stored procedures behind the API endpoints, keeping agent reachable paths off the heavy report procedures.
• Maintain the AI agent service's shared code: Entra ID JWT authentication, identity resolution, problem details error handling, health checks, OpenTelemetry, and database logging.
• Test the AI agent service end to end: xUnit tests, plus a PowerShell integration script for each completed feature, registered for every install so that it runs in the pipeline.
• Review other developers' work as a routine part of the week by pulling tickets from Coding (Done) into Dev Testing and checking them against the repo specific checklist.
• Add tests where they pay off: tSQLt for stored procedure logic, Playwright for user visible behavior, NUnit for C# utilities.
• Keep the knowledge base current in Docs/knowledge base and the Azure DevOps wiki, and record architectural decisions in the decisions log.