Full-Stack Developer PHP Laravel SQL

About This Role

Full-Stack Developer (PHP Laravel & SQL)

PHP · Laravel · SQL · Linux · Server Management

About the Role

We're seeking a developer who owns the entire stack—from provisioning and hardening servers to building and deploying robust web applications. You’ll be the go-to person for our infrastructure, deployment pipeline, and backend/frontend integration, so expertise across the stack is essential.

What You'll Be DoingInfrastructure

• Provision, harden, and maintain dedicated or cloud servers on Hetzner or similar providers.

Web Development

• Build and optimize PHP Laravel applications, ensuring scalability, performance, and maintainability.
• Develop RESTful APIs and integrate frontend components (Blade, Livewire, or Inertia.js if applicable).

Database Management

• Design and optimize SQL database schemas (MySQL/PostgreSQL).
• Write efficient queries, optimize performance, and ensure data integrity.

Deployment & CI/CD

• Own the deployment pipeline using tools like GitHub Actions, GitLab CI, or Jenkins.
• Manage environment configurations for Nginx/Apache, PHP-FPM, and Supervisor.
• Containerize applications with Docker (if applicable).

Security & Uptime

• Maintain SSL certificates (Let’s Encrypt), manage backups, and monitor server health.
• Implement security best practices (firewalls, SSH hardening, etc.).

What We're Looking ForTechnical Skills

• Expert-level PHP and Laravel (including Eloquent, Blade, Queues, and API development).
• Solid SQL experience with MySQL or PostgreSQL (schema design, indexing, query optimization).
• Linux fundamentals: Ubuntu/Debian, Nginx/Apache, SSH, and CLI tools.
• Server management: Hands-on experience with Hetzner, AWS, or DigitalOcean.
• Bonus: Docker, Redis, automated backups, or CI/CD pipelines.

Problem-Solving

• Ability to diagnose and resolve performance bottlenecks in Laravel applications and SQL queries.
• Experience with caching strategies (Redis, Memcached) and scaling PHP applications.

Interview Questions Worth Asking1. Laravel & Server Setup

"Walk me through deploying a Laravel application on a fresh Ubuntu server on Hetzner."
Look for:

• SSH key setup and user permissions.
• Nginx/Apache configuration as a reverse proxy for PHP-FPM.
• Composer and PHP dependencies management.
• Supervisor for queue workers or Docker for containerization.
• Firewall (UFW) and security hardening.

2. SQL Performance

"How would you diagnose and fix a slow query in a high-traffic Laravel app?"
Look for:

• Use of EXPLAIN/ANALYZE in MySQL/PostgreSQL.
• Indexing strategies (composite indexes, covering indexes).
• Query restructuring (eager loading in Laravel, avoiding N+1 queries).
• Caching (Redis, database query caching).

3. Server Hardening

"How do you secure a Linux server for a Laravel production app?"
Look for:

• Disabling root SSH access, using SSH keys.
• Configuring UFW or iptables for firewall rules.
• Regular updates and patch management.
• Backup strategies (automated, offsite).

Job Type: Full-time

Pay: AED3,000.00 - AED4,000.00 per month

Work Location: In person