Job highlights

- 4-6 years DBA experience with expertise in MS SQL Server, PostgreSQL, and Vector Databases like Pinecone or ChromaDB
- Administer and optimize relational and vector databases, manage backup/recovery, high availability, performance tuning, and support AI/ML workloads

Job Summary 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.
- Robust 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.

📌 Database Administrator (Pune)
🏢 Honeybee Tech Solutions
📍 Pune