Database Engineer - SQL (5-7 yrs)

Job Description :

We seek an experienced Database Performance Optimization Engineer to tackle performance issues in our AWS RDS environment (primarily MySQL). In this role, you will analyze and optimise database queries, manage connection limits, and improve overall database configurations to ensure smooth operation under high load and concurrency.

Your expertise will be critical in diagnosing performance bottlenecks, implementing efficient indexing and caching strategies, and designing solutions to handle concurrent requests through effective queuing mechanisms.

Key Responsibilities :

- Query & Index Optimization : Optimize SQL queries and indexing strategies for fast data retrieval, especially as load increases.

- Configuration Analysis : Evaluate and adjust database configuration settings, connection limits, and caching implementations to prevent performance degradation.

- Load Testing & Bottleneck Identification : Conduct load tests, identify failure points when the database reaches peak loads, and propose actionable improvements.

- Collaborative Problem-Solving : Work closely with DevOps and development teams to understand current challenges and implement best practices.

- Multi-Database Experience : Utilize your knowledge of additional databases (e.g., OpenSearch, Firebase, Firestore, PostgreSQL) to support a diverse database environment.

Qualifications :

- Proven experience with MySQL and AWS RDS (or similar relational database services) in high-load scenarios.

- Strong understanding of query performance, indexing, and connection pooling techniques.

- Hands-on experience with load testing and performance tuning.

- Ability to diagnose and resolve complex database configuration issues.

- Excellent analytical skills and effective communication with cross-functional teams.

- If you're passionate about optimizing database performance and have a track record of resolving high-concurrency challenges, we'd love to hear from you