pganalyze Senior Product Engineer

About pganalyze

At pganalyze, we’re redefining how developers optimize one of the world’s most popular databases, PostgreSQL. Our software gives companies like Atlassian, Robinhood, and Notion the tools to solve their most complex Postgres performance challenges, ensuring their mission-critical applications run smoothly at scale.

By joining us, you’ll tackle the complex technical and user experience problems at the heart of large Postgres deployments, collaborate with a passionate team and open source community, and, together, help shape the future of Postgres. Our product is heavy on automated analysis and custom visualizations, and we build advisors to make automatic recommendations, such as the best index to fix a slow query.

We are a fully remote company, with the core team based in the San Francisco Bay Area. Our company is independent, self-funded, and profitable, giving us complete control over our product roadmap and priorities. We emphasize autonomy and focus time by having few meetings per week.

We welcome people of different backgrounds, abilities, experiences and perspectives. Having a work environment that is diverse, inclusive and focuses on learning from one another is central to how we operate. Working together is a form of community, and we care about the shared spaces being safe and supportive.

About the role

You will be responsible for driving feature development from concept to writing code to deployment, ensuring that the user experience is thought through, test coverage is adequate, and all the data supporting a feature is retrieved correctly and stored effectively in the Postgres database that powers pganalyze itself. Sometimes you might have to dig deep into Postgres internals to explain information correctly in a visual way.

Recent examples of work done by our product engineers include the launch of our Query Tuning Workbooks feature (lots of details to get right!), our Buffer Cache Monitoring functionality, or our integration with Plan Statistics provided by some Postgres-as-a-service providers.

In this role you can expect to write the foundational code of new advisors, highlight new data added by recent Postgres releases, or improve existing product functionality that make the product more valuable and useful to our customers.

At pganalyze you will:

• Collaborate with other engineers on shipping new functionality end-to-end, and ensure features are well implemented and easy to use Write code in Ruby, Rust, Typescript/React.js, or Go to ship customer-facing features
• Think outside the box and focus on first principles when looking at a problem, for example to find better ways of visualizing complex data
• Try new approaches of combining different libraries and frameworks, such as combining React and d3.js (read more about how we solved this)
• Write public-facing documentation for features you develop, announce them on the pganalyze blog, and take customer feedback to improve and iterate on your work
• Take time to consider different data formats and data models to effectively implement APIs and associated backend systems
• Work on additional functionality that supports the core product use case, from Single-Sign On integrations to subscription billing code
• Work on our existing open-source projects and collaborate with upstream communities to contribute code back

Previously, you have:

• Worked professionally for at least 5 years as a software engineer
• Written complex, data heavy backend code with Ruby or Rust
• Created features end to end with Typescript and React.js
• Rendered a chart in a browser using a high-level charting library or d3.js
• Used Postgres for multiple projects, and are familiar with using “EXPLAIN” on a query
• Created indexes on a Postgres database based on a query being slow
• Written code that fetches data and/or interacts with cloud provider APIs
• Structured your work and set your schedule to optimize for your own productivity

Optionally, you also have:

• Launched new products from scratch, taking something from nothing to the first users
• Created your own libraries for rendering charts, or analyzing time series
• Explored different ways of visualizing data sets for easy understanding
• Optimized a data-heavy application built on Postgres
• Experimented with ML frameworks to analyze complex data sets