PostgreSQL Expert for NinjaTrader Sync and Database Build

Job ID: 40026539

Budget: €3,000 – €5,000 EUR

Data Engineer Needed — Build & Sync a Level 1 Tick Database With NinjaTrader 8

Project Type: Fixed-price
Long-term work available after successful delivery
Application window: One week to apply, one week to select the ideal candidate

Before You Apply
I’ve had several freelancers promise they could deliver this exact project. Every one of them failed.
I had to request refunds repeatedly.

You might be thinking: if multiple engineers failed, maybe the scope is unclear—or maybe this client is impossible to satisfy. Those are fair concerns. I've asked myself the same questions. If you've built systems where a single misaligned broke, you know the consequences it has downstream.

Let me be direct.
I know exactly what the end result must look like, and I immediately recognize whether someone understands the problem or is improvising.

To avoid wasting your time and mine, the selection process is designed to filter out amateurs and highlight true experts.

If you require specific files, formats, schema samples, or reference data to evaluate whether you are suitable for this job, I will provide them as long as it is technically possible and within my reach.
I want you to make an informed assessment before committing, and I am willing to supply whatever is necessary to support that.

The Job
Build a clean, scalable, perfectly synchronized PostgreSQL tick database, fully aligned with NinjaTrader 8 historical and live data.
The system must also support adding NinjaTrader Market Replay files later if needed.

If the data is wrong, the strategy fails.
This is precision-critical work.

What You Will Build
1. Production-Ready PostgreSQL Time-Series Database

Tick schema
1 index for millisecond accuracy
High-performance architecture optimized for analytics

2. Automated ETL Pipeline for Portara Tick Files

batch-insert architecture
Deduplication and timestamp normalization
Ability to append new datasets without drift

3. NinjaTrader 8 Synchronization Layer

You will ensure alignment between:

Portara tick data
NinjaTrader 8 Market Replay data

You will build a synchronization validator that:

Compares tick sequences and timestamps
Generates a clear pass/fail sync report
Identifies divergence causes with precision

4. Fully Repeatable Pipeline

The system must support continuous ingestion without breaking structure, performance, or synchronization.

Who I Am Looking For

You are a match if you:

Have deep experience with data ingestion
Understand NinjaTrader 8’s data mechanics
Can build clean, scalable PostgreSQL systems
Care about precision, validation, and auditability
Communicate technical reasoning clearly
Deliver correct results the first time

If a 1-millisecond timestamp mismatch bothers you, this project will suit you.

Required Skills

PostgreSQL
Python
Tick-level modeling
ETL engineering
Ability to explain reasoning clearly
Understanding of NinjaTrader 8 is a strong advantage

What I Expect in Your Application (Non-Negotiable)

To avoid repeating past failures, your proposal must include:

1. A clear explanation of HOW you will execute the job

Not a generic offer.
Not a list of tools.
Not a recycled cover letter.

I need to see your reasoning and workflow:

Your A-to-Z plan
How you validate tick integrity
How you guarantee NinjaTrader parity
How you handle format discrepancies
How you design the schema
How you benchmark ingestion speed
How you maintain sync over time

You do not need to reveal proprietary techniques.
I simply want proof that you understand the terrain.

If you require sample data, replay files, screenshots, or structural examples to refine your plan, I will provide them when possible.

2. Estimated timeline and fixed-price bid

Time duration and price in this post is an indication, in the end you decide the price and timeline that reflects your expertise.

Questions to answer in your proposal

What do you see as the biggest technical risk in this project, and how would you mitigate it?
What would be unreasonable for me to expect from a tick-sync solution?
Is there any hidden risk you believe I may not be aware of?

Your answers reveal how you think and whether you understand the real challenges.

Why This Project Matters

This database becomes the single source of truth for my trading operations.
If the data is inaccurate, every downstream system fails.

This requires someone who treats the work as a mission:
calm, precise, structured, and fully accountable.

Compensation

Fixed-price contract
Performance bonus for flawless delivery
Guaranteed long-term work for the engineer who proves reliable

How to Apply

Include in your application:

A concise introduction
Your A-to-Z plan for achieving perfect sync
Your fixed-price bid and time duration
Your answers to the questions

I will review every proposal within the next week and contact selected candidates the week after.
Only applicants who clearly explain their methodology will be considered.