Skip to content

GET/api/me200 OK · 18ms

Héctor Coelho, Backend Developer

APIs, databases & everything behind the screen.

I'm a backend engineer specializing in the PHP and Laravel ecosystem. I work on APIs, SaaS, SQL optimization, security, and legacy modernization — and I rely on software engineering fundamentals before reaching for any AI tool.

  • PHP
  • Laravel
  • PostgreSQL
  • MySQL
Héctor Coelho's GitHub profile (JoeyIsNotRobot)
9:41
Héctor Coelho's GitHub avatar

Héctor Coelho

JoeyIsNotRobot

Backend Software Engineer · PHP & Laravel

  • in/hectorcoel
  • Brazil
Follow

Highlights

  • −73%SQL latency
  • −94%search time
  • 4+years backend

About

From juice to black coffee

I started in March 2022 as an intern at a software house. I soon took on entire PHP and Laravel projects under technical supervision: writing and tuning SQL queries, fixing bugs, and documenting deliveries.

In 2023 I was hired as a Back-End Engineer and built an accounting system with electronic invoice issuing and management (NF-e and NFS-e) and financial workflows. It was the longest project I have worked on and the one that taught me the most.

Since February 2025 I have been the primary engineer behind the API and web system of a fitness consulting SaaS platform used by about 25,000 professionals and 198,000 end users. I take the business problem, investigate it, choose the approach, implement, test, and follow it in production. My focus is the application and its integrations.

I build with performance, availability, and security in mind. I bring what I study in cybersecurity into the code: resource-level authorization, input validation, rate limiting, and a critical review of everything that ships, including AI-generated code.

I also help early-career developers with what I wish I had heard in my first two years.

mysql — exemplo.sql
mysql> EXPLAIN SELECT id, status, criado_em
    ->   FROM pedidos
    ->  WHERE status = 'pago'
    ->  ORDER BY criado_em DESC
    ->  LIMIT 20\G
************ 1. row ************
           id: 1
  select_type: SIMPLE
        table: pedidos
         type: ref
possible_keys: idx_status_criado
          key: idx_status_criado
        Extra: Using where; Backward index scan
1 row in set
Illustrative example · fictional table, no real data

Career

My journey

2022 — today

  1. 2022

    Internship at a software house: PHP and Laravel, SQL queries, bug fixing, and documentation. Started Systems Analysis and Development at UNOPAR.

  2. 2023

    Hired as a Back-End Engineer. Completed Systems Analysis and Development (UNOPAR).

  3. 2023–2025

    Accounting system built from scratch: NF-e and NFS-e electronic invoices, financial workflows, and business rules. Supported environment setup with Docker and AWS.

  4. 2025

    Backend Software Engineer (Mid-Level) at a fitness consulting SaaS platform, as the primary engineer behind the API and web system.

  5. 2025–2026

    SQL query from 321 ms to 86 ms with a composite index (~202k rows) and search from 341 ms to 20 ms with MySQL FULLTEXT (~198k rows).

Focus areas

What I do

  • 01

    APIs & backend

    REST APIs for mobile apps and integrations: JSON contracts, validation, authentication, authorization, versioning, and error handling.

  • 02

    SQL performance

    Execution plans (EXPLAIN), composite indexes, MySQL FULLTEXT, caching, and eager loading against N+1.

  • 03

    Application security

    Resource-level authorization against IDOR, input validation, rate limiting, and XSS mitigation, based on the OWASP Top 10.

  • 04

    Legacy modernization

    Gradual refactoring of procedural PHP and Laravel code, with PHPUnit unit and integration tests.

By the numbers

Measured results

Production systems, measured before and after each change.

latency on a SQL query
−73%
321 ms → 86 ms · composite index · ~202k rows
response time on a search
−94%
341 ms → 20 ms · MySQL FULLTEXT · ~198k rows
end users on the SaaS I work on
198k
~25k professionals · API and web system
years in backend
4+
PHP and Laravel since March 2022

Stack

Technologies I use

Backend

  • PHP 8+
  • Laravel
  • Eloquent
  • Composer
  • Slim 4
  • Procedural PHP (legacy)
  • REST APIs
  • JSON contracts
  • Authentication & authorization
  • Mobile app integration

Complementary

  • JavaScript

Data & Performance

  • MySQL
  • MariaDB
  • SQL
  • EXPLAIN
  • Composite indexes
  • MySQL FULLTEXT
  • Eager loading / N+1
  • Caching

Complementary

  • PostgreSQL

Testing & Security

  • PHPUnit
  • Unit & integration tests
  • Legacy refactoring
  • OWASP Top 10
  • IDOR prevention
  • XSS mitigation
  • Rate limiting
  • Input validation

Tools

  • Git
  • Code review

Complementary

  • Docker (environments)
  • AWS (support)
  • ChatGPT & Claude Code (critical review)

Contact

Let's talk

To talk about backend, database performance, or application security, reach me by email or LinkedIn.

hectorcoelho@hotmail.com