Oracle SME

Kumaran; Chennai; On-site; INR 3,500,000 - 6,000,000; Full time

Job summary

Kumaran Systems is seeking an experienced Oracle Forms & Database SME to support analysis, reverse engineering, and migration of legacy Oracle Forms applications to modern Python/Django web applications.

Responsibilities include analyzing forms, reviewing PL/SQL, mapping dependencies, and ensuring data integrity during migration while collaborating with cross-functional teams. 12+ years experience preferred.

Qualifications

• Strong hands-on experience with Oracle Forms 4.5/6i/10g/11g/12c.
• Expertise in Oracle Database, SQL, and PL/SQL.
• Experience with migration from legacy Oracle Forms to Python/Django.
• Ability to document functionality and technical dependencies.

Responsibilities

• Analyze existing Oracle Forms applications, triggers, workflows and embedded logic.
• Review PL/SQL packages, procedures, functions, triggers and SQL queries.
• Identify dependencies between Forms modules, database objects and interfaces.
• Document current functionality, business rules and dependencies.
• Support mapping of legacy functionality to Python/Django applications.
• Collaborate with business analysts, architects, developers and QA teams.
• Validate data integrity and parity during migration.
• Troubleshoot complex application and database issues.

Tools

Python

Django

Oracle DB

SQL

PL/SQL

Oracle Reports

Job description

Kumaran Systems: Engineering Future-Ready Transformations Since 1992, Kumaran Systems has been helping enterprises bridge the past and the future, reimagining legacy systems and embracing AI-led possibilities. With over 34 years of delivery excellence, we specialise in re-engineering core applications, driving cloud transformation, and building automation-first, GenAI-enabled ecosystems across the Banking and Financial Services, Insurance, Telecom, and Automotive sectors. We help organisations not just upgrade their systems but reimagine what's possible.

Why Kumaran?

We blend engineering discipline with AI innovation, helping clients modernise with confidence, automate with clarity, and scale with purpose. Our global delivery model ensures agility, responsiveness, and seamless collaboration, with clients always at the heart of every engagement. At Kumaran, we don't just solve problems, we engineer future-ready transformations.

Job Description

Experience: 12+ years

Job Description:

We are looking for an experienced Oracle Forms & Database SME to support the analysis, reverse engineering, and migration of legacy Oracle Forms applications to modern Python/Django web applications.

Key Responsibilities:

• Analyze existing Oracle Forms applications, triggers, workflows, and embedded business logic.
• Review PL/SQL packages, procedures, functions, database triggers, and SQL queries.
• Identify dependencies between Forms modules, database objects, reports, and external interfaces.
• Document existing application functionality, business rules, and technical dependencies.
• Support mapping and migration of legacy functionality to Python/Django applications.
• Collaborate with business analysts, architects, developers, and QA teams.
• Validate database operations, data integrity, and functional parity during migration.
• Troubleshoot complex application and database issues.

Required Skills:

• Strong hands-on experience with Oracle Forms 4.5/6i/10g/11g/12c.
• Expertise in Oracle Database, SQL, and PL/SQL.
• Good understanding of Forms triggers, LOVs, record groups, canvases, and data blocks.
• Experience with Oracle Reports, stored procedures, packages, and database performance tuning.
• Strong skills in legacy application analysis, reverse engineering, and technical documentation.
• Ability to work closely with Python/Django development teams.

Preferred:

• Experience in Oracle Forms modernization or migration projects.
• Experience in enterprise application transformation and data migration.

Kumaran Systems is an Equal Opportunity Employer and does not discriminate on the basis of race or ethnicity, religion, sex, national origin, age, veteran disability or genetic information or any other reason prohibited by law in employment.