DB Developer (PL/SQL Oracle, .Net developer)

Papigen; India; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Papigen is looking for a Senior Database Developer in India to support enhancements for a complex financial accounting application. The ideal candidate will have over 8 years of experience in Oracle PL/SQL, strong knowledge of ASP.NET Web API, and experience with ETL tools like Informatica. Key responsibilities include database development, performance tuning, and collaboration in an Agile environment.

Strong problem-solving skills and experience in financial/accounting systems are essential.

Qualifications

• 8+ years of experience in Oracle PL/SQL and database development.
• Strong knowledge of Oracle 19: SQL, Packages, Views, Triggers.
• Hands-on experience with ASP.NET Web API, C#, .NET Framework.

Responsibilities

• Design, develop, and maintain Oracle database objects.
• Build and optimize complex SQL queries.
• Support end-to-end SDLC in an Agile environment.

Skills

Oracle PL/SQL

ASP.NET Web API

Performance tuning

ETL development

Agile methodologies

Problem-solving

Tools

Informatica

Oracle Scheduler

Job description

Job Summary

We are seeking a Senior Database Developer with strong expertise in Oracle PL/SQL and .NET to support enhancements for a complex financial accounting application. The role focuses on database development, performance tuning, ETL pipelines, and full SDLC delivery in an Agile environment.

Key Responsibilities

• Design, develop, and maintain Oracle database objects (Procedures, Functions, Packages, Triggers).
• Analyze requirements and perform DB & application impact analysis.
• Build and optimize complex SQL queries and performance tuning.
• Develop backend services using ASP.NET Web API (C#).
• Design and implement ETL pipelines using Informatica & Oracle Scheduler.
• Support end-to-end SDLC (design → development → testing → deployment → support).
• Collaborate with QA, Dev, and Infra teams in Agile delivery.
• Handle production issues, deployments, and stabilization support.
• Maintain documentation (HLD, LLD, Test Cases).
• Perform code reviews and GitHub-based version control.

Required Skills & Experience

• 8+ years experience in Oracle PL/SQL & database development.
• Strong knowledge of Oracle 19 (SQL, Packages, Views, Triggers, performance tuning).
• Hands‑on experience with ASP.NET Web API, C#, .NET Framework.
• Experience in ETL tools (Informatica) & scheduling (Oracle Scheduler).
• Good understanding of financial/accounting systems.
• Experience working in Agile environments & full SDLC.
• Strong debugging, problem‑solving, and communication skills.

Good to Have

• Experience in investment accounting systems.
• Certifications (Oracle / Microsoft).
• Experience with AI‑assisted coding tools (Copilot).