Database Engineer (PostgreSQL)

Ruby Labs is a leading tech company that creates and operates innovative consumer products across the health, education, and entertainment industries.

• 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

Strong Plus:

• 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)

Database Ownership & Scalability:

• 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)
• Optimize queries and execution plans
• Handle databases with millions of new records per month while maintaining performance

Performance Optimization:

• Analyze and optimize slow queries and production metrics
• Identify and resolve lock contention, vacuum/autovacuum issues, connection pool saturation, long-running or inefficient queries
• Proactively prevent performance regressions as data volume grows

Search & Internal Tools:

• 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

Analytics & Logging:

• 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

Reliability & Operations:

• 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

Applicants must be located within approximately ± 4 hours of the Central European Time (CET) zone for optimal collaboration and communication during working hours.