Skip to main content
Ruby Labs
Ruby Labs

Senior Database Engineer (PostgreSQL, Aurora)

RemoteUkraine only· UTC-3…UTC+5
Published
Role
Data Engineering
Experience
Senior
Employment
Contract
Salary not disclosed
Check eligibility

Open to UA only · UTC-3…UTC+5. Set where you work from to check your eligibility.

No BS summary

Senior Database Engineer with strong hands-on PostgreSQL and AWS Aurora experience, proven at scaling large transactional databases. Needs deep skills in partitioning, indexing, query optimisation and production performance troubleshooting. Must be located within approximately ±4 hours of CET.

Core skills

PostgreSQLAWS AuroraQuery optimization

Required skills

SQLTable partitioningB-TreeGINPartial indexesExecution plan tuningVacuum/autovacuumConnection pool managementTransactionsIsolation levelsLock contention resolutionBackupsReplicationDisaster recovery

Optional skills

ClickHouseTinybirdOpenSearchPayments / billing / fintech experienceMulti-tenant data model designEvent-driven architecturesAWS certifications

What you'll do

  • 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)
  • Implement and maintain advanced indexing (B-Tree, GIN, partial indexes)
  • Implement and maintain 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
  • Identify and resolve vacuum / autovacuum issues
  • Identify and resolve connection pool saturation
  • Identify and resolve 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

What they require

  • Strong hands-on experience with PostgreSQL in production
  • Experience managing large databases (hundreds of millions of rows or more)
  • Solid understanding of indexing strategies
  • Solid understanding of query planners and execution paths
  • Solid understanding of 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 (strong plus)
  • Familiarity with analytical databases (ClickHouse, Tinybird, or similar) (strong plus)
  • Familiarity with OpenSearch or similar, including data ingestion from PostgreSQL (strong plus)
  • Experience designing data models for multi-tenant systems (strong plus)
  • Understanding of event-driven architectures and data pipelines (strong plus)
  • AWS certifications (e.g., Solutions Architect, Database Specialty) (strong plus)

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. Read more about it here: https://docs.google.com/document/d/1nkrN76JlZkbKj9WSOhlT1_mni_CZeDkHdwfIjPXVwvk/preview?tab=t.0#heading=h.ndsdl4wapxtt

Ruby Labs is a technology company creating innovative products in health, education, and entertainment sectors.

TechnologyMid-size
Salary not disclosed