Experience
: 5.00 + years
Salary
: Confidential (based on experience)
Expected Notice Period
: 15 Days
Shift
: (GMT+05:30) Asia/Kolkata (IST)
Opportunity Type
: Remote
Placement Type
: Full Time Contract for 6 Months(40 hrs a week/160 hrs a month)
(*Note: This is a requirement for one of Uplers' client - Agentic AI Platform)What do you need for this opportunity?Must have skills required:Open-source database contributions, ANN Indexing, cloud-native/self-service databases, Concurrency handling, Rust, Vector indexing, vector search tools, C, C++Agentic AI Platform is Looking for:
Role Description
Extend our existing database with native vector capabilities—data types, ANN indexes, query planning, and developer APIs—so applications can run hybrid (sparse+dense) search at production scale with ACID guarantees.
- Role- Senior Software Engineer
- Experience Required: 5+ years
- Shift Time: 12:00 PM to 9:00 PM IST remotely
- Job Type: Full Time Contract for 6 months- Extendible
- Payroll- Uplers Talent Solutions
- Device- Talent has to use their own device
Skills
Vector data model
- New VECTOR/EMBEDDING column types, distance operators (L2, cosine, dot), and server-side normalization.
- Ingestion/backfill pipelines for embeddings; bulk loaders and online updates.
ANN indexing in the DB
- Production-grade HNSW / IVF-Flat / IVF-PQ (and variants) in C/C++.
- Persistence integrated with WAL/checkpoints/snapshots; crash safety and fast recovery.
- Index lifecycle: online CREATE INDEX … USING HNSW/IVF, background build/merge, partial rebuilds, compaction/vacuum, tombstone handling.
Transactions, MVCC & consistency
- Visibility rules for vector rows/segments under MVCC; point-in-time queries; repeatable reads for ANN.
- Write path that avoids long stalls; predictable p95/p99 latency under mixed read/write workloads.
Query planner / optimizer integration
- New planner nodes and cost model for ANN; predicate/column pushdown; hybrid plans (BM25/keyword + vector + filters).
- Join strategies (e.g., ANN-first with LATERAL, or filter-first then re-rank); parameterized search (ef, nprobe, pq_m, recall_target).
Distributed operations
- Replication/streaming of vector indexes; shard placement & rebalancing; hot-index warmup.
- Rate/CPU/RAM isolation per tenant; guardrails for memory growth and tail latency.
APIs, SDKs & tools
- SQL syntax, gRPC/HTTP endpoints, and SDKs (Python, Java, Node.js) aligned with existing drivers.
- Admin surfaces: collection/index management, backups, restore, zero-downtime upgrades.
- Observability: metrics, traces, pg_stat-like views for ANN, slow-query analyzer.
Minimum Qualifications
- 6–10+ years building performance-critical systems in C/C++, plus one of Python/Node/Java.
- Deep knowledge of data structures, concurrency, memory layout, profiling, and low-latency I/O.
- Hands-on with search/vector stacks (FAISS, hnswlib, ScaNN, NMSLIB, Milvus, Qdrant, Vespa, Lucene/Elasticsearch/OpenSearch) or custom engines.
- Experience integrating with database internals (WAL, MVCC/ACID, query planning, storage engines).
Nice to have:
- SIMD (AVX2/AVX-512/NEON), GPU/CUDA/ROCm, or FPGA acceleration.
- LSM/B-tree/columnar storage, compaction strategies, snapshot/backup/restore.
- Re-ranking (MMR, late interaction/ColBERT), PQ/OPQ/SQ quantization, workload-aware autotuning.
- Multi-tenant resource isolation; k8s ops; packaging (static, musl, cross-compile).
- Developer-tooling craftsmanship (docs, CLIs, codegen, examples).
Interview Rounds
- 1st round : Screening round (BGV, Technical expertise, current technical stack, etc)
- 2nd round: Virtual interview (looking for existence contribution, as this is very specific need)
- 3rd round- If needed
How to apply for this opportunity?
- Step 1: Click On Apply! And Register or Login on our portal.
- Step 2: Complete the Screening Form & Upload updated Resume
- Step 3: Increase your chances to get shortlisted & meet the client for the Interview!
About Uplers:
Our goal is to make hiring reliable, simple, and fast. Our role will be to help all our talents find and apply for relevant contractual onsite opportunities and progress in their career. We will support any grievances or challenges you may face during the engagement.(Note: There are many more opportunities apart from this on the portal. Depending on the assessments you clear, you can apply for them as well).So, if you are ready for a new challenge, a great work environment, and an opportunity to take your career to the next level, don't hesitate to apply today. We are waiting for you!
