Database Engineer

Ruby Labs

1d•Remote

About The Position

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. This role goes far beyond basic CRUD operations — you will work with large datasets, complex queries, performance bottlenecks, migrations on massive tables, and analytics pipelines. You will collaborate closely with backend engineers and product teams to ensure our data layer supports both transactional workloads and analytical use cases, including internal CRM search and observability.

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
Solid understanding of query planners and execution paths
Solid understanding of transactions, isolation levels, and locking
Experience working with AWS-based infrastructure, ideally AWS Aurora
Ability to independently investigate and resolve complex performance issues

Nice To Haves

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)

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 (time-based, tenant-based, hybrid)
Implement and maintain advanced indexing (B-Tree, GIN, partial indexes)
Implement and maintain query optimization and execution-plan tuning
Handle databases with millions of new records per month while maintaining predictable performance
Analyze and optimize slow queries and production metrics
Identify and resolve lock contention
Identify and resolve vacuum / autovacuum issues
Identify and resolve connection pool saturation
Identify and resolve long-running or inefficient queries
Proactively prevent performance regressions as data volume grows
Design high-performance search solutions for large operational datasets used in internal CRM tools
Implement efficient search strategies
Balance flexibility, correctness, and performance at scale
Work with event and log data pipelines, including Tinybird / ClickHouse-based analytics
Decide which data belongs in transactional databases vs analytical stores
Enable fast, real-time insights for product, finance, and operations teams
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 in backups, replication, and disaster-recovery strategies