Senior Database Engineer (PostgreSQL, Aurora)

Ruby Labs is a leading tech company creating and operating innovative consumer products across health, education, and entertainment industries.

• Strong hands-on experience with PostgreSQL in production
• Experience managing large databases with hundreds of millions of rows or more
• Solid understanding of indexing strategies, query planners and execution paths, transactions, isolation levels, and locking
• Experience with AWS infrastructure, ideally with 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 such as ClickHouse and Tinybird
• 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 such as payments, customers, subscriptions, and events
• Implement and maintain table partitioning strategies (time-based, tenant-based, hybrid)
• Implement advanced indexing (B-Tree, GIN, partial indexes)
• Optimize queries and execution plans
• Handle databases with millions of new records monthly while maintaining predictable performance

Performance Optimization:

• Analyze and optimize slow queries and production metrics
• Identify and resolve lock contention, vacuum/autovacuum issues, connection pool saturation, and 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 balancing flexibility, correctness, and performance at scale

Analytics & Logging:

• Work with event and log data pipelines, including Tinybird/ClickHouse-based analytics
• Decide data allocation between transactional databases and 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 with backups, replication, and disaster-recovery strategies

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