Text copied to clipboard!
Title
Text copied to clipboard!Query Optimizer for PHP Monolith LMS
Description
Text copied to clipboard!
We are looking for a highly skilled Query Optimizer for PHP Monolith LMS to enhance the performance and efficiency of a learning management system (LMS) developed in PHP with a monolithic architecture. The ideal candidate will have deep knowledge of SQL, query optimization, and solid experience with legacy LMS systems.
The role involves analyzing and rewriting inefficient SQL queries, collaborating with the development team to identify performance bottlenecks, and proposing technical solutions to improve system scalability and speed. You will also be responsible for documenting changes and training the team on optimization best practices.
The candidate must be able to work in a dynamic environment with tight deadlines and communicate effectively with developers, analysts, and non-technical stakeholders. Familiarity with profiling and performance monitoring tools is a plus.
This role is critical to ensuring a smooth and responsive user experience within the LMS platform, directly contributing to end-user satisfaction and system stability.
Responsibilities
Text copied to clipboard!- Analyze and optimize complex SQL queries
- Collaborate with the development team to improve system performance
- Identify database performance bottlenecks
- Propose structural changes to improve database efficiency
- Document changes and optimizations made
- Train the team on optimization best practices
- Use profiling tools to monitor performance
- Ensure compatibility of changes with existing monolithic architecture
Requirements
Text copied to clipboard!- Proven experience with PHP and LMS systems
- Strong knowledge of SQL and query optimization
- Experience with relational databases (MySQL, PostgreSQL)
- Familiarity with profiling and monitoring tools
- Ability to work in cross-functional teams
- Good communication skills
- Experience with monolithic architectures
- Understanding of legacy system scalability challenges
Potential interview questions
Text copied to clipboard!- What is your experience with SQL query optimization?
- Have you worked with a monolithic LMS system in PHP?
- What tools do you use for performance profiling?
- How do you handle database performance bottlenecks?
- Do you have experience with technical documentation?
- How do you communicate technical changes to non-technical stakeholders?
- Have you ever proposed structural changes to an existing database?
- How do you ensure compatibility of changes with legacy systems?
