Software Engineer with 3+ years of hands-on experience designing and developing Oracle-based enterprise applications using Oracle APEX, Oracle Database, SQL, and PL/SQL. Recognized as an Oracle ACE Associate and holder of 7 Oracle certifications.
Experienced in database architecture, multi-tenant SaaS systems, RESTful services, Docker-based deployment, DevOps automation, reporting, system integration, performance tuning, and AI-powered applications.
| Achievement | Details |
|---|---|
| 🏥 Medical Center System | Architected a multi-tenant healthcare platform with 180+ APEX screens, 171+ tables, 91 views, and 100+ PL/SQL packages |
| ⚡ Performance Optimization | Delivered 40% efficiency improvements through advanced SQL/PL/SQL tuning |
| ☁️ Cloud & AI Integration | Hands-on experience with OCI, Autonomous Database, Oracle 26ai, AI Vector Search, and RAG workflows |
| 🔐 Security Architecture | Implemented RBAC, custom authentication, MFA/OTP, password hashing (DBMS_CRYPTO), and audit controls |
| 🚀 DevOps Automation | Liquibase-driven database DevOps, Docker containerization, and CI/CD pipeline automation |
| 📱 Mobile Integration | Developed 20+ ORDS REST APIs with OAuth2 security and integrated them with a Flutter mobile application |
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, TwilioA Docker-based, multi-tenant enterprise platform built around Oracle Database 26ai, ORDS, and Oracle APEX.
| Metric | Count |
|---|---|
| 🖥️ APEX Screens | 180+ |
| 📋 Tables | 171+ |
| 👁️ Views | 91 |
| 📦 PL/SQL Packages | 100+ |
| 🔗 ORDS REST APIs | 20+ |
| ⚡ Triggers | 174 |
| 🔍 Indexes | 413 |
- Multi-Tenancy: Isolated tenant data model with centralized administration and secure separation between tenants.
- Deployment Architecture: 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.
| Module | Purpose |
|---|---|
| 🏥 Patient & Medical Records | Demographics, diagnoses, treatments, billing, insurance |
| 📅 Appointments & Booking | Scheduling, room management, service cataloging |
| 👥 Employees & HR | Staff info, 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 |
| Certification | 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 DB Cloud Certified Professional | 2025 |
| 🎖️ Oracle MySQL HeatWave Implementation Associate | 2025 |
| 🎖️ Oracle Cloud Infrastructure Foundations Associate | 2025 |
| 🎖️ Oracle Cloud Infrastructure 2025 AI Foundations Associate | 2025 |
⭐ From Malek Al-Edresi — Building enterprise-grade Oracle solutions