Senior Backend Engineer
Job Description
Posted 11 months ago
At pganalyze, we redefine the user experience for optimizing the performance of Postgres databases. Our product helps customers such as Atlassian, Robinhood and DoorDash to understand complex Postgres problems and performance issues.
Application developers use pganalyze to get deep insights into complex database behaviors. Our product is heavy on automated analysis and custom visualizations, and makes automatic recommendations, such as suggesting the best index to create for a slow query.
You will enjoy working at pganalyze if you are a software craftsperson at heart, who cares about writing tools for developers. You will take new features from idea to production deployment end-to-end within days. Your work will regularly involve writing or contributing to open-source components as well as the Postgres project.
We are a fully remote company, with the core team based in the San Francisco Bay Area. Our company is bootstrapped and profitable. We emphasize autonomy and focus time by having few meetings per week.
About the role
Your core responsibility: To develop and optimize our Postgres statistics and analysis pipeline, end-to-end, and work on the processes that generate automated insights from the complex data set. This work involves having a detailed understanding of the core data points that are collected from the source Postgres database as a timeseries, optimizing how they get retrieved, transported to the pganalyze servers, and then processed and analyzed.
Today, this data pipeline is a combination of open-source Go code (in the pganalyze collector), and statistics processing written in Ruby. You will be responsible for improving this pipeline, introducing new technologies, including a potential rewrite of the statistics processing in Rust.
Some of the work will lead into the depths of Postgres code, and you might need to compile some C code, or understand how the pganalyze parser library, pg_query, works in detail.
Your work is the foundation of the next generation of pganalyze, with a focus on the automatic insights we can derive from the workload of the monitored Postgres databases, and giving fine-tuned recommendations such as which indexes to create, or which config settings to tune.
At pganalyze, you will:
Previously, you have:
Optionally, you may also have:
You could also be familiar with:
Salary and compensation
$140,000 — $180,000/year
Location
United States / Canada
Job Summary
Similar Jobs
The largest community on the web to find and list jobs that aren't restricted by commutes or a specific location.
Platform Engineering Manager
-
CipherHealth
CipherHealth is hiring a Platform Engineering Manager. Th...
Senior QA Engineer (Automation)
-
Wallarm
Wallarm is hiring a QA engineer to work on automation. Yo...
Aha! is hiring a Sr. Rails Engineer or Ruby on Rails engi...