PostgreSQL & Citus Performance Engineer

Proxikle Inc.; Northern (KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Proxikle Inc. is advancing its blockchain-powered analytics stack by pushing PostgreSQL and Citus in high-throughput environments.

As a Software Engineer, Database, you will tackle distributed systems challenges, from partitioning strategies to schema design and performance tuning across large clusters. You will design, benchmark, and optimize schemas and queries while collaborating with backend teams on evolving data models for new features and analytics workflows.

Qualifications

• 2–4 years of PostgreSQL experience focusing on query optimization, indexing, and schema design.
• Interest in database internals, distributed systems, and performance research.
• Experience writing clean SQL and using monitoring tools like pg_stat_statements or pgBadger.
• Familiarity with Git workflows.

Responsibilities

• Design, benchmark, and optimize schemas and queries for large-scale PostgreSQL and Citus clusters.
• Research new partitioning strategies, query routing techniques, and replication approaches for distributed Postgres.
• Collaborate with backend teams to evolve database models for new product features and analytics workflows.
• Monitor and tune query performance across shards, coordinators, and workers.
• Build tools to improve observability and health of production database systems.
• Evaluate experimental extensions, indexes, and planner settings to improve performance.
• Maintain and document database architecture, migration flows, and failover strategies.
• Work with infrastructure teams to automate backups, sharding strategies, and cluster scaling.

Skills

PostgreSQL

Query optimization

Schema design

Distributed systems

SQL

Git

pg_stat_statements

Tools

Citus

TimescaleDB

PostGIS

Ansible

Prometheus

Grafana

pgBadger

pg_stat_statements

Job description

Proxikle Inc. is advancing its blockchain-powered analytics stack by pushing PostgreSQL and Citus in high-throughput environments.

As a Software Engineer, Database, you will tackle distributed systems challenges, from partitioning strategies to schema design and performance tuning across large clusters. You will design, benchmark, and optimize schemas and queries while collaborating with backend teams on evolving data models for new features and analytics workflows.