At BairesDev®, we've been leading the way in technology projects for over 15 years. We deliver cutting-edge solutions to giants like Google and the most innovative startups in Silicon Valley.

Our diverse 4,000+ team, composed of the world's Top 1% of tech talent, works remotely on roles that drive significant impact worldwide.

When you apply for this position, you're taking the first step in a process that goes beyond the ordinary. We aim to align your passions and skills with our vacancies, setting you on a path to exceptional career development and success.

Database Performance Engineer (PostgreSQL) at BairesDev

As a Database Performance Engineer specializing in PostgreSQL, you will serve as a deep technical expert focused on optimizing the efficiency and reliability of our data systems. You will play a critical role in ensuring sub-second query times and high availability by identifying and resolving bottlenecks within complex, high-traffic database environments.

What You'll Do





Conduct deep-dive query plan analysis using EXPLAIN ANALYZE to identify and resolve performance hotspots.
Fine-tune PostgreSQL autovacuum parameters and maintenance tasks to prevent table bloat and manage disk I/O.
Optimize database configurations and memory settings, such as shared buffers and work_mem, to align with workload requirements.
Design and implement advanced indexing strategies and partitioning schemes to improve data retrieval speeds.
Implement connection pooling and session management strategies to enhance overall system throughput.
Collaborate with engineering teams to establish SQL best practices and ensure scalable database design.

What We Are Looking For

4+ years of experience in Database Engineering, Performance Engineering, or Software Engineering.
Proven expertise in PostgreSQL performance tuning, query plan analysis, and vacuum optimization.
Proficiency in using EXPLAIN ANALYZE and pg_stat views to diagnose and resolve performance bottlenecks.
Hands-on experie

📌 Database Performance Engineer (Perú)
🏢 Bairesdev
📍 Perú