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 withlimited 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 TimingsFlexible timings with willingness to support overlapping hours with US time zones (including occasional off-hours / weekend support as needed).Role SummaryWe are looking for an experienced Application Developer & Support Engineer to maintain, enhance, and support a suite ofbusiness-critical legacy applications . These include:A long-running Laboratory Information System used for environmental and analytical testing.Desktop .NET client applicationsused for managing organic and inorganic test workflows, sample results, and quality checks.Aproject/operations dashboardthat 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 areon-premises , usingOracleas the primary transactional database (with some SQL Server reporting), and havecomplex, tightly coupled code and data flowsthat must be understood and handled carefully.The role is a mix ofdevelopment, enhancement, deep troubleshooting, and L2/L3 production support , with strong emphasis onreverse engineering complex legacy systemsand ensuring stability.Technical Capabilities & CompetenciesCore Technical SkillsStrong experience withC# and .NET(legacy frameworks such as .NET Framework, WinForms/WPF and classic ASP.NET Web Forms / MVC).Solid expertise inOracle 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 ofSQL Serverand its use for reporting / analytics.Comfort working inon-premise environmentswith Windows servers, application servers, and database servers.Complex Code & Flow HandlingProven experience inreverse engineering large, legacy codebaseswith limited or outdated documentation.Ability to understand and tracemulti-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 analyzingcomplex stored procedures and PL/SQL packagesto understand business rules implemented at the database layer.Capability to performimpact analysisbefore changing shared components in heavily reused libraries or database objects.Integration & Architecture AwarenessUnderstanding ofclient–server architectures , multi-tier applications, and on-prem network constraints.Familiarity withfile-based integrations, scheduled jobs, and batch processescommonly used in legacy systems.Basic understanding ofauthentication/authorizationpatterns in legacy .NET apps and on-prem environments (Windows auth / forms auth, etc.).Engineering Practices & ToolsHands-on experience withversion control systems(Git, TFS, Azure DevOps or similar).Familiarity withwork management and ITSM tools(JIRA, ServiceNow, Azure DevOps Boards, etc.) for incidents, problems, and changes.Exposure toCI/CDor at least automated build/deployment pipelines for .NET applications (nice to have for future modernization).Key ResponsibilitiesApplication Development & EnhancementsAnalyze 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 usingC#, .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 ManagementProvideL2/L3 supportfor 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 & ReportingDevelop and maintainOracle SQL/PL-SQLobjects (views, procedures, packages, triggers) used by the applications and reports.SupportSQL Server–based reportingcomponents, 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 ManagementPrepare 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.Useversion control(Git/TFS or similar) for branching, merging, and maintaining stable baselines.Stakeholder Collaboration & DocumentationWork 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 Experience5–8+ yearsof experience in Application Development & Support in enterprise environments.Demonstrated experience in supportinglong-running, business-critical legacy systemswith complex business logic and data flows.Experience working indistributed onsite–offshore modelswith overlapping hours to US teams.