Text copied to clipboard!
Title
Text copied to clipboard!PHP LMS Monolith Query Optimizer
Description
Text copied to clipboard!
We are looking for a highly skilled PHP LMS Monolith Query Optimizer to join our dynamic team. The ideal candidate will have extensive experience in optimizing database queries within a PHP-based Learning Management System (LMS) monolith. You will be responsible for analyzing, diagnosing, and improving the performance of complex SQL queries to ensure the LMS operates efficiently and effectively. Your role will involve working closely with developers, database administrators, and other stakeholders to identify performance bottlenecks and implement solutions. You should have a deep understanding of PHP, SQL, and database optimization techniques. Additionally, you will be expected to stay up-to-date with the latest industry trends and best practices to continuously improve the system's performance. This is a critical role that requires a detail-oriented individual with excellent problem-solving skills and the ability to work under pressure. If you are passionate about optimizing database performance and have a proven track record in this area, we would love to hear from you.
Responsibilities
Text copied to clipboard!- Analyze and optimize complex SQL queries within the LMS.
- Collaborate with developers to identify and resolve performance bottlenecks.
- Implement indexing strategies to improve query performance.
- Monitor database performance and provide recommendations for improvements.
- Conduct regular performance tuning and optimization tasks.
- Develop and maintain documentation related to query optimization.
- Work closely with database administrators to ensure optimal database configuration.
- Perform code reviews to ensure best practices in query writing.
- Stay up-to-date with the latest industry trends and best practices.
- Provide training and support to team members on query optimization techniques.
- Assist in the design and implementation of new database features.
- Participate in performance testing and benchmarking activities.
- Troubleshoot and resolve database-related issues.
- Ensure data integrity and security within the LMS.
- Collaborate with stakeholders to understand business requirements and translate them into technical solutions.
Requirements
Text copied to clipboard!- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 5+ years of experience in PHP development.
- Extensive experience with SQL and database optimization techniques.
- Strong understanding of database indexing and query optimization.
- Experience with MySQL or other relational databases.
- Proficiency in performance tuning and troubleshooting.
- Excellent problem-solving skills and attention to detail.
- Ability to work independently and as part of a team.
- Strong communication and collaboration skills.
- Experience with version control systems such as Git.
- Knowledge of best practices in database design and development.
- Familiarity with performance testing and benchmarking tools.
- Ability to work under pressure and meet tight deadlines.
- Strong analytical and critical thinking skills.
- Experience with large-scale database systems is a plus.
Potential interview questions
Text copied to clipboard!- Can you describe your experience with optimizing SQL queries in a PHP-based LMS?
- What techniques do you use to identify and resolve performance bottlenecks?
- How do you approach indexing strategies to improve query performance?
- Can you provide an example of a complex query optimization you have performed?
- How do you stay up-to-date with the latest industry trends and best practices?
- What tools do you use for performance testing and benchmarking?
- How do you ensure data integrity and security within an LMS?
- Can you describe a time when you had to troubleshoot a difficult database issue?
- How do you collaborate with developers and database administrators to optimize queries?
- What is your experience with version control systems such as Git?