Database Engineer — Storage & Query Execution

About the role

The ideal candidate will develop and optimize the ParadeDB PostgreSQL extension using Postgres APIs via pgrx, build features that interface with Postgres storage, indexing, query planning, query execution, and extension infrastructure, work with the internals of Tantivy, Apache DataFusion, and other open-source systems to implement new search and analytics capabilities, contribute to the evolution of ParadeDB's search, analytics, indexing, and query processing capabilities, develop and maintain documentation, engage directly with our customers and the open-source community on GitHub and Slack, and contribute to technical writing, product demos, and content marketing.

Responsibilities

• Develop and optimize the ParadeDB PostgreSQL extension using Postgres APIs via pgrx
• Build features that interface with Postgres storage, indexing, query planning, query execution, and extension infrastructure
• Work with the internals of Tantivy, Apache DataFusion, and other open-source systems to implement new search and analytics capabilities
• Contribute upstream to Tantivy, DataFusion, and our other dependencies
• Design and implement efficient data structures and algorithms for search and analytical workloads
• Optimize query performance and resource utilization using profiling tools
• Contribute to the evolution of ParadeDB's search, analytics, indexing, and query processing capabilities
• Develop and maintain documentation, including API references and user guides
• Engage directly with our customers and the open-source community on GitHub and Slack
• Contribute to technical writing, product demos, and content marketing

Requirements

• A solid foundation in database systems and internals
• Meaningful experience working on databases, query engines, storage engines, indexing systems, or similarly complex infrastructure software
• Proficiency in systems programming with C/C++/Rust/Zig and the ability to navigate large, complex codebases effectively (bonus points for Rust)
• Experience designing, profiling, optimizing, and debugging systems with a focus on performance, scalability, and maintainability
• Familiarity with query optimization, vectorized execution, columnar storage, or analytical query processing is a plus
• Familiarity with search systems is a plus
• Familiarity with technologies such as Tantivy, Apache DataFusion, Arrow, Parquet, or pgrxis a plus
• Contributions to high-quality open-source projects are a plus
• Prior experience at a small, high-performing startup is a plus

Qualifications

• Experience with Postgres internals, database extensions, or related systems is a plus

Skills

• Rust
• Distributed Systems

Benefits

• Will sponsor

Pay

• $150K - $250K

Schedule

• 0.15% - 0.40%

Location

• San Francisco, CA, US / Remote (CA; US)