Type-safe i18n for Drizzle ORM — translation tables and JSON columns for PostgreSQL, MySQL, and SQLite.
postgresql
mysql
sqlite
internationalization
orm
About Hisham Medhat
root@hisham:~$ glow about_me.md
about_me.md
HM
Hisham Medhat — AI Fullstack Engineer
AI fullstack engineer. Laravel, NestJS, Hono, Django, FastAPI, and the infrastructure underneath them.
Alexandria, Egypt · B.Sc. Computers and Data Science, 3.6 GPA
Available for software engineering roles · Alexandria or Cairo, on-site or hybrid · remote
## uptime
3 years shipping systems
## scale
200,000+ users, 15+ services
## ci
−75% build and deploy time
## tests
500+ integration tests, TDD
Skills: Laravel, NestJS, Hono, Django, FastAPI and the infrastructure underneath
root@hisham:~$ cat skills.txt
languages
Python
Java
PHP
Go
JavaScript
frameworks
Laravel
NestJS
FastAPI
React
Vue
Tailwind
jQuery
GraphQL
infra & cloud
AWS
GCP
Azure
Hetzner
Docker
CI/CD
Git
data & observability
PostgreSQL
MySQL
MongoDB
Redis
Grafana
Loki
Backend engineering experience
root@hisham:~$ git log --experience
- ▸Built a Hono/Bun observability platform ingesting telemetry from 15+ production services with real-time Slack alerts, request enrichment, and product-level analytics.
- ▸Architected enterprise metaverse backends using NestJS, Prisma, and PostgreSQL, supporting SAML SSO, multiplayer sessions, mini-games, Stripe billing, and E2E testing.
- ▸Integrated Sharjah Municipality property systems through NestJS SOAP/XML middleware with UAE Pass authentication for citizen services.
- ▸Delivered the Zayed University Metaverse platform with SAML SSO, interactive learning workflows, and automated test coverage.
- ▸Shipped supporting backend services including a widget API, GeoIP URL shortener, and session management APIs using Hono/Bun and Drizzle ORM.
- ▸Reduced monthly cloud costs by 80% across AWS, Azure, and Railway while deploying Umami analytics across company websites.
- ▸Standardized backend delivery practices with PR workflows, code reviews, GitHub Actions CI/CD, and automated testing across projects.
- ▸Architected a multi-tenant Laravel SaaS backend with Spatie Teams, request-scoped guards, and repository-level filters for strict tenant data isolation.
- ▸Provisioned production infrastructure on Hetzner using FrankenPHP, Laravel Octane, PostgreSQL, Redis, Supervisor, and Cloudflare Origin TLS.
- ▸Automated GitHub Actions CI/CD with Tailscale SSH, zero-downtime Octane reloads, and post-deployment health checks.
- ▸Delivered core SaaS modules including profiles, class scheduling, subscriptions, RBAC, dashboards, reports, and in-app notifications.
- ▸Collaborated with frontend engineers to define API contracts and OpenAPI documentation across tenant-facing workflows.
- ▸Maintained and refactored a Laravel MVC-based LMS platform serving 200,000+ users, improving scalability, maintainability, and legacy code quality.
- ▸Optimized critical database paths by eliminating redundant queries and improving data access patterns, significantly reducing per-request load.
- ▸Reduced CI build and deployment time by 75% through pipeline optimization, faster feedback loops, and improved release reliability.
- ▸Led development of AIAT, a full-stack AI course-generation platform using React, FastAPI, Django, and MongoDB.
- ▸Architected Docker-based infrastructure and observability tooling using Grafana, Loki, logging, monitoring, and alerting across development, staging, and production environments.
- ▸Designed an automated overtime engine with configurable rates, intervals, rounding rules, completed work-hour calculations, and customizable limits.
- ▸Built smart attendance policies that automatically penalize tardiness, no-shows, missed sign-outs, early departures, and absences based on configurable rules.
- ▸Developed leave adjustment workflows enabling administrators to modify employee leave balances with full audit tracking.
- ▸Optimized SQL queries and database indexing in the internal CRM, doubling query throughput and reducing page load times across reporting workflows.
- ▸Wrote 500+ PHPUnit integration tests covering attendance, overtime, leave, and penalty workflows, improving regression detection before deployment.
- ▸Delivered Laravel and MySQL backend features with GraphQL APIs and Sentry monitoring, supporting 10,000+ active users.
Sint
Backend Engineer, Part-time
Feb 2024 – Sep 2024 · Alexandria, Egypt
- ▸Developed Sint’s AI recruiting platform using Laravel, Domain-Driven Design, and Test-Driven Development practices.
- ▸Integrated OpenAI APIs to power AI-driven recruiting workflows, candidate evaluation features, and automated report generation.
- ▸Designed and optimized MySQL schemas for data-intensive recruiting workflows, improving query performance and platform reliability.
Education
root@hisham:~$ cat education.txt
Bachelor of Computers and Data Science
3.6 GPA
Alexandria University
Oct 2020 – Jun 2024
Open source projects
Writing on backend systems and infrastructure
2026-09
my dev setup, 2026
read →
2026-09
a flexible schema moves the work, it does not remove it
read →
2026-09
The bottleneck moved to code review
read →
2026-09
your agent remembers things that stopped being true
read →
2026-09
trust proxy was lying to my rate limiter
read →
2026-08
Multi-tenant Laravel: request-scoped guards over trusting your queries
read →
2026-08
Building an observability platform on Hono and Bun
read →
2026-08
500 integration tests later: what regression coverage actually caught
read →
Contact Hisham Medhat
root@hisham:~$ ./contact.sh
root@hisham:~$