GB
Resume
Database Engineer - PostgreSQL & Performance Specialist • Brazil

PostgreSQL performance.
Reliability and scale in production.

I design, optimize and scale production-grade database systems focused on performance, reliability and low-latency data pipelines.

Database Engineer with 5+ years in relational databases, specialized in PostgreSQL performance tuning and query optimization. Hands-on with AlloyDB and CloudSQL on GCP, with strong focus on execution plan analysis, indexing strategy, statistics tuning, lógical replication, and production reliability.

Discuss a ProjectDownload Resume
Portrait of Gustavo Badalotti

5+ years

Relational database engineering experience

70%

Reduction in critical query execution time

<1s

Logical replication latency target in production

Millions

PostgreSQL records processed through ETL to Elasticsearch

Core capabilities

How I engineer high-performance database systems

Database Performance Engineering

Deep execution plan analysis, SQL refactoring, index strategy redesign, scan-path optimization, statistics tuning, and lock/deadlock diagnostics.

Lower latency, more predictable throughput, and faster query paths in production workloads.

Data Infrastructure

Design of lógical replication flows, failover-aware data topology, and Python ETL services connecting PostgreSQL and Elasticsearch.

Reliable, low-latency data movement with consistent structures for downstream search and analytics.

Observability and Monitoring

Datadog dashboards and alerts for replication lag, slow query behavior, and performance degradation signals.

Faster anomaly detection and tighter feedback loops for production database operations.

Cloud Databases on GCP

Hands-on operation with AlloyDB, CloudSQL, and BigQuery in production-grade managed environments.

Balanced cost, scalability, and performance characteristics for cloud database workloads.

Selected work

Case studies from production environments

Examples based on real production initiatives focused on latency, consistency, and reliability.

Investigated high-cost plans, identified missing and inefficient indexes, and refactored critical SQL paths to lower latency and improve overall system responsiveness.

QO

Query Optimization Initiative

Performance Engineering

Execution Plans • Indexing • Statistics

Implemented lógical replication with sub-second targets, maintaining near real-time data consistency while monitoring lag and failure scenarios in production.

LR

Logical Replication Architecture

Data Infrastructure

Low-Latency Replication • Reliability

Designed extraction queries, built Python transformation layers, and indexed structured data into Elasticsearch to improve search capabilities and query performance.

PT

PostgreSQL to Elasticsearch Pipeline

ETL & Search Infrastructure

Python ETL • Custom Mappings

Applied a structured debugging approach for degradation incidents, including lock and blocking analysis, plan regression checks, statistics recalibration, and replication lag mitigation.

PI

Production Incident Playbook

Troubleshooting & Recovery

Lock Analysis • Plan Regression • Lag Triage

Career timeline

Hands-on database and data platform experience

Database Engineer / SQL Developer

Nursa

2022 - Present

Brazil

Managing and optimizing PostgreSQL and AlloyDB production workloads with emphasis on low latency, reliability, and incident readiness.

  • Reduced execution time of critical queries by up to 70% through execution plan analysis, refactoring, and indexing strategy redesign.
  • Designed lógical replication flows with near real-time consistency and continuous lag monitoring.
  • Built Python ETL pipelines integrating millions of PostgreSQL records into Elasticsearch.
  • Created Datadog dashboards and alerts for replication behavior and database performance.
  • Acted directly in production incident investigation, mitigation, and long-term stability improvements.
PostgreSQLAlloyDBCloudSQLPythonETLElasticsearchDatadogGCP

Database Developer

ECS Inovação

2021 - 2022

Brazil

Maintained enterprise SQL Server environments with focus on stability, automation, and query performance for reporting workloads.

  • Developed and maintained T-SQL procedures for business-critical data operations.
  • Improved reporting performance with targeted query and schema-level optimizations.
  • Expanded automation routines to increase database consistency and operational predictability.
SQL ServerT-SQLAutomationPerformance Tuning

Software Developer

System Sistemas de Gestão

2017 - 2021

Brazil

Delivered ERP features and reporting routines in Delphi and SQL Server, supporting day-to-day performance and troubleshooting in production environments.

  • Implemented ERP modules connected to transactional SQL Server workloads.
  • Designed reporting queries and integration routines for cross-system data usage.
  • Provided direct database troubleshooting and performance support for production teams.
DelphiSQL ServerERPData Integration

Technical stack

Database, performance, ETL, and cloud operations

Databases

PostgreSQLAlloyDBCloudSQLSQL Server

Performance Engineering

Execution Plan AnalysisIndexing StrategiesStatistics TuningQuery OptimizationLock and Deadlock Analysis

Data Engineering

PythonETL PipelinesElasticsearch

Observability and Cloud

DatadogMonitoring and AlertsGoogle Cloud PlatformBigQueryProduction Incident Handling

Languages

  • Portuguese (Native)
  • English (Fluent)

Open to opportunities

Let us optimize your data layer

Available for Database Engineer and PostgreSQL performance roles, especially in production-critical and low-latency environments.

WhatsAppgustavo_badalotti@hotmail.com+55 54 99133-2950LinkedIn ProfileGitHub