Job Summary: We are seeking Full Stack Developers with strong technical judgment and a quality-oriented mindset to develop and maintain a production system. Key Highlights: 1. Angular module development and maintenance. 2. Design and optimization of complex SQL queries. 3. Operational task automation using scripts. We are looking for a **PHP/Angular Fullstack Developer** to join our team! Location: Mexico (preference for Guadalajara, Jalisco) Work Mode: Remote / Hybrid (if residing in GDL) Employment Type: Full-time Start Date: Immediate **Job Objective** We seek 2 Full Stack Developers to support the development and evolution of a production system comprising: * Frontend: Angular * Backend: PHP Symfony * Database: MySQL (advanced SQL) * Automations and reporting: PHP / Python scripts Priority is given to programmers with strong technical judgment, ability to work with existing systems, and a quality-focused approach. **Responsibilities** * Angular module development and maintenance (components, services, state management, UX). * Development of endpoints and business logic in Symfony (APIs, controllers, services, entities, validations). * Design and optimization of complex SQL queries (joins, subqueries, indexes, performance). * Automation of operational tasks and report generation using PHP / Python scripts. * Integration with external APIs, webhooks, and third-party services. * Corrective and preventive maintenance, debugging, and performance improvement. * Team collaboration using Git practices, code reviews, and task tracking. **Essential Requirements** **Frontend** * Angular (ideally v12+) with proven experience in large-scale projects * TypeScript, RxJS * REST API consumption * Reactive form handling * Best practices: reusable components, performance, lazy loading (plus) **Backend** * PHP 8+ * Symfony (ideally v4.4+) * Doctrine ORM (or solid experience with query builders) * Service-oriented architecture, validations, DTOs (desirable) **SQL (very important)** * MySQL / MariaDB * Demonstrated expertise in: * Complex joins * Subqueries * GROUP BY / HAVING * Query optimization * Indexes / EXPLAIN / performance tuning **Automation / Scripting** * Script development for: * Data processing * Report generation * System integration * Operational process automation * (Preferred) Python experience: pandas / openpyxl / reporting, etc. **Desirable Requirements** * Linux server basics (SSH, logs, permissions) * AWS experience (EC2, RDS, Elastic Beanstalk, S3) * WebSocket experience (Node or PHP) * Docker knowledge * Experience with CRM/ERP systems, inventory, logistics, or shipment workflows Employment Type: Full-time, Indefinite-term contract Salary: $30,000.00 – $40,000.00 per month Benefits: * Salary increases Application Question(s): * Do you have a portfolio you can share with us? Experience: * Software development: 5 years (Mandatory) Workplace: Remote job