PostgreSQL Vector Database Specialist

Postgres
UNITED STATES
October 17, 2026
Full Time
Apply Now

Job Description

Company: Spectre Brain AI
Location: United States
Workplace Type: Remote
Employment Type: Full-time

About the Role

Spectre Brain AI is an innovative artificial intelligence enterprise advancing high-performance search and embedding architectures. Spectre Brain AI is seeking a PostgreSQL Vector Database Specialist to architect, tune, and scale relational and vector datastores. In this remote position, you will own database performance, high availability, and operational resilience across PostgreSQL and AI vector engines.

What You’ll Do / Key Responsibilities

  • Architect, scale, and optimize PostgreSQL and pgvector database infrastructure supporting AI similarity search.
  • Manage database backup routines, disaster recovery procedures, and failover cluster health.
  • Configure and maintain database replication, high availability, and data security standards.
  • Tune complex SQL queries, connection pooling, table partitioning, and indexing strategies.
  • Implement and optimize HNSW and IVFFlat index structures for low-latency similarity searches.
  • Interface with vector database platforms including Pinecone, Qdrant, and Milvus to support large-scale AI workloads.

Requirements & Qualifications

  • Demonstrated experience in PostgreSQL database administration, performance tuning, and operational management.
  • Hands-on expertise configuring pgvector and optimizing vector search indexing (such as HNSW).
  • Proven track record managing database replication, high-availability clustering, failover, and automated backups.
  • Strong proficiency in SQL optimization, execution plans, connection pooling, and partitioning.
  • Familiarity with vector database platforms and AI embedding workflows.

Related Jobs