Description

Database Design

Design and implement scalable MongoDB/CouchDB schemas.

Ensure efficient schema modeling for structured and unstructured data.

Apply normalization/denormalization strategies based on performance needs.

Performance Tuning

Optimize queries and aggregation pipelines for speed and efficiency.

Conduct execution plan analysis and resolve bottlenecks.

Implement caching and indexing strategies to reduce latency.

Complex Query Writing

Write advanced queries and aggregation pipelines for analytics and transactional workloads.

Handle geospatial, text, and compound queries.

Ensure query reliability under high-volume workloads.

Advanced Indexing

Design and maintain compound, text, and geospatial indexes.

Monitor index usage and optimize for query execution.

Balance indexing strategies with storage and performance trade-offs.

Database Issue Troubleshooting

Diagnose and resolve locks, deadlocks, and query execution issues.

Perform root cause analysis for recurring database problems

Key Skills

Education

Bachelor's degree