Database Engineer (PostgreSQL, AWS Aurora)

TL;DR

Database Engineer (PostgreSQL, AWS Aurora): Designing, operating, and optimizing databases for a high-volume payments orchestration system with an accent on scalability, query performance, and reliability. Focus on evolving schemas for massive tables, preventing performance regressions, and enabling analytics/search pipelines for internal CRM and observability.

Company

hirify.global builds and operates consumer products and a high-scale payments orchestration platform.

What you will 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 partitioning strategies and advanced indexing; tune query execution plans.
• Analyze and resolve performance issues (slow queries, lock contention, vacuum/autovacuum, connection pool saturation).
• Build high-performance search for large operational datasets used in internal CRM tools.
• Work with event/log pipelines and analytics stores (Tinybird/ClickHouse), deciding what belongs in transactional vs analytical systems.

Requirements

• Location/time zone: Applicants must be located within approximately ±4 hours of CET.
• Strong hands-on production experience with PostgreSQL.
• Experience managing large databases (hundreds of millions of rows or more).
• Solid understanding of indexing, query planners/execution paths, and transactions (isolation levels, locking).
• Experience with AWS 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) and/or OpenSearch with ingestion from PostgreSQL.
• Experience designing data models for multi-tenant systems and working with event-driven architectures/data pipelines.
• AWS certifications (e.g., Solutions Architect, Database Specialty).

Culture & Benefits

• Fully remote engineering organization with CET-aligned collaboration.
• Unlimited PTO and paid national holidays.
• Company-provided MacBook for employees who need it.
• Flexible independent contractor agreement option (tax and autonomy benefits) in addition to employment.

Hiring process

• Recruiter screening (40 minutes).
• Technical interview (60 minutes).
• Final interview (60 minutes).