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.

You can learn more about Benefits of Working at Proxikle.

Job 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

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