PostgreSQL & TimescaleDB Expertise

Currently working as Staff Engineer at Bax Energy, I bring over 20 years of experience in database optimization and system architecture. As a former Developer Advocate at Timescale, I’ve developed deep expertise in PostgreSQL and TimescaleDB, specializing in performance tuning, scalability solutions, and time-series data optimization. Check out my resume to learn more about my background and expertise.

You can find my technical content in my posts on Timescale blog and watch my latest videos showing Typescript and Ruby libraries integrated in the ecosystem.

Areas of Expertise

✓ Database Performance Optimization

• Query optimization and performance tuning
• Index strategy and maintenance plans
• Partitioning and chunking strategies
• Memory and disk I/O optimization

✓ TimescaleDB Specialization

• Migration strategies
• Continuous aggregates design
• Compression policy optimization
• High-availability architecture

✓ Architecture & Scalability

• Database architecture patterns
• Scalability solutions
• Capacity planning
• High-availability design

Notable Work and Contributions

During my time at Timescale, I created the default timescaledb templates for finance and IoT.

As a long-time Rubyist, I’m also the creator of the timescaledb gem.

Technical Articles and Resources

I’ve written several articles on the official Timescale blog:

• Introduction to Real-Time Swap Analytics (May 2025)
  • Real-time trading analytics implementation
  • FIFO accounting with TimescaleDB
  • High-performance data processing patterns
• Downsampling in the Database: How Data Locality Can Improve Data Analysis
• Counter Analytics in Postgresql: Beyond Data Denormalization
• Building a Better Ruby ORM for Time Series and Analytics
• Adapting JSON Structures for Real-Time Aggregates: A Community Solution
• Supercharge Your AI Agents With PostgreSQL (Sep 2023)

Personal Projects and Research

• POC: Hierarchical Continuous aggregates implementing the persian calendar

• Benchmarking Ruby ORMs: ActiveRecord vs Sequel Performance with TimescaleDB (March 2025)
  • Comprehensive performance analysis
  • Integration patterns and best practices
  • Real-world optimization techniques
• Time Series Benchmark TimescaleDB Raspberry Pi
  • Performance analysis of PostgreSQL and TimescaleDB
  • Database tuning for optimal scalability
  • Real-world benchmarking methodology and results
• GitHub: github.com/jonatas