Senior Technology Consultant - Oracle Developer

The Oracle Forms & 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 .

Key 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 & 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 & 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 & 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 & 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 & Experience

Educational Background:

•Minimum a Bachelor’s Degree in Computer Science, Information Technology, Software Engineering, or a related field; or an equivalent professional qualification.

•Professional Experience:

•Minimum of 5 years of post-qualification experience in software development or maintenance.
•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.