You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Romain C.RC

Romain C.

Expert PostgreSQL & Backend Performance | Audit DB

€500/day
2 projects
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Romain

I specialize in PostgreSQL optimization, backend performance, and scalability for high-volume data applications.

Currently working as a DevSecOps in an environment where cybersecurity, reliability, and technical rigor are central, I am looking for targeted freelance missions, about 1 to 2 days a week, on performance, database, and scaling issues.

I help teams facing concrete scalability problems: PostgreSQL databases that can no longer handle the load, slow queries, poorly adapted indexes, lack of observability, oversized tables, load peaks, or backend architecture that is difficult to evolve.

My approach generally begins with setting up or improving observability to precisely identify performance issues. Based on these measurements, I can propose and implement concrete improvements: query analysis, indexing strategy, SQL rewriting, partitioning, TimescaleDB, backend processing optimization, setting up queues/workers, and architecture improvement.

This expertise comes notably from my experience at Fantasy, where I worked on scaling an application from about 1,000 users to over 100,000. I contributed significantly to PostgreSQL/TimescaleDB and backend optimization, with over 8 months focused on performance, data volume, SQL queries, and database scalability.

I can work on an existing application that is starting to show its limits, as well as on a new project with high performance stakes from the outset.

🎓 Graduated with a Master's in Cybersecurity from the University of Kent and a degree in Information Technology Expertise from Epitech, I combine a solid security culture with a practical approach to backend architecture, performance, and production operations.
  • French

    Native or bilingual

  • English

    Native or bilingual

Can work on-site
Paris (up to 50km)

Experience

  • Fantasy.top
    Backend Engineer / DevOps — Data & Platform Systems
    PRIVATE EQUITY
    March 2024 - December 2025 (1 year and 9 months)
    Lisbonne, Portugal
    Joined during mainnet launch and contributed to rapid scaling from ~1K to over 100K users during peak activity.
    • Designed and operated a high-throughput Twitter data indexing pipeline processing hundreds of millions of daily events.
    • Built anti-botting systems protecting engagement metrics and game mechanics from automated abuse (Python, panda).
    • Contributed to backend refactor from Hasura to NestJS REST APIs, improving business-logic control and observability.
    • Developed core backend features including leaderboards, ranking systems, and modular ELO-based gamification logic.
    • Implemented Cloudflare caching and backend cache-control strategies to reduce latency and offload backend traffic on low-volatility endpoints.
    • Led backend performance and reliability improvements focused on ingestion throughput and queue stability.
    Performance & scaling:
    • Optimized PostgreSQL and TimescaleDB ingestion workloads (~300M daily insert/update ops, ~3,200 TPS).
    • Introduced staging tables and bulk COPY pipelines, reducing WAL contention and I/O pressure.
    • Migrated high-volume tables to TimescaleDB hypertables with compression, reducing storage and IOPS by ~50%.
    • Implemented monitoring with PMM and pg_stat; continuously tuned queries, indexes, and schema design.
    • Stabilized platform under ~17K IOPS, avoiding a planned ~$10K/ month infrastructure upgrade.
    Tech: TypeScript, Python, panda, Node.js, NestJS, PostgreSQL, TimescaleDB, Redis, Docker, AWS, Cloudflare, CI/CD
    Typescript Python Pandas Node.js PostgreSQL
  • Junior Conseil Taker
    Fullstack Developer
    TECH
    December 2021 - December 2024 (2 years and 11 months)
    Frontend Development (Next js) of a web application in the medical field for a foreign country.

    Frontend Development (Next Js) of a web application in the agricultural field with the EU.
    Link to website v1: https://logipre.org/
    Frontend Development Web Integration Next.js React.js Goland
  • Proovup
    Back-End Developer
    May 2023 - June 2023 (1 month)
    • Designed an optimized TypeScript microservice for aircraft flight load management at MetaFlight, handling 1–5K simultaneous aircraft in real time.
    • Implemented Redis caching, Socket.io updates, and a queuing system to reduce database load.
    • Ensured strong security with JWT and API key authentication, comprehensive documentation, and seamless integration within the company's infrastructure.
    Typescript PostgreSQL Redis Socket.io

Reviews

5.0

Out of 2 ratings

SébastienS

Sébastien

NITBY

Reviewed on 2/5/2024

We called on Romain for his cybersecurity skills on AWS. We needed to activate AWS WAF. Romain advised us perfectly and delivered in a few days. We now keep him as our cyber expert. We highly recommend him.
D

Déborah

Gilbert

Reviewed on 6/14/2022

Great experience! Romain is junior but very reliable: he asks (and asks himself) the right questions, works quickly and well... He evolved our specific node.js plugin, which is not always easy to work on after another developer, and it went much faster than expected. In short, I highly recommend him and will not hesitate to call on him again.

Recommendations

HH
Antoine BoussionAB
Hamza Hammouche and 1 other person have recommended Romain

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Expert in Information Technology
    Epitech Lyon
  • Master's degree in Cyber Security (certified by GCHQ, the UK government intelligence and security agency)
    University of Kent
    Domains of study: - Authentication, Authorization, Security Accounting - Cryptography (Rsa, Homomorphic encryption) - Network security - Information security - Privacy (K-anonymity, l-diversity, T-closeness)

Certifications

Skill set

Categories