Database Performance Engineer (PostgreSQL) - Remote Work | REF#299665

BairesDev

Perú

Teletrabalho

PEN 307 000 - 444 000

Tempo integral

há 19 horas
Torna-te num dos primeiros candidatos

Uma candidatura completa num minuto

Currículo e carta de apresentação personalizados, prontos a enviar.

Ultrapassa os filtros ATS

Vantagens oferecidas por esta oferta de emprego

100% remote work
USD or local currency compensation
Home office setup provided
Flexible hours
Paid parental leaves
Multicultural environment
Mentorship and growth opportunities

Resumo da oferta

BairesDev is a global technology company delivering cutting-edge solutions to giants like Google and startups worldwide. We are seeking a Database Performance Engineer (PostgreSQL) to optimize high-traffic data systems, ensuring sub-second query times and high availability.

You will dive into query plans with EXPLAIN ANALYZE, tune autovacuum, adjust memory and indexing, and collaborate with teams to enforce SQL best practices.

Qualificações

  • 4+ years in Database/Performance/Software Eng.
  • Proven PostgreSQL performance tuning expertise.
  • English proficiency (advanced)

Responsabilidades

  • Analyze query plans with EXPLAIN ANALYZE to locate performance hotspots.
  • Tune autovacuum to prevent table bloat and manage I/O.
  • Adjust PostgreSQL configurations and memory settings to match workloads.
  • Develop indexing and partitioning strategies to speed data retrieval.
  • Implement connection pooling and session management for throughput.
  • Collaborate with engineering teams on SQL best practices and scalable design.

Conhecimentos

PostgreSQL tuning
Query plan analysis
Vacuum optimization
EXPLAIN ANALYZE
pg_stat views
Connection pooling
Indexing strategies
English proficiency

Ferramentas

pg_stat_statements
PostgreSQL extensions
Connection pooling tools

Descrição da oferta de emprego

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!

Obtém a tua avaliação gratuita e confidencial do currículo.

ou arrasta e larga o ficheiro aqui.

Similar jobs

Ofertas semelhantes que vale a pena comparar

Database Engineer (Ops) - Remote work | REF#308792
Database Engineer (Ops) - Remote work | REF#308792

BairesDev • Arequipa

Teletrabalho
PEN 207 000 - 310 000
Remote work
USD or local currency compensation
Home office setup
+4
DBA - Remote work | REF#308788
DBA - Remote work | REF#308788

BairesDev • Arequipa

Teletrabalho
PEN 208 000 - 416 000
Remote work
USD salary
Home setup
+3
Cloud Performance Engineer - Remote Work | REF#308488
Cloud Performance Engineer - Remote Work | REF#308488

BairesDev • Cajamarca

Teletrabalho
PEN 207 000 - 276 000
Remote work
Competitive compensation in USD or USD
Home setup provided
+5
Data Engineer (BigQuery & Snowflake) - Remote Work | REF#310974
Data Engineer (BigQuery & Snowflake) - Remote Work | REF#310974

BairesDev • Cajamarca

Teletrabalho
PEN 307 000 - 444 000
100% remote
USD or local currency pay
Hardware provided for home setup
+4
Backend Engineer (Python & Presto) - Remote Work
Backend Engineer (Python & Presto) - Remote Work

BairesDev • Lima Metropolitana

Teletrabalho
PEN 307 000 - 478 000
100% remote work
Excellent compensation in USD or local
Hardware and software setup for home
+4
Client-Facing Staffing Analyst - Remote Work | REF#301468
Client-Facing Staffing Analyst - Remote Work | REF#301468

BairesDev • Cajamarca

Teletrabalho
PEN 155 000 - 259 000
100% remote work
Competitive USD compensation or local
Hardware and software setup for remote
+3
Senior Business Intelligence Engineer - Remote Work | REF#301367
Senior Business Intelligence Engineer - Remote Work | REF#301367

BairesDev • Cajamarca

Teletrabalho
PEN 414 000 - 552 000
Remote work
Competitive USD salary
Equipment provided
+4
Backend Engineer (Node.js + JavaScript) - Remote Work | REF#298043
Backend Engineer (Node.js + JavaScript) - Remote Work | REF#298043

BairesDev • Lima Metropolitana

Teletrabalho
PEN 307 000 - 512 000
100% remote
Hardware and software setup for home
Flexible hours
+2
Java/Python Backend Developer - Remote work | REF#302901
Java/Python Backend Developer - Remote work | REF#302901

BairesDev • Cajamarca

Teletrabalho
PEN 309 000 - 481 000
Remote work (100%)
USD or local currency compensation
Hardware provided
Senior Ruby Engineer - Remote Work | Ref#306403
Senior Ruby Engineer - Remote Work | Ref#306403

Bairesdev • Cajamarca

Teletrabalho
PEN 207 000 - 311 000
100% remote work
Competitive USD compensation
Hardware provided