ruby-labs - Database Engineer
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 • 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) • Ruby Labs operates within the CET (Central European Time) zone. Applicants from any country are welcome to apply for the position as long as they are located within approximately ± 4 hours of CET. This ensures optimal collaboration and communication during working hours.
Responsibilities
• 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) • 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 / 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
Benefits
• Discover the perks of being part of our vibrant team! We offer: • 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. Read more about it here: https://docs.google.com/document/d/1nkrN76JlZkbKj9WSOhlT1_mni_CZeDkHdwfIjPXVwvk/preview?tab=t.0#heading=h.ndsdl4wapxtt • Be part of our fast-growing team and seize this excellent opportunity for personal and professional growth!
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT