database-expert

To optimize a slow PostgreSQL query, analyze its execution plan and add appropriate indexes to improve performance. This targets query bottlenecks by evaluating execution paths and applying schema-level adjustments for better resource utilization.

Designing a scalable MongoDB schema requires creating efficient document structures tailored to your application's data access patterns. It involves structuring relational data into optimized document formats to ensure high performance and scalability.

Vector database integration for AI and RAG workloads stores vector embeddings to enable semantic search and retrieval. It requires understanding vector embedding principles to effectively query and manage unstructured data for generative models.

Use Redis over PostgreSQL or MongoDB when you need high-speed key-value data access rather than complex relational or document queries. Redis manages rapid data pattern implementation for caching and session management, distinct from full database systems.

Yes, understanding SQL and NoSQL concepts is required to effectively manage database performance and data pattern implementation. This knowledge enables accurate schema design, query optimization, and administration across relational and document stores.