Senior Oracle Forms & Reports Developer

About the Role :

We are seeking an experienced Oracle Forms & APEX Developer to design, develop, support, and maintain high-performance Oracle-based business applications. The ideal candidate will have strong expertise in Oracle Forms, Reports, Oracle APEX, and PL/SQL development, with a proven ability to build scalable, secure, and user-friendly applications while providing production support in a 24/7 operational environment.

Key Responsibilities :

- Design, develop, and maintain applications using Oracle Forms and Reports (Developer 12c/19c).

- Develop and optimize PL/SQL procedures, packages, functions, and queries.

- Create and maintain complex reports using Oracle Reports.

- Develop modern web applications using Oracle APEX (22.x or higher).

- Build interactive dashboards, reports, charts, and grids.

- Perform database development activities including creation of tables, views, indexes, triggers, and other database objects.

- Enhance existing applications for performance, scalability, and usability improvements.

- Troubleshoot production issues and provide ongoing application support.

- Monitor and optimize Oracle database and application performance.

- Participate in application deployment and migration across Development, Test, and Production environments.

- Collaborate with business stakeholders to gather requirements and deliver effective technical solutions.

- Prepare technical documentation, design specifications, and user manuals.

- Support mission-critical plant systems operating in a 24x7 environment.

Required Qualifications :

- Bachelor's Degree in Computer Science, Information Technology, or related field.

- Minimum 5+ years of hands-on experience in Oracle Forms, Reports, PL/SQL, and Oracle APEX development.

- Oracle PL/SQL Developer Certification is preferred.

Technical Skills :

- Oracle Developer Forms & Reports 12c / 19c

- Oracle Database 12c / 19c

- Strong SQL and PL/SQL programming skills

- Oracle APEX (22.x or above)

- Oracle Database Architecture knowledge

- XML Programming

- SQL/PLSQL Performance Tuning

- Debugging and Troubleshooting

- Unix/Linux Shell Scripting

Preferred Skills :

- Oracle Forms Migration (Developer 2000, 6i, 10g, 11g, 12c, 19c)

- Pro-C Programming

- JavaScript, jQuery, HTML, CSS

- REST APIs and JSON Integration

- Oracle Analytics / OBIEE

- Power BI

- Microsoft Azure

- Python or R

- Responsive Design and Theme Roller Customization

Soft Skills :

- Strong analytical and problem-solving abilities

- Excellent communication and stakeholder management skills

- Ability to work independently and collaboratively

- Strong documentation and technical writing skills

- Ability to perform effectively in high-pressure production environments

Project Experience :

- Successful development of Oracle Forms & Reports-based applications.

- Oracle APEX application development and deployment.

- Optimization of SQL and PL/SQL code for high-volume transactional systems.

- Migration of legacy Oracle Forms applications from Developer 2000/6i/10g/11g to newer versions.

- Root Cause Analysis (RCA) and resolution of production issues.

- Performance tuning of Oracle databases and enterprise applications.

Skills

Oracle Forms, PL-SQL, Oracle APEX, Oracle Reports, Oracle Implementation, Oracle Support, Apex