Database Developer / Lead Database Engineer

Who We Are & Why Join Us

Avathon is the leading Industrial AI autonomy platform, helping customers across heavy industries - energy, mining, manufacturing, aerospace, defense, and logistics - accelerate the journey toward autonomous operations. Our platform is built on a Computational Knowledge Graph foundation that contextualizes and connects operational data across siloed systems, bringing together time series, structured, unstructured, and machine vision data to power AI-driven applications in asset performance management, supply chain intelligence, visual AI, and global trade management. With capabilities spanning digital twins, normal behavior modeling, natural language processing, and computer vision, Avathon delivers real-time predictive intelligence and agentic decision-making at industrial scale.

Cutting-Edge AI Innovation - Join a team at the forefront of AI, developing groundbreaking solutions that shape the future. High-Growth Environment - Thrive in a fast-scaling startup where agility, collaboration, and rapid professional growth are the norm. Meaningful Impact - Work on AI-driven projects that drive real change across industries and improve lives.

About the Role

We’re hiring a Database Developer / Lead Database Engineer at Avathon – where AI meets the real world.

This is a high-impact role at the intersection of low-level systems programming, distributed storage, and query engine optimization, focused on building core database technology ground-up rather than application-level software.

We are looking for an experienced Database Engineer to lead the architecture, design, and deployment of engine-level database systems across high-performance, large-scale environments. You will tackle real-world storage challenges involving distributed consensus, transaction isolation, custom indexing, and high-throughput query processing across multi-model architectures.

This role offers the opportunity to drive innovation in storage engine design, graph processing, distributed execution, and system reliability, while collaborating closely with engineering and product teams to bring resilient, production-grade database systems into reality.

Core Responsibilities

Architecture & Engine Design

• Storage Engines: Design and implement storage layers using LSM Trees, B-Trees, RocksDB, LevelDB, LMDB, WiredTiger, or custom engines.

• Storage & Indexing: Build efficient key-value storage layouts, secondary/composite indexes, inverted indexes, spatial indexes, and vector indexes.

• Data Iteration: Design high-throughput pagination, cursor mechanics, and large-scale dataset iteration patterns.

• Performance Tuning: Optimize write/read amplification, compaction strategies, caching layers, and Bloom filters.

Distributed Systems & Reliability

• Consensus & Sharding: Implement Raft or Paxos consensus, data partitioning/sharding strategies, and multi-node replication.

• Fault Tolerance: Architect resilient systems capable of automated leader election, failure recovery, dynamic retries, and partition handling.

• Platform Operations: Integrate service discovery (etcd, Consul, ZooKeeper), distributed tracing/observability, zero-downtime rolling upgrades, back-ups, and storage format compatibility layers.

Concurrency, Transactions & Query Execution

• Transaction Control: Work with MVCC, Snapshot Isolation, Optimistic Concurrency Control (OCC), and Two-Phase Locking (2PL).

• Crash Recovery: Implement WAL (Write-Ahead Logging), crash recovery guarantees, deadlock detection, and distributed transactions (2PC).

• Query Optimization: Build and optimize query execution plans, join algorithms, predicate pushdowns, and distributed query execution pipelines.

Quality, Testing & Systems Engineering

• Low-Level Development: Write production-grade C++17/20, Rust, Java, or Scala code focused on low-overhead memory management, profiling, and benchmarking.

• Validation & Testing: Ensure transactional correctness and data integrity via distributed fault injection, property-based testing, and consistency validation suites.

Technical Qualifications

Graph Database Experience (Highly Preferred)

• Hands-on experience with JanusGraph/Titan, Neo4j, TigerGraph, Amazon Neptune, Dgraph, or a custom in-house graph engine.

• Strong understanding of graph storage models, traversal algorithms, graph indexing, and distributed graph processing.

• Familiarity with graph query languages such as Gremlin, Cypher, SPARQL, or SQL/PGQ.

Specialized Indexing

• Vector Search: HNSW, IVF, ANN techniques.

• Spatial Indexing: R-Tree, H3, S2, Geohash.

• Search & Composite: Inverted indexes, full-text search, and multi-column composite structures.

Engineering & Systems Core

• Languages: C++17/20 or Rust (systems level); Java or Scala (distributed services).

• Systems Skills: Deep experience with performance profiling, memory management, low-level debugging, and automated benchmarking.

Lead Engineer Expectations

Candidates applying for Senior or Lead designations will also be expected to:

• Lead technical design, write RFCs/design docs, and establish system architecture.

• Mentor engineers, conduct thorough code reviews, and drive technical standards.

• Deconstruct complex engine initiatives into structured milestone roadmaps.

• Spearhead production incident investigations and root-cause analysis (RCA).

Nice to Have

• Active open-source contributions to database, storage, or graph projects.

• Familiarity with foundational research papers (e.g., Spanner, Dynamo, Percolator, Calvin, Aurora, TAO, Pregel).

• Experience with change data capture (CDC), streaming systems, or materialized view maintenance.

• Background in compiler design, query language parser generation, or multi-model engine design (Graph, Vector, Document, Time-Series).