Database Performance Engineer

Experience: 3 to 5 Years
Location: Bangalore
Employment Type: Full-time

Key Responsibilities
- Analyze and optimize SingleStore and MongoDB workloads for performance, scalability, and reliability.
- Investigate and troubleshoot slow queries, high resource utilization, latency, throughput issues, and database bottlenecks.
- Analyze query execution plans and identify opportunities for query, indexing, schema, and data-model optimization.
- Optimize SQL queries, MongoDB queries, aggregation pipelines, indexes, and database access patterns.
- Work with application engineering teams to identify inefficient database usage patterns and recommend improvements.
- Analyze the impact of data distribution, partitioning/sharding, indexing, joins, aggregations, and query patterns on database performance.
- Perform database performance benchmarking and establish performance baselines.
- Conduct root-cause analysis for database performance issues and production incidents.
- Monitor database health, resource utilization, workload patterns, and capacity requirements.




- Collaborate with database/platform teams on performance tuning and capacity planning.
- Provide technical guidance and best practices to application teams for efficient use of SingleStore and MongoDB.
- Develop and maintain Python scripts and automation for database monitoring, diagnostics, performance analysis, and operational activities.
- Document database performance guidelines, troubleshooting procedures, optimization recommendations, and technical solutions.

Required Skills & Experience

SingleStore
- Solid hands-on experience with SingleStore (formerly MemSQL).
- Valuable understanding of SingleStore architecture and distributed SQL concepts.
- Understanding of aggregator and leaf nodes and distributed query execution.
- Experience with query optimization and EXPLAIN/query plan analysis.
- Strong understanding of indexing and data distribution.
- Knowledge of sharding/distribution k

📌 Database Engineer (Bengaluru)
🏢 Anlage Infotech
📍 Bengaluru