Database Administrator
Posted Updated 1
view
Summary
Experienced DBA to administer Microsoft SQL Server and PostgreSQL alongside vector databases (Pinecone, ChromaDB, pgvector) on an AI data platform — handling installation, performance tuning, HA/DR, security, backups, and monitoring/automation supporting AI/ML workloads like semantic search, embeddings, and RAG.
Job Summary
Key Responsibilities
Required Skills
Preferred Skills
Desired Candidate Profile
Database Administrator (Relational & Vector Databases AI Data Platform)
We are seeking an experienced Database Administrator (DBA) with expertise in both traditional relational databases and modern Vector Databases used for AI/ML and Generative AI applications. The ideal candidate will be responsible for database administration, performance optimization, security, backup & recovery, monitoring, and operational excellence across Microsoft SQL Server, PostgreSQL, and Vector Database platforms.
Key Responsibilities
- Microsoft SQL Server Administration
- Install, configure, and maintain SQL Server 2019/2022 environments.
- Perform database health checks, backup & recovery, patch management, and index maintenance.
- Monitor and optimize query performance, wait statistics, locking/blocking, CPU, memory, and I/O utilization.
- Implement and manage High Availability and Disaster Recovery solutions:
- Always On Availability Groups
- Replication
- Failover Clustering
- Manage database security, user access, encryption, auditing, and compliance.
- Troubleshoot database issues proactively and minimize downtime.
- Vector Database Administration
- Administer and support Vector Databases such as Pinecone, ChromaDB, and pgvector.
- Manage vector indexing, storage, scalability, and performance tuning.
- Support AI/ML workloads including:
- Semantic Search
- Embedding Storage
- Retrieval-Augmented Generation (RAG)
- Collaborate with development teams on vector schema design, embedding strategies, and query optimization.
- Monitor vector search latency, throughput, and scaling behavior.
- Ensure backup, recovery, and availability of vector data.
- PostgreSQL Administration
- Install, configure, and manage PostgreSQL databases.
- Enable and optimize pgvector extension.
- Perform vacuuming, reindexing, replication, and performance tuning.
- Manage role-based security and database access controls.
- Ensure smooth coexistence of relational and vector workloads.
- Monitoring & Automation
- Implement monitoring solutions using SQL monitoring tools, Prometheus, Grafana, Azure, or AWS monitoring services.
- Automate routine DBA tasks using PowerShell, SQL scripts, and Python (preferred).
- Maintain operational runbooks and documentation.
- Participate in incident management, root cause analysis (RCA), and performance reviews.
Required Skills
Core Database Skills
- Strong hands-on experience as an MS SQL Server DBA.
- Excellent SQL and database design knowledge.
- Performance tuning and query optimization expertise.
- Experience with backup, recovery, and high availability solutions.
Vector & AI Data Skills
- Hands-on experience with Pinecone, ChromaDB, or similar Vector Databases.
- Experience with pgvector on PostgreSQL.
- Understanding of embeddings, vector similarity search, and semantic search.
- Exposure to AI/ML data pipelines and Generative AI workloads.
Scripting & Automation
- PowerShell scripting.
- SQL scripting and automation.
- Basic Python knowledge preferred.
Preferred Skills
- Azure SQL, Managed Instances, or AWS RDS.
- Azure OpenAI and LLM ecosystem exposure.
- Experience supporting Generative AI platforms.
- Kubernetes-backed databases and containerized environments.
- CI/CD integration for database deployments.
- Familiarity with DevOps and MLOps concepts.
- Data privacy, governance, and compliance awareness.
Desired Candidate Profile
- 4 - 6 years of overall database administration experience.
- Minimum 1 year of hands-on experience with Vector Databases or AI Data Platforms.
- Strong analytical and troubleshooting skills.
- Excellent documentation and communication abilities.
- Ability to collaborate with AI Engineers, Developers, Architects, and Operations teams.
- Ownership mindset with a production-first approach.
Skills
- AI
- Automation
- AWS
- Azure
- ChromaDB
- CI/CD
- Data Pipelines
- DevOps
- Embeddings
- Generative AI
- Grafana
- Kubernetes
- LLM
- Machine Learning
- MLOps
- OpenAI
- pgvector
- Pinecone
- PostgreSQL
- PowerShell
- Prometheus
- Python
- RAG
- RDBMS
- RDS
- Root Cause Analysis
- Semantic Search
- SQL
- SQL Server
- Statistics
- Vector Databases
- Vector Search