Database Performance Engineer
Há 14 horas
Brasil
BairesDev
Remoto
Tempo integral
Grátis com e-mail ou Google
Salve esta vaga e mantenha sua pesquisa organizada
Crie uma conta gratuita para salvar vagas, criar alertas e retornar a esta listagem a partir do seu painel.
Grátis com e-mail ou Google
Ao continuar, você concorda com nossos Termos & Política de Privacidade.
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
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