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.
limited documentation
Work Timings
Flexible timings with willingness to support overlapping hours with US time zones (including occasional off-hours / weekend support as needed).
Role Summary
business-critical legacy applications
- 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.
on-premises
development, enhancement, deep troubleshooting, and L2/L3 production support
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.
