01Overview
Role & responsibilities
Relational Database (MS SQL Server) Must Have Install, configure, and maintain Microsoft SQL Server (2019 / 2022) Must Have Perform routine DBA operations: Must Have Health checks Must Have Backup & recovery Must Have Patch management Must Have Index maintenance Must Have Monitor and optimize: Must Have Query performance Must Have Wait statistics Must Have Locking & blocking Must Have Resource utilization (CPU, memory, I/O) Must Have Implement High Availability & DR: Must Have Always On Availability Groups Must Have Replication Must Have Failover clustering Must Have Manage security: Must Have User access Must Have Encryption Must Have Auditing & compliance Must Have Proactively troubleshoot database issues and reduce downtime Vector Databases & AI Data Platforms Must Have Administer and support Vector Databases, like : Must Have Pinecone Must Have ChromaDB Must Have pgvector (PostgreSQL) Must Have Manage vector indexing, storage, and performance tuning Must Have Support AI/ML workloads such as: Must Have Semantic search Must Have Embeddings storage Must Have RAG (RetrievalAugmented Generation) patterns Must Have Assist development teams with: Must Have Vector schema design Must Have Embedding strategies Must Have Query optimization for similarity search Must Have Monitor latency, throughput, and scaling behavior of vector searches Must Have Ensure data durability, backups, and availability of vector data .
