Laravel Engineer with MySQL Tuning Experience

Overview Bluelight is a leading software consultancy dedicated to designing and developing innovative technology that enhances users\' lives. With a steadfast commitment to delivering exceptional service to our clients, Bluelight excels in its focus on quality and customer satisfaction. Our mission is not only to create cutting-edge applications but also to foster a collaborative and enriching work environment where each team member can grow and thrive. With a presence across the United States and Central/South America, Bluelight is in an exciting phase of expansion, continually seeking exceptional talent to join its dynamic and diverse community. We are looking for a skilled Laravel Engineer to join our rapidly growing team. This remote role (LATAM) is ideal for someone who thrives in a fast-paced environment where opinions and efforts are valued and appreciated. You will contribute to challenging and meaningful projects, developing high-quality applications that stand out in the market. We value continuous learning, personal growth, and hard work, offering a collaborative environment that promotes professional development. Responsibilities Responsibilities are aligned with building and maintaining Laravel-based applications, optimizing performance, and collaborating with clients and team members to deliver high-quality software solutions. (Note: specific day-to-day tasks are project-driven and may evolve with client needs.) Qualifications 4+ years of experience with Laravel, specifically Laravel 8 and above, demonstrating a deep understanding of the framework\'s architecture and capabilities. Expertise in MySQL database performance optimization, with a proven ability to identify and resolve complex database bottlenecks. Strong hands-on experience in writing, optimizing, and debugging complex SQL queries, especially for applications handling large and growing datasets. This includes a thorough understanding of EXPLAIN plans, indexing strategies (including composite indexes), and query rewriting techniques. Proficiency with database schema design and normalization/denormalization strategies to ensure scalability and data integrity, particularly for high-volume transactions. Experience with Eloquent ORM and Laravel Query Builder, coupled with a clear understanding of how these tools generate SQL and how to optimize the underlying queries for performance. Experience working in complex large-scale multitenant SaaS applications. Solid experience with Laravel Authentication and implementing robust security practices in backend systems. Experience with testing tools, such as Pest PHP and PHPUnit, to ensure code quality and system reliability. Proficiency in designing and implementing robust, scalable RESTful APIs in Laravel, focusing on performance and data efficiency. Experience with ReactJS is a plus. Ability to take extreme ownership over your work and collaborate effectively to meet estimates and processes. Ability to identify with Bluelight\'s clients\' goals and deliver on commitments. A positive mindset and a can-do attitude. Forensic attention to detail. Benefits Competitive salary and bonuses, including performance-based salary increases. Generous paid-time-off policy Flexible working hours Work remotely Continuing education, training, conferences Company-sponsored coursework, exams, and certifications Being a consultant in our team is a fun, challenging, and rewarding career choice. Your contributions are highly valued by clients, and the work you do often has a direct and significant impact on their business. You will have the opportunity to work on a variety of projects for our incredible clients, which will accelerate your career growth. You’ll collaborate with modern technologies and work alongside some of the best professionals in the industry If you’re eager to be part of an exciting, challenging, and rapidly growing consultancy, we encourage you to apply. #J-18808-Ljbffr