Database Performance Engineer (PostgreSQL) - Remote Work | REF#310221
BairesDev
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 experience with connection pooling solutions and extension\-level optimization for PostgreSQL. * Deep understanding of database internals, indexing strategies, and resource management. * Advanced proficiency in English. How we do make your work (and your life) easier: * 100% remote work (from anywhere). * Excellent compensation in USD or your local currency if preferred * Hardware and software setup for you to work from home. * Flexible hours: create your own schedule. * Paid parental leaves, vacations, and national holidays. * Innovative and multicultural work environment: collaborate and learn from the global Top 1% of talent. * Supportive environment with mentorship, promotions, skill development, and diverse growth opportunities. Join a global team where your unique talents can truly thrive and make a significant impact! Apply now!