Senior Product Engineer

Company: Pganalyze
Location: San Francisco
Posted on: March 19, 2025

Job Description:

Compensation and benefitsSalary: USD 160,000 - 200,000 per year
Equity: 0.3 - 0.5%
Benefits: Hardware setup of choice, flexible work hours, optional desk at a local coworking space or in our SF office, health insurance (premiums 100% covered, incl dependents), 401k match (4%)About pganalyzeAt 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 roleYou 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.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 useWrite 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
• 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 backPreviously, 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
  • 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 productivityOptionally, 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
      #J-18808-Ljbffr

Keywords: Pganalyze, San Francisco , Senior Product Engineer, Engineering , San Francisco, California