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
JoeyIsNotRobot
Backend Software Engineer · PHP & Laravel
- in/hectorcoel
- Brazil
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> 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 setCareer
My journey
2022 — today
2022
Internship at a software house: PHP and Laravel, SQL queries, bug fixing, and documentation. Started Systems Analysis and Development at UNOPAR.
2023
Hired as a Back-End Engineer. Completed Systems Analysis and Development (UNOPAR).
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.
2025
Backend Software Engineer (Mid-Level) at a fitness consulting SaaS platform, as the primary engineer behind the API and web system.
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.