Ruby Labs

Senior Database Engineer

Ruby Labs

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇧🇪 Belgium

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AWSPostgres

About the role

  • 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)
  • - Advanced indexing (B-Tree, GIN, partial indexes)
  • - 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
  • - Vacuum / autovacuum issues
  • - Connection pool saturation
  • - 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

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
  • Nice to have
  • - Experience in payments, billing, fintech, or financial systems
  • - Familiarity with analytical databases (ClickHouse, Tinybird, or similar)
  • - 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: Embrace the freedom to work from anywhere, anytime, promoting a healthy work-life balance.
  • Unlimited PTO: Enjoy unlimited paid time off to recharge and prioritize your well-being, without counting days.
  • Paid National Holidays: Celebrate and relax on national holidays with paid time off to unwind and recharge.
  • Company-provided MacBook: Experience seamless productivity with top-notch Apple MacBooks provided to all employees who need them.
  • Flexible Independent Contractor Agreement: Unlock the benefits of flexibility, autonomy, and entrepreneurial opportunities. Benefit from tax advantages, networking opportunities, reduced employment obligations, and the freedom to work from anywhere.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
PostgreSQLtable partitioningadvanced indexingquery optimizationexecution-plan tuningdata integrityschema designdata modelingperformance tuningdisaster recovery
Soft skills
problem-solvingindependent investigationanalytical thinkingcollaborationcommunication
Certifications
AWS Solutions ArchitectAWS Database Specialty