Full-Stack Developer PHP Laravel SQL

Full-Stack Developer (Php Laravel & Sql)

About The Role

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 And 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