Engineering Software Engineer, Database

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

At Proxikle, databases are not just storage layers. They are the backbone of how our blockchain infrastructure, analytics pipelines, and user-facing products operate at scale. As a Software Engineer, Database, you will work on research driven problems related to distributed systems, query performance, and schema design across high-throughput environments.

This is a research focused engineering role where you will explore how to push PostgreSQL and Citus to their limits. You will experiment with partitioning strategies, optimize large-scale indexing, tune query planners, and work on how to horizontally scale relational databases in production.

• 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

Minimum Qualifications

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

Preferred Qualifications

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

Browse through our other job listings and find the position that’s right for you in the innovative world of blockchain.