Database Optimization Intern

Pelico; Paris; Hybride; EUR 13 392 - 20 088; Plein temps

Avantages offerts par ce poste

Flexible, hybrid work model

Health, dental, and vision coverage

Work with world’s complex industrials

Résumé du poste

Pelico is seeking a database optimisation intern to monitor and enhance the performance of our multi-tenant databases handling 10M+ rows per database across several tenants.

You will improve alerting, address root causes, and implement improvements to underlying operations while learning in a fast-growing manufacturing orchestration platform. Pelico is headquartered in Paris with offices in Miami, London and Amsterdam, and we’re just getting started.

Qualifications

• Proficient in Python and PostgreSQL
• Know how to write efficient SQL and perform query optimization
• Familiar with AI-assisted workflows and eager to adopt new tools
• Experience with AI tools for writing, research, analysis, coding, or productivity

Responsabilités

• Optimize database queries using industry standard best practices
• Design and implement alerts within our alerting environment to catch flaws and disruptions
• Design, implement, and upkeep runbooks for alert management
• Contribute to our in-house data generation solution for internal dev testing

Connaissances

Python

PostgreSQL

SQL optimization

AI tools

AI-assisted workflows

Outils

Gitlab CI

Prometheus

Grafana

Description du poste

About Pelico

Traditional industrial manufacturing systems were built for predictability. Supply chains no longer are. Today, real-time data is buried in legacy tools that weren't designed for constant disruption. By the time an issue surfaces, it has already snowballed, sending everyone into firefighting mode. Pelico exists to close the gap between production plans and the daily reality on the factory floor.

About Pelico

Traditional industrial manufacturing systems were built for predictability. Supply chains no longer are. Today, real-time data is buried in legacy tools that weren't designed for constant disruption. By the time an issue surfaces, it has already snowballed, sending everyone into firefighting mode. Pelico exists to close the gap between production plans and the daily reality on the factory floor.

We've built the manufacturing orchestration platform trusted by the world's most complex industrial operations: companies like Airbus, Daikin, Safran, Eaton, and Cartier. Our algorithms connect fragmented supply chain, production, and quality data into a single live operational picture, then put AI agents to work anticipating disruptions, simulating recovery options, and keeping every team aligned before small problems become expensive ones.

Founded in 2019 and backed by General Catalyst, 83North, and Serena, we've raised $72M and are growing fast: 300% year-over-year revenue growth, deployed in 15+ countries, and supporting factories worldwide. We're headquartered in Paris, with offices in Miami, London and Amsterdam, and we're just getting started.

About The Role

We now run more than 30 tenants, each one with multiple databases, each database handling 10M+ rows (up to 100M+ soon on some tenants). In order for all our features to run smoothly for our customers, we need continuous monitoring and optimization of these dbs over different access patterns (intense ETL loads, complex analytical operations, normal transactional access).

As a database optimisation intern, you’ll continuously improve our alerting system (reducing false alerts to improve the system precision) as well as address any real issue by investigating the root cause, suggesting, negotiating and implementing improvements to the underlying operations.

What You'll Do

• Optimize database queries using industry standard best practices
• Design and implement alerts within our alerting environment to catch flaws and disruptions
• Design, implement, and upkeep runbooks for alert management
• Contribute to our in-house data generation solution for internal dev testing

Required

About You

• Knowledge in Python, and PostgreSQL (or any other alternative in SQL)
• Knowledge of industry standard database practices — Effective joins and query optimization for example
• You actively embrace AI tools as part of how you work — curious about what’s possible and quick to adopt new ways of working smarter and faster.
• Hands‑on experience with AI‑assisted workflows — whether for writing, research, analysis, coding, or productivity — and a genuine interest in staying at the frontier of what these tools can do.

Nice to have

• Knowledge in Rust and/or Kotlin
• Experience with Gitlab CI workflows
• Experience with monitoring tools such as Prometheus and Grafana

Why Pelico

• Competitive salary benchmarked to your market
• Flexible, hybrid work model — we care about output, not face time
• Health, dental, and vision coverage
• Opportunity to work with some of the world's most complex and fascinating manufacturing operations
• A team that takes the work seriously without taking themselves too seriously

Pelico is an equal opportunity employer. We're committed to building a diverse team and an inclusive environment where everyone can do their best work.