Seeking TimescaleDB expert for algorithmic trading database implementation

Special Interest Groups Finance & Crypto
1

Project Overview

I’m developing a sophisticated algorithmic trading system that requires an expert in TimescaleDB to design and implement the underlying database architecture. This is a serious project with clear requirements and specifications, not a hobbyist endeavor.

System Architecture

The system handles:

  • Multi-market data streams (US, EU)
  • Multiple asset classes (Index Futures, CFDs, Options, Stocks)
  • Various time intervals (5m, 15m, 1hr, 1day, 1wk, 1mth, 1yr)
  • Both OHLCV and tick data processing
  • UTC time synchronization
  • Continuous model rebuilding (every 5-15 mins)
  • Trading window management (30-45 mins)

Required Expertise

  • Strong PostgreSQL/TimescaleDB experience with financial market data
  • Experience with hypertables, chunk sizing, compression policies
  • Knowledge of automated retention strategies for high-frequency data
  • Real-time data handling with strict latency requirements
  • Performance optimization for time-series databases
  • Financial data integration experience

Deliverables

  • Complete database schema design
  • Query optimization for technical indicators and analysis
  • Data retention and archiving policies
  • Integration framework for external modules
  • Performance testing and tuning
  • Documentation and knowledge transfer

Selection Process

Qualified candidates will be asked to:

  1. Provide examples of previous financial data TimescaleDB implementations
  2. Share their approach to schema design for multi-timeframe market data
  3. Demonstrate experience with automated data retention policies
  4. Present a sample architecture for high-performance time-series processing

Project Scope

This begins as a proof-of-concept but is designed for production scalability from the start. The database architecture is modular and will integrate with proprietary trading modules I’ve developed.

Contact Information

If you have the necessary expertise and interest in this project, please respond with:

  • Your relevant experience with TimescaleDB and financial data
  • 2-3 examples of similar implementations (anonymized as needed)
  • Your approach to database schema design for this use case
  • Availability for an initial consultation

We can move to private communication for further details after initial discussion in this thread.

2 Likes
2

Hi @matthewteo I developed with my team https://www.stockintent.com/ is not based on timescale but has complex etl and algorithm logic in order to do what it does on sql level. I was advising easytraderapp at com about selection of proper database in problem domain of financial transactions, speed was important factor, we considered multiple database and in that as well Timescaledb. Recently I used timescaledb for rag project in the past to store and pre-process information fro IoT smart meters about electricity usage.

I have experience from many problem domains and IT roles like solutions architect, full-stack developer and dev-ops.

About db design and in general system design, I always start with problem domain recognition and flow diagrams, this allows me to understand project realm, define entities and relationships like as well to revel the relationships and tell what questions we try to answer with data.

You can reach on Timescale slack as Igor Miazek or [email protected]

Best,
Igor

3

Hi,
I worked as the Timescale consultant for a crypto asset-based lending facilitation company named Credora (https://www.credora.network/). Later I assisted another company implement Timescale to help their PostgreSQL implementation scale.
I have been working with relational databases from 1999, and with PostgreSQL from 2010. You could contact my at [email protected]
Regards,
Jayadevan