Назад
Company hidden
1 день назад

Software Engineer, Database (PostgreSQL/Citus)

Формат работы
onsite
Тип работы
fulltime
Грейд
middle
Английский
b2
Страна
US
Вакансия из списка Hirify.GlobalВакансия из Hirify Global, списка международных tech-компаний
Для мэтча и отклика нужен Plus

Мэтч & Сопровод

Для мэтча с этой вакансией нужен Plus

Описание вакансии

Текст:
/
TL;DR
Software Engineer, Database (PostgreSQL/Citus): Designing, benchmarking, and optimizing distributed PostgreSQL and Citus clusters for blockchain infrastructure, analytics pipelines, and user-facing products with an accent on query performance, schema design, and horizontal scaling. Focus on researching partitioning and query routing, tuning planners and indexes, and building observability and automation for production database systems.

Location: United States

Company

hirify.global develops blockchain infrastructure, analytics pipelines, and user-facing products that operate on large-scale database systems.

What you will do

  • Design, benchmark, and optimize schemas and queries for large-scale PostgreSQL and Citus clusters.
  • Research partitioning strategies, query routing techniques, replication approaches, and horizontal scaling for distributed PostgreSQL.
  • Collaborate with backend teams on database models for product features and analytics workflows.
  • Monitor and tune performance across shards, coordinators, and workers.
  • Build observability tools and improve the health monitoring of production database systems.
  • Maintain database architecture, migration flows, and failover strategies while automating backups, sharding, and cluster scaling with infrastructure teams.

Requirements

  • 2–4 years of strong PostgreSQL experience, including query optimization, indexes, and schema design.
  • Interest in database internals, distributed systems, and performance research.
  • Experience writing clean SQL, debugging query plans, and using monitoring tools such as pg_stat_statements or pgBadger.
  • Familiarity with version control workflows, especially Git.

Nice to have

  • Hands-on experience with Citus or similar distributed PostgreSQL solutions.
  • Exposure to logical replication, partitioned tables, and foreign data wrappers.
  • Familiarity with PostgreSQL extensions such as TimescaleDB, PostGIS, or custom indexing strategies.
  • Experience with infrastructure tooling such as Ansible, systemd, or containerized PostgreSQL.
  • Knowledge of monitoring and alerting systems such as Prometheus and Grafana.

Culture & Benefits

  • Research-focused engineering work centered on distributed systems, database performance, and production scalability.
  • Benefits are available through hirify.global; details are provided on the company careers page.

Будьте осторожны

Если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого. Это мошенники. Обязательно жмите «Пожаловаться» или пишите в поддержку. Подробнее в гайде →