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 prospects 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 effective 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
Strong hands-on experience with SingleStore (formerly MemSQL).
Good 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 (India)
🏢 Anlage Infotech
📍 India