Application Developer

The ideal candidate has strong hands-on expertise in C# and legacy .NET frameworks (WinForms/WPF and ASP.NET Web Forms/MVC), with solid experience in Oracle SQL and PL/SQL (complex queries, packages, triggers, performance tuning) and working knowledge of SQL Server for reporting and analytics. They are comfortable working in on-premises, Windows-based environments with multi-tier client/server architectures, scheduled jobs, and batch processes, and can collaborate closely with DBAs and infrastructure teams. The candidate should be highly capable of reverse engineering large, legacy codebases with limited documentation, tracing end-to-end flows across UI, business logic, data access, and database layers, and performing thorough impact analysis before making changes. Strong debugging skills (logs, profilers, Visual Studio), experience handling business-critical production incidents (L2/L3), and familiarity with version control (Git/TFS) and ITSM tools (e.g., ServiceNow, JIRA) are essential. Experience with Information / lab / quality / operations systems or similar complex transactional applications is a strong plus. Work Timings Flexible timings with willingness to support overlapping hours with US time zones (including occasional off-hours / weekend support as needed). Role Summary We are looking for an experienced Application Developer & Support Engineer to maintain, enhance, and support a suite of business-critical legacy applications. These include: A long-running Laboratory Information System used for environmental and analytical testing. Desktop .NET client applications used for managing organic and inorganic test workflows, sample results, and quality checks. A project/operations dashboard that consolidates lab/project performance data from Oracle and SQL Server for reporting. Web applications (on-prem .NET) used for lab data preparation, operational workflows, and internal employee/HR information. All applications are on-premises, using Oracle as the primary transactional database (with some SQL Server reporting), and have complex, tightly coupled code and data flows that must be understood and handled carefully. The role is a mix of development, enhancement, deep troubleshooting, and L2/L3 production support, with strong emphasis on reverse engineering complex legacy systems and ensuring stability. Technical Capabilities & Competencies Core Technical Skills Strong experience with C# and .NET (legacy frameworks such as .NET Framework, WinForms/WPF and classic ASP.NET Web Forms / MVC). Solid expertise in Oracle Database: Advanced SQL (joins, analytical functions, performance-oriented queries). PL/SQL (procedures, functions, packages, triggers). Understanding of indexing, execution plans, and query tuning. Working knowledge of SQL Server and its use for reporting / analytics. Comfort working in on-premise environments with Windows servers, application servers, and database servers. Complex Code & Flow Handling Proven experience in reverse engineering large, legacy codebases with limited or outdated documentation. Ability to understand and trace multi-layered architectures (UI, business logic, data access, database) and dependencies between modules. Strong debugging skills: Using Visual Studio debuggers, logs, and profilers to trace issues across layers. Diagnosing intermittent production issues (e.g., race conditions, memory leaks, connection pool issues, timeouts). Experience analyzing complex stored procedures and PL/SQL packages to understand business rules implemented at the database layer. Capability to perform impact analysis before changing shared components in heavily reused libraries or database objects. Integration & Architecture Awareness Understanding of client–server architectures, multi-tier applications, and on-prem network constraints. Familiarity with file-based integrations, scheduled jobs, and batch processes commonly used in legacy systems. Basic understanding of authentication/authorization patterns in legacy .NET apps and on-prem environments (Windows auth / forms auth, etc.). Engineering Practices & Tools Hands-on experience with version control systems (Git, TFS, Azure DevOps or similar). Familiarity with work management and ITSM tools (JIRA, ServiceNow, Azure DevOps Boards, etc.) for incidents, problems, and changes. Exposure to CI/CD or at least automated build/deployment pipelines for .NET applications (nice to have for future modernization). Key Responsibilities Application Development & Enhancements Analyze functional and technical requirements for enhancements across lab workflow, operational dashboard, and internal web portals. Design, develop, and unit test new features, reports, and UI changes using C#, .NET (legacy frameworks), Oracle SQL/PL-SQL, and related technologies. Refactor and optimize legacy modules while preserving existing behavior and ensuring regression-free delivery. Participate in code reviews and ensure adherence to coding standards and secure coding practices. Production Support & Incident Management Provide L2/L3 support for incidents, problems, and service requests across all applications in scope. Perform end-to-end analysis of issues (UI → business logic → data access → database) using logs, profilers, and SQL analysis. Perform root cause analysis for recurring problems and propose long-term fixes, not just workarounds. Work within defined SLAs for impact assessment, communication, and resolution, including handling priority incidents during non-standard hours if required. Database & Reporting Develop and maintain Oracle SQL/PL-SQL objects (views, procedures, packages, triggers) used by the applications and reports. Support SQL Server–based reporting components, ensuring consistent data between Oracle transactional systems and reporting layers. Work with DBAs to investigate performance bottlenecks (slow queries, blocking, indexing, statistics, etc.). Release & Change Management Prepare deployment packages, change scripts, and release notes for application and database changes. Coordinate promotion of changes across Dev / Test / Prod environments in line with change management processes. Use version control (Git/TFS or similar) for branching, merging, and maintaining stable baselines. Stakeholder Collaboration & Documentation Work closely with onsite IT teams, business users, QA, and operations teams to clarify requirements and validate solutions. Document technical design, data flows, configuration details, and support runbooks for complex modules. Provide knowledge transfer and onboarding support to other team members as needed. Required Experience 5–8+ years of experience in Application Development & Support in enterprise environments. Demonstrated experience in supporting long-running, business-critical legacy systems with complex business logic and data flows. Experience working in distributed onsite–offshore models with overlapping hours to US teams.