Malek M. Al-Edresi malek-al-edresi

Malek Mohammed Al-Edresi

Software Engineer · Oracle ACE Associate ♠

About Impact Expertise Project Certifications Activity Contact

About

Software Engineer with 3+ years of hands-on experience designing and delivering Oracle-based enterprise applications with Oracle APEX, Oracle Database, SQL, and PL/SQL. Recognized as an Oracle ACE Associate and holder of 7 Oracle certifications.

Experienced across database architecture, multi-tenant SaaS systems, RESTful services, Docker-based deployment, DevOps automation, reporting, system integration, performance tuning, and AI-powered applications.

Selected Impact

Area	Outcome
Healthcare SaaS	Architected a multi-tenant medical center system with 180+ APEX screens, 171+ tables, 91 views, and 100+ PL/SQL packages
Performance	Delivered 40% efficiency improvements through advanced SQL and PL/SQL tuning
Cloud & AI	Hands-on with OCI, Autonomous Database, Oracle 26ai, AI Vector Search, and RAG workflows
Security	Implemented RBAC, custom authentication, MFA/OTP, password hashing (DBMS_CRYPTO), and audit controls
DevOps	Liquibase-driven database DevOps, Docker containerization, and CI/CD pipeline automation
Mobile & APIs	Built 20+ ORDS REST APIs secured with OAuth2 and integrated them with a Flutter mobile application

Technical Expertise

Domain	Stack
Database
Application
APIs & Integration
Cloud & DevOps
AI & Reporting

Detailed competencies _{click to expand}

Area	Capabilities
Oracle Database & PL/SQL	Oracle 21c / 26ai, Autonomous Database · Advanced PL/SQL (packages, triggers, materialized views) · Query tuning, partitioning, data modeling · Schema design & multi-tenant architecture
Oracle APEX & Front-End	APEX 24.x / 26.x, Dynamic Actions, Interactive Grids · Custom plugins, HTML5, CSS3, JavaScript · RTL support, PWA, UI/UX optimization
Architecture & Integration	Multi-tenant SaaS architecture · ORDS REST APIs, OAuth2, JSON · APEX_WEB_SERVICE, REST integration · Schema isolation & dynamic tenant routing
Cloud, DevOps & CI/CD	OCI, Docker, Docker Compose · Liquibase, Git, Linux, Nginx reverse proxy · Makefile, DBMS_DATAPUMP, deployment automation
Reporting & Analytics	JasperReports Server, dashboards · Materialized views, data processing
AI & Tools	Oracle AI Vector Search, RAG, embeddings · LLM integration (Ollama), Python · SQL Developer, Postman, OpenWA, Twilio

Featured Project

Oracle APEX Medical Center System

A Docker-based, multi-tenant enterprise healthcare platform built on Oracle Database 26ai, ORDS, and Oracle APEX.

Architecture _{click to collapse}

flowchart TB
    clients["Web & Mobile Clients"]
    edge["Secure Reverse Proxy"]
    devops["Database DevOps<br/>Versioned Releases"]

    subgraph app["Application Layer"]
        apex["Oracle APEX"]
        ords["ORDS · REST / OAuth2"]
        reports["Reporting Services"]
    end

    subgraph data["Data Layer"]
        admin["Central Administration"]
        tenants[("Oracle Database 26ai<br/>Isolated Tenant Data")]
        ai["AI Vector Search"]
    end

    clients --> edge
    edge --> apex & ords & reports
    apex & ords & reports --> tenants
    apex ~~~ admin
    reports ~~~ ai
    devops -.-> admin

    classDef base fill:#24292F,stroke:#24292F,color:#FFFFFF
    classDef oracle fill:#C74634,stroke:#C74634,color:#FFFFFF
    class clients,edge,devops,reports,admin base
    class apex,ords,tenants,ai oracle
    style app fill:none,stroke:#8B949E,stroke-dasharray:4 4
    style data fill:none,stroke:#8B949E,stroke-dasharray:4 4

_{Hover over the diagram to zoom, pan, or open it full screen.}

Pillar	Approach
Multi-Tenancy	Isolated tenant data model with centralized administration and secure separation between tenants
Deployment	Layered application, data, and reporting services behind a secure edge / reverse proxy
AI Integration	AI-powered semantic search and retrieval workflows for intelligent data access
DevOps Pipeline	Automated database change management, versioned releases, and controlled tenant deployments
Security	Strong tenant isolation, authentication and access controls, and comprehensive audit logging

Platform Modules _{click to collapse}

Patient & Medical Records _{Demographics, diagnoses, treatments, billing, insurance}	Appointments & Booking _{Scheduling, room management, service cataloging}	Employees & HR _{Staff information, doctor schedules, departments}
Laboratory _{Lab tests, specimen tracking, test results}	Radiology _{Imaging reports, screening devices}	Pharmacy _{Drug cataloging, interactions, dosages}
Store & Inventory _{Stock management, supplier invoices}	Accounting _{Ledger mapping, expenses, AR/AP, financial KPIs}	AI / RAG System _{Document embeddings, vector chunks, AI assistants}

_{Back to top ↑}

Certifications

Credential	Level	Year
Oracle Database PL/SQL Developer Certified Professional		2026
Oracle APEX Cloud Developer Certified Professional		2025
Oracle AI Vector Search Certified Professional		2025
Oracle Autonomous Database Cloud Certified Professional		2025
Oracle MySQL HeatWave Implementation Associate		2025
Oracle Cloud Infrastructure Foundations Associate		2025
Oracle Cloud Infrastructure 2025 AI Foundations Associate		2025

GitHub Activity

Contact

_{Building enterprise-grade Oracle solutions · · Back to top ↑}

Navigation Menu