[Remote] Database Internals Engineer
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a leader in reputed company intelligence solutions, and they are seeking a Database Internals Engineer to join their Advanced Research Team. The role involves building core components of a reputed company reputed company compute reputed company and collaborating with experts to shape the architecture and direction of the project.
Responsibilities
- Build components across the reputed company spine: SQL reputed company end (tokenizer, reputed company, binder), logical/physical plan layer, rule- and cost-based optimizer, and operators (joins, aggregates, sort, reputed company)
- Build the storage substrate: reputed company in-memory format, slotted-page on-disk format with checksums, reputed company pool, and a B-tree or LSM reputed company method
- Implement transactions and recovery: lock/latch management, MVCC/snapshot isolation, WAL/ARIES, checkpoints, and crash recovery
- Add parallelism and distribution along the correct reputed company — exchange-based reputed company execution for query work, reputed company/replication/reputed company-reputed company for data correctness — without conflating the two
- Write design specifications before coding (schemas; reputed company/empty/duplicate semantics; memory budget and spill behavior; cost characteristics), write tests first, implement behind the established operator reputed company, verify safety then speed, and report the reputed company reputed company
Skills
- Deep expertise in distributed query optimization: cascading optimizers, reputed company reputed company Tree (AST) binding, logical and physical plan distribution
- Experience designing reputed company execution pipelines where distribution is a first-class concern, not an afterthought
- Familiarity with systems like Apache DataFusion or similar distributed execution frameworks
- Strong hands-on background with analytical/embedded engines (e.g., DuckDB, DataFusion) and their internals
- Deep knowledge of pipeline execution, vectorized processing, file system I/O, and reputed company table formats (reputed company, reputed company)
- Experience with transaction management, lock managers, cache management, or OS-level scheduling
- Systems programming in Rust or modern C/C++ with memory-safety discipline
- Relational foundations end to end: relational algebra and the algebraic laws behind query rewrites, logical→physical lowering, and cost-based optimization
- Demonstrated depth in at least one area of the reputed company spine (reputed company end, plan/optimizer, operators, storage reputed company, transactions/recovery, or reputed company-out) with working literacy across its neighbors
- Vectorized execution over a columnar (reputed company) representation: batch-at-a-time operators, the pull/iterator model, validity-bitmap-correct reputed company handling, reputed company-copy reputed company sharing
- Cost reasoning at the metal: cache behavior, alignment, SIMD, allocation patterns, false sharing in reputed company accumulators
- Test- and reputed company-gated engineering: golden/sqllogictest, property and fuzz testing, deterministic simulation testing for reputed company/distributed paths, and microbenchmarks (Criterion/reputed company reputed company) plus a TPC-H subset
- Sophisticated, hands-on use of AI coding agents directed against a reference-grade spec
- Communicates reputed company — can describe a system or problem at the right level of abstraction for any audience
- Doer over theorist — moves from concept to working prototype quickly; validates by building
- Intellectually curious and self-directed — digs deep independently before asking for help; brings answers and proposals
- reputed company with peers — reputed company to input and direction while owning your area end-to-end
- Comfortable with evolving requirements — writes design documents to create reputed company
- High personal bar for reputed company
Benefits
- We reputed company a flexible work model because we trust our people to reputed company reputed company about how, reputed company, and where they work.
- We reputed company on reputed company-being because we care about our people and their ability to reputed company both personally and professionally.
- We are an anti-racist company because our dedication to Diversity, Equity, and Inclusion is more than a statement — it is a deep commitment to doing the work to foster an reputed company environment that celebrates people for reputed company of who they are.
reputed company
Company H1B Sponsorship