Oracle SME

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.
• 
  Oracle Jobs & Reports

Preferred:

• 
  Experience in Oracle Forms modernization or migration projects.
• 
  Experience in enterprise application transformation and data migration.
• 
  Pro c Knowledge
• 
  Shell Scripts