Text copied to clipboard!
Title
Text copied to clipboard!Query Optimizer for PHP LMS Monolith
Description
Text copied to clipboard!
We are looking for a Query Optimizer for PHP LMS Monolith to join our development team and help improve the performance and scalability of our learning management system. This role is ideal for someone with a strong background in database optimization, PHP development, and large-scale monolithic applications. You will be responsible for analyzing, profiling, and optimizing SQL queries, as well as collaborating with developers to implement best practices for data access and storage.
Our LMS platform serves thousands of users daily and is built on a monolithic PHP architecture with a MySQL backend. As the system grows, performance bottlenecks have become more apparent, especially in areas involving complex joins, subqueries, and inefficient indexing. Your primary mission will be to identify these issues and implement solutions that reduce query execution time, improve server response, and enhance the overall user experience.
You will work closely with backend developers, DevOps engineers, and QA testers to ensure that all optimizations are thoroughly tested and deployed safely. You will also be expected to document your findings and contribute to internal knowledge bases to help other team members understand and apply optimization techniques.
This position requires a deep understanding of SQL performance tuning, query execution plans, and PHP data access patterns. Familiarity with profiling tools, such as New Relic, Blackfire, or Xdebug, is a plus. Experience with caching strategies, database sharding, and horizontal scaling will also be beneficial.
If you are passionate about performance, love digging into slow queries, and want to make a tangible impact on a widely-used educational platform, we encourage you to apply.
Responsibilities
Text copied to clipboard!- Analyze and optimize slow SQL queries in a PHP monolith LMS
- Collaborate with developers to implement efficient data access patterns
- Use profiling tools to identify performance bottlenecks
- Refactor existing queries and database schema for better performance
- Implement indexing strategies and caching mechanisms
- Monitor database performance and suggest improvements
- Document optimization processes and best practices
- Participate in code reviews with a focus on query efficiency
- Work with DevOps to ensure optimized queries are deployed safely
- Stay updated on latest trends in database optimization
Requirements
Text copied to clipboard!- Proven experience with SQL query optimization
- Strong knowledge of PHP and MySQL
- Familiarity with monolithic application architecture
- Experience using profiling tools like New Relic or Xdebug
- Understanding of indexing, joins, and query execution plans
- Ability to work collaboratively in a team environment
- Excellent problem-solving and analytical skills
- Experience with caching strategies and performance tuning
- Good written and verbal communication skills
- Bachelor’s degree in Computer Science or related field
Potential interview questions
Text copied to clipboard!- Can you describe a time you optimized a complex SQL query?
- What tools do you use for profiling PHP applications?
- How do you approach identifying performance bottlenecks?
- What is your experience with monolithic PHP applications?
- Have you worked with any LMS platforms before?
- How do you ensure your optimizations are safe for production?
- What caching strategies have you implemented in the past?
- How do you stay current with database optimization techniques?
- Can you explain the difference between clustered and non-clustered indexes?
- What’s your process for documenting optimization work?
