Senior Database Engineer
Ruby Labs
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇦 Ukraine
Visit company websiteJob 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
- Work with event and log data pipelines, including Tinybird / ClickHouse-based analytics
- Ensure data integrity and consistency in financial workflows
- Define and monitor database health metrics (latency, replication lag, storage, IOPS)
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
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 integrityperformance regression preventionsearch solutions designevent data pipelineslog data pipelines
Soft skills
problem-solvingindependent investigationperformance issue resolution