Oracle Apex Developer

Jaffer Business Systems (Private) Limited; Karachi Division; On-site; PKR 1,800,000 - 3,000,000; Full time

Job summary

Jaffer Business Systems (JBS) is seeking an experienced Oracle APEX Developer to design, develop, maintain, and enhance enterprise applications using Oracle APEX, SQL, and PL/SQL. The role requires on-site engagement at the client's location for a 1-year period in Pakistan.

You will work within JBS Consulting, collaborating with stakeholders to deliver robust solutions, secure by design, and integrated with external systems via REST/SOAP.

Qualifications

• Proven experience with Oracle APEX development and Oracle database programming.
• Strong SQL/PLSQL skills and ability to design scalable schemas.
• Experience integrating APEX apps with REST/SOAP services and external systems.

Responsibilities

• Design, develop, and maintain Oracle APEX applications and reports.
• Develop PL/SQL packages, procedures, functions, and triggers with proper error handling.
• Write complex SQL, optimize queries, and ensure data integrity.
• Integrate APEX apps with external systems using SOAP/REST web services.
• Implement APEX security, authentication, authorization, and session management.
• Create PDF/Excel outputs via BI Publisher or APEX reporting features.
• Troubleshoot and resolve issues to ensure performance and stability.
• Collaborate with clients and stakeholders to capture requirements and deliver enhancements.
• Work independently onsite at the client for the full one-year engagement.

Skills

Oracle APEX

SQL

PL/SQL

Oracle DB design

REST/SOAP integration

BI Publisher reports

Security & session management

Client-facing

Debugging & troubleshooting

Education

Bachelor's degree in Computer Science / IT / Software Engineering

Tools

ORDS

Oracle Forms & Reports

Agile/Scrum

Job description

Jaffer Business Systems (JBS), founded in 1982 as a division of Jaffer Brothers, has been at the forefront of technology solutions for over four decades. Today, JBS stands as one of Pakistan’s leading IT companies, empowering organizations through innovation, digital transformation, and people-centric technology. Guided by our vision of “Harnessing Innovation & Empowering Generations,” JBS delivers comprehensive solutions spanning IT infrastructure, enterprise software, advanced applications, and consulting services that drive business growth and efficiency. JBS includes a diverse portfolio of subsidiaries, including Hysab Kytab, Energy & Automation Pakistan, Blutech Consulting, and Imparé. Through its specialized business units, JBS continues to deliver value across regions and industries. At JBS, we believe in creating impact through technology, collaboration, and continuous learning to drive progress for our clients, our people, and the communities we serve.

Role Overview

We are looking for an experienced Oracle APEX Developer to design, develop, maintain, and enhance enterprise applications using Oracle Application Express (APEX), SQL, and PL/SQL. The ideal candidate will have strong application development and integration skills, a solid understanding of Oracle databases, and the ability to work independently in a client-facing environment. This role requires full-time onsite engagement at the client's location for a period of one year.

Business Unit/Department

JBS Consulting

Mode

Onsite

Type

Full-time

Job Responsibilities

• Design, develop, and maintain Oracle APEX applications, including interactive reports, interactive grids, forms, dynamic actions, and automated workflows.
• Develop and maintain PL/SQL packages, procedures, functions, triggers, cursors, and collections, implementing effective exception handling.
• Write, optimize, and troubleshoot complex SQL queries using joins, analytical functions, and performance‑tuning techniques.
• Apply Oracle database fundamentals, including schema design, indexing, constraints, and data integrity management.
• Integrate APEX applications with external systems through SOAP and REST web services, supporting seamless data exchange with insurance, banking, ERP, and other enterprise systems.
• Implement APEX security measures, including authentication schemes, authorization controls, and session state management.
• Develop and maintain reports and document outputs in PDF and Excel formats using BI Publisher or Oracle APEX native printing capabilities.
• Troubleshoot application issues, perform debugging, and resolve technical problems to ensure application stability and performance.
• Collaborate directly with clients and relevant stakeholders to understand requirements, provide technical solutions, and deliver application enhancements.
• Work independently with minimal supervision while ensuring timely delivery and adherence to client requirements.

Skills & Knowledge

• Hands‑on experience developing and maintaining applications using Oracle APEX.
• Strong proficiency in SQL and PL/SQL programming.
• Experience with Oracle database design, schema management, indexing, and performance optimization.
• Practical experience integrating applications with external systems using SOAP and REST APIs.
• Knowledge of Oracle APEX security, authentication, authorization, and session management.
• Experience generating PDF and Excel reports using BI Publisher or native APEX reporting features.
• Strong debugging, analytical, and problem‑solving skills.
• Excellent communication and stakeholder‑management skills for client‑facing engagements.
• Ability to work independently and effectively in an onsite client environment.

Qualifications & Experience

• Bachelor's degree in Computer Science, Software Engineering, Information Technology, or a related field.
• 3–5 years of relevant experience in Oracle APEX application development and Oracle database programming.
• Willingness to work full-time onsite at the client's location for the entire one‑year engagement.
• Strong communication skills and the ability to interact directly with clients.
• Ability to manage assigned tasks independently with minimal supervision.

Preferred Qualifications:

• Experience in insurance, banking, or financial services.
• Familiarity with Oracle Forms and Reports, particularly in legacy enterprise environments.
• Exposure to Oracle REST Data Services (ORDS).
• Experience working in Agile/Scrum development environments.