Oracle APEX Developer (QHSE / Enterprise Systems)

Share your love

Location :- Dubai, UAE
Email :- hr@staffconnect.ae
WhatsApp :- +971 52 942 1270

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:
    o Audit approvals and planning
    o Non-Conformity (NCR) lifecycle management
    o Change Management processes
    o 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:
    o Audits, NCRs, incidents, and risks
    o 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:
    o Version control
    o Approval workflows
    o 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:
    o PL/SQL
    o SQL performance tuning
    o Oracle Database architecture
  • Experience with:
    o REST APIs / Web Services integration
    o 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:
    o ISO 9001 (Quality)
    o ISO 14001 (Environment)
    o 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