Ruby Labs

Senior Database Engineer

Ruby Labs

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇲🇩 Moldova

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
  • Analyze and optimize slow queries and production metrics
  • Design high-performance search solutions for large operational datasets used in internal CRM tools
  • Work with event and log data pipelines, including Tinybird / ClickHouse-based analytics
  • Ensure data integrity and consistency in financial workflows
  • Participate in incident analysis related to data performance or availability

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 integritydata consistencyperformance analysisdata modelingevent-driven architecture
Soft skills
problem-solvingindependent investigationanalytical thinking
Certifications
AWS Solutions ArchitectAWS Database Specialty