Database Engineer Postgres Internals

Postgres Database Internals Engineer

ParadeDB is a transactional alternative to Elasticsearch built on Postgres. We build state-of-the-art full-text search and columnar analytics as a Postgres extension. Companies like Modern Treasury, BILT Rewards, Alibaba Cloud, many others use ParadeDB to:

• Eliminate ETL/change data capture tools
• Add transactional guarantees to their search indexes
• Perform JOINs on their search data

We're a small, focused team of engineers dedicated to creating an inclusive and enjoyable work environment. We have an office in San Francisco, with some team members distributed across the United States and Canada. We're a Series A Company with a flat structure, strong investors, and lots of room for growth.

We're looking for a Postgres database internals engineer to join our team full-time. The ideal candidate should have:

• A solid foundation in data systems/database internals
• Experience working with Postgres databases internals (bonus points if you have experience working with pgrx)
• Proficiency in systems programming with C/C++/Rust/Zig (bonus points for Rust)
• Strong background in full-text search systems and/or data analytics/query engines is a plus
• Familiarity with Tantivy and/or OLAP query engines like Apache DataFusion is a plus

We're seeking someone creative, independent, and excited by difficult technical challenges who can teach us as much as they learn from us. The ideal candidate will bring thoughtful opinions to the team, be excited to engage with and learn from customers, and be willing to wear many hats.

You want to be part of the core team of a fast-growing infrastructure startup

You want to wear many hats and interface directly with customers

You're passionate about the Postgres ecosystem, databases, search technologies, and/or data analytics

You're excited about diving deep into the internals of Postgres and writing high-performance, safe Rust code to elevate Postgres for search and analytical workloads

You're excited to learn about the internals of Tantivy, Apache DataFusion, and columnar file formats like Parquet/Arrow to inspire optimizations in ParadeDB

You believe in open-source and want to contribute to building a sustainable open-source business

You want autonomy over your work and the opportunity to make impactful design decisions

You have meaningful experience working with Postgres internals, whether through contributions to core Postgres or through high-quality Postgres extension work

You have prior experience working on complex data systems in Rust, C++, C or Zig and can navigate a complex codebase effectively (bonus points if you have contributions to an open-source project that you can showcase)

You have architected data system(s) focusing on performance, scalability, and maintainability (bonus points if in Rust)

You have optimized and debugged complex systems using profiling tools

You have prior experience at a small, high-performing startup

Overall, you're smart, willing to work hard, communicative, and open to learning about any service or framework you may not have worked with before

You'll develop and optimize the ParadeDB Postgres extension by implementing features interfacing with Postgres block storage, query planner, query executor, index definition, and more using Postgres APIs via pgrx

You'll develop with the internals of Tantivy, sometimes making modifications to Tantivy as required, to implement new features within the ParadeDB Postgres extension

You'll design and implement efficient data structures and algorithms for search and analytical functionalities, drawing inspiration from or directly utilizing existing open-source projects like Tantivy and DataFusion

You'll optimize query performance and resource utilization using profiling tools

You'll develop and maintain documentation, including API references and user guides

You'll engage directly with our customers and open-source community on GitHub and Slack

You'll contribute to technical writing, product demos, and content marketing

You'll help shape ParadeDB's product roadmap and technical direction

Please send your resume and anything else you'd like to share to View email address on click.appcast.io. We will get back to you as soon as we can. We're excited to meet you!

ParadeDB is committed to fostering a welcoming and inclusive work environment for people of all backgrounds. We urge candidates of all backgrounds to apply. If you require specific accommodations, please let us know at View email address on click.appcast.io.