Senior Database Engineer (PostgreSQL)

TL;DR

Senior Database Engineer (PostgreSQL): Owning, scaling, and evolving data infrastructure for high-volume payments, focusing on fast, reliable, and scalable database systems. Focus on designing robust schemas, optimizing complex queries, managing large datasets, and ensuring data integrity and consistency for transactional and analytical workloads.

Location: Remote. Applicants must be located within approximately ± 4 hours of CET.

Company

hirify.global is a leading tech company that creates and operates innovative consumer products across health, education, and entertainment industries.

What you will do

• Own and operate AWS Aurora (PostgreSQL) in a high-load production environment, designing and evolving schemas for large transactional domains.
• Implement and maintain table partitioning, advanced indexing, and query optimization, handling databases with millions of new records monthly.
• Analyze and optimize slow queries, identify and resolve performance bottlenecks like lock contention and vacuum issues.
• Design high-performance search solutions for large operational datasets used in internal CRM tools.
• Work with event and log data pipelines (e.g., Tinybird / ClickHouse) to enable fast, real-time insights for product, finance, and operations.
• Ensure data integrity and consistency in financial workflows, define health metrics, and execute safe schema changes.

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, 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.
• English: B2 required.

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.

Culture & Benefits

• Remote Work Environment with freedom to work from anywhere.
• Unlimited Paid Time Off (PTO) and paid national holidays.
• Company-provided MacBook for seamless productivity.
• Flexible Independent Contractor Agreement offering autonomy and entrepreneurial opportunities.
• Opportunity for personal and professional growth within a fast-growing team.

Hiring process

• Application review (3-5 days).
• Recruiter Screening (40 minutes).
• Technical Interview (60 minutes).
• Final Interview (30 minutes).