Senior Database Engineer

Location: Quarto d'Altino

About Us
Ruby Labs is a leading tech company that creates and operates innovative consumer products. We offer a diverse range of opportunities across the health, education, and entertainment industries. Our innovative teams are driving the future of consumer‑led products, and we're always looking for passionate individuals to join us. Learn more about our story at:
About

The Role
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.
As a Database Engineer at Ruby Labs, 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.
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 Ruby Labs work on real scale, real money, and real impact.

Key Responsibilities
Database Ownership & Scalability

Own and operate AWS Aurora (Postgre

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

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 / Click House‑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

Qualifications

Strong hands‑on experience with Postgre

SQL 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 (Click House, 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)

How You Think & Work

You think in terms of scale, growth, and long‑term impact
You care deeply about correctness, performance, and reliability
You’re proactive — you identify problems before they become incidents
You’re comfortable owning critical infrastructure components
You communicate clearly and collaborate effectively in a remote environment

Location
Ruby Labs operates within the CET (Central European Time) zone. Applicants from any country…