Duties and Responsibilities:
- Analyze and optimize SQL queries and database performance.
- Identify and resolve query-related bottlenecks and inefficiencies.
- Collaborate with database administrators and developers to improve query performance.
- Implement indexing, partitioning, and other techniques to enhance database efficiency.
- Monitor database performance and provide recommendations for improvements.
- Develop and maintain documentation for query optimization processes and best practices.
- Stay updated with advancements in database technologies and optimization techniques.
Requirements and Qualifications:
- Bachelor’s degree in Computer Science, Information Systems, or a related field.
- Proven experience with database query optimization and performance tuning.
- Proficiency in SQL and database management systems (e.g., MySQL, PostgreSQL, Oracle).
- Strong understanding of database indexing, partitioning, and query execution plans.
- Experience with performance monitoring and analysis tools.
- Excellent analytical and problem-solving skills.
- Ability to work collaboratively with technical teams to resolve performance issues.