Database Engineer (PostgreSQL)

We are building a high-scale payment orchestration system that processes millions of financial transactions every month across multiple payment providers, regions, and products. Our platform operates at the intersection of payments, billing, subscriptions, analytics, and internal CRM tooling, where data correctness, performance, and reliability are mission-critical. As our transaction volume and customer base continue to grow rapidly, our database layer has become one of the most important parts of the system. We are looking for a strong Database Engineer who will own, scale, and evolve our data infrastructure, ensuring it remains fast, reliable, and ready for long-term growth. You will be joining a high-talent, fully remote engineering organization with strong backend, infrastructure, and product teams. We value ownership, technical excellence, and pragmatic decision-making. Engineers at RubyLabs work on real scale, real money, and real impact. As a Database Engineer at RubyLabs, you will be responsible for designing, operating, and optimizing databases in a high-volume payments environment.

Responsibilities

Own and operate AWS Aurora (PostgreSQL) in a high-load production environment; Design and evolve schemas for large transactional domains (payments, customers, subscriptions, events); Implement and maintain table partitioning strategies, advanced indexing, and query optimization and execution-plan tuning; Analyze and optimize slow queries and production metrics; Identify and resolve lock contention, vacuum/autovacuum issues, connection pool saturation, and long-running or inefficient queries; Design high-performance search solutions for large operational datasets used in internal CRM tools; Work with event and log data pipelines, including Tinybird / ClickHouse-based analytics; Ensure data integrity and consistency in financial workflows; Define and monitor database health metrics (latency, replication lag, storage, IOPS); Plan and execute safe schema changes and migrations on large tables; Participate in incident analysis related to data performance or availability; Work on backups, replication, and disaster-recovery strategies

Requirements

Strong hands-on experience with PostgreSQL in production; Experience managing large databases (hundreds of millions of rows or more); Solid understanding of indexing strategies, query planners and execution paths, transactions, isolation levels, and locking; Experience working with AWS-based infrastructure, ideally AWS Aurora; Ability to independently investigate and resolve complex performance issues; Located within approximately ±4 hours of CET

Nice to have

Experience in payments, billing, fintech, or financial systems; Familiarity with analytical databases (ClickHouse, Tinybird, or similar); Familiarity with OpenSearch or similar, including data ingestion from PostgreSQL; Experience designing data models for multi-tenant systems; Understanding of event-driven architectures and data pipelines; AWS certifications (e.g., Solutions Architect, Database Specialty)

Benefits

Remote Work Environment; Unlimited PTO; Paid National Holidays; Company-provided MacBook; Flexible Independent Contractor Agreement