Oracle Apex Developer

Role overview

We are seeking a highly skilled Oracle APEX developer to design, develop, and maintain enterprise-grade applications supporting quality, health, safety, and environment (QHSE) and QSMA business processes.

The candidate will work closely with business stakeholders to translate complex operational workflows—such as audits, risk management, incident tracking, and compliance—into scalable, secure, and high-performance Oracle APEX solutions.

Key responsibilities

1. Application development & design
Develop and maintain applications using Oracle APEX, PL/SQL, and Oracle Database
Design data models, workflows, and UI components aligned with QHSE requirements
Build dynamic forms, dashboards, and reports for enterprise-wide usage
Implement reusable components and ensure coding best practices

2. Workflow & process automation
Design and implement configurable workflow systems for:

• Audit approvals and planning
• Non-Conformity (NCR) lifecycle management
• Change management processes
• Permit to Work (PTW)

Automate notifications, escalations, and approval hierarchies

3. QHSE business process implementation
The developer must have working knowledge of at least one or more of the following domains:

Core modules

• Audit management & compliance tracking
• Non-Conformity management (NCR lifecycle, RCA, CAPA)
• Incident management systems
• Risk & opportunity management (risk scoring, mitigation tracking)
• Change management (impact analysis, approvals, execution tracking)

Operational & HSE modules

• Permit to Work systems
• HSE inspections & emergency drill management
• Energy conservation & environmental reporting
• Legal register & compliance monitoring

Enterprise & analytics

• KPI, SPI, and QHSE objectives tracking
• Enterprise dashboards & analytics
• Customer perception & survey management
• Document management systems (version control, approvals)

4. Reporting & analytics
Develop interactive dashboards and reports for:

• Audits, NCRs, incidents, and risks
• Compliance tracking and KPIs

Enable self-service reporting capabilities for business users
Integrate APEX with BI tools if required

5. Data management & integration
Design and manage complex data models for enterprise applications
Implement data integration (manual & automated) with external systems
Ensure data accuracy, consistency, and audit trails

6. Document & content management
Develop centralized document repositories with:

• Version control
• Approval workflows
• Access control mechanisms

7. System performance & security
Optimize SQL queries and PL/SQL code for performance
Implement role-based access control and security policies
Ensure compliance with enterprise IT and regulatory standards

8. Testing & support
Perform unit testing, system testing, and UAT support
Provide L2/L3 support for deployed applications
Troubleshoot and resolve production issues

Required skills & qualifications

Technical skills
Strong experience in Oracle APEX (latest versions preferred)
Proficiency in:

• PL/SQL
• SQL performance tuning
• Oracle Database architecture

Experience with:

• REST APIs / Web Services integration
• JavaScript, HTML, CSS (for APEX UI customization)

Knowledge of workflow engines and approval systems

Domain knowledge (mandatory – any one or more)

• QHSE / EHS systems
• ISO standards:
  • ISO 9001 (Quality)
  • ISO 14001 (Environment)
  • ISO 45001 (Occupational Health & Safety)
• Audit & compliance systems
• Risk management frameworks
• Aviation / regulatory exposure (e.g., GCAA CAR Part 10) – preferred

Experience
4–10 years of experience in Oracle development
Minimum 2+ years in Oracle APEX development
Experience in enterprise workflow-based applications

Soft skills
Strong analytical and problem-solving skills
Ability to understand complex business processes
Effective stakeholder communication
Documentation and process mapping skills

Preferred qualifications
Oracle APEX certification
Experience in QHSE or enterprise compliance platforms
Exposure to Agile / Scrum methodologies

Key deliverables

• Fully functional QHSE modules within Oracle APEX
• Automated workflow-driven enterprise applications
• Real-time dashboards and analytics
• Scalable and maintainable system architecture