Job Summary
The Oracle Forms-Reports Developer will be responsible for designing, developing, maintaining, and enhancing enterprise-level applications using Oracle Forms and Reports, in conjunction with Oracle RDBMS and PL/SQL. This role involves working closely with cross-functional teams to deliver robust, scalable, and secure software solutions that align with business requirements and industry’s best practices.
Roles and Responsibilities
1. Application Development
• Develop and maintain custom applications using Oracle Forms and Reports (versions 6i to 12c).
• Write efficient and maintainable PL/SQL code for triggers, stored procedures, functions, and packages.
• Design and implement database objects such as tables, views, indexes, sequences, and constraints within Oracle RDBMS.
• Translate business requirements into technical specifications and functional application modules
2. System Maintenance and Enhancement
• Perform bug fixing, performance tuning, and troubleshooting of existing Oracle Forms-based applications.
• Upgrade legacy forms and reports from older versions (e.g., 6i) to newer ones (e.g., 10g, 11g, 12c).
• Ensure compatibility and integration with other systems (e.g., Java, Web Services, REST APIs).
3. Database Design and Optimization
• Collaborate with DBAs and architects to design and optimize database schemas.
• Implement best practices for data integrity, security, indexing, and query optimization.
• Monitor and resolve database performance issues affecting Forms and Reports.
4. Project Lifecycle
• Participation Participate in all phases of the Software Development Life Cycle (SDLC) including requirement gathering, system design, development, testing, deployment, and post-implementation support.
• Conduct peer reviews and participate in design and code walkthroughs.
• Prepare and maintain technical documentation including design documents, user manuals, and change logs.
5. Quality Assurance and Compliance
• Ensure adherence to ISO quality standards during software development and maintenance.
• Follow established coding standards, version control practices, and change management procedures.
• Participate in internal audits and contribute to continuous improvement initiatives.
6. Collaboration and Communication
• Work closely with project managers, business analysts, QA testers, and end- users to ensure alignment between technical solutions and business needs.
• Provide technical guidance and mentoring to junior developers when applicable.
• Communicate progress, risks, and deliverables effectively through status reports and team meetings.
Qualifications & Professional Experience
• Minimum a Bachelor’s Degree in Computer Science, Information Technology, Software Engineering, or a related field; or an equivalent professional qualification.
• Minimum of 11 years of post-qualification relevant experience
• Proven hands-on experience with Oracle Forms and Reports (versions 6i to 12c) .
• Strong expertise in Oracle PL/SQL and RDBMS concepts including database design, normalization, and performance tuning.
• Familiarity with Oracle Application Server (OAS) or Oracle Fusion Middleware for deployment and configuration of Forms applications.
Technical Skills Required
• In-depth knowledge of Oracle Forms Builder, Reports Builder, and associated tools.
• Ability to develop and debug complex forms with multiple canvases, windows, and triggers.
• Proficiency in creating parameterized reports, matrix reports, and drill-down reports using Oracle Reports.
• Experience with integrating Oracle Forms with external applications via WebUtil, JavaBeans, or Web Services.
• Good understanding of project life cycle methodologies (Waterfall, Agile, etc.).
• Awareness of quality assurance procedures under ISO standards (e.g., ISO 9001).
Professional Skills
• Excellent problem-solving skills and attention to detail.
• Strong written and verbal communication abilities.
• Ability to work independently or within a team in a dynamic environment.
Preferred Skills
• Exposure to Oracle APEX as a modern alternative for legacy Forms migration.
• Experience in migrating Oracle Forms to web-based technologies.
• Knowledge of UNIX/Linux environments and shell scripting.
• Certification in Oracle PL/SQL or Oracle Forms (e.g., Oracle Certified Associate or Oracle Certified Professional).
