Middle DBA / Database Engineer A distance Temps plein

Notre client :

A fast-growing product startup in the Video AI domain, collaborating with global publishers and broadcasters to enhance video content experiences at scale.

Vos tâches :

• Lead the overhaul of CTD’s database schema to support high-load and scalable systems.
• Manage the transition from MariaDB to PostgreSQL while ensuring low risk to production environments.
• Design and develop a reliable Data Access Layer (DAL) for consistent data interaction.
• Establish clear models for transaction handling and session management.
• Improve database performance through effective indexing strategies and partitioning techniques.
• Set up database governance policies along with performance guidelines and best practices.
• Analyze and align database performance with system-level resources such as CPU, memory, and I/O.
• Develop monitoring, observability, and diagnostic solutions to simplify troubleshooting.
• Work closely with R&D, Product, and Support teams to ensure smooth collaboration and delivery.

Expérience et compétences requises :

• 5+ years of experience as a Database Administrator (DBA).
• Strong practical experience working with MariaDB/MySQL and PostgreSQL.
• Proven track record of building and maintaining high-scale data systems.
• Expertise in query performance optimization, including advanced indexing and partitioning strategies.
• Deep understanding of transaction processing and concurrency control mechanisms.
• Hands-on experience handling high-throughput workloads and systems.
• Strong knowledge of data retention strategies and their implementation.
• English proficiency at Upper-Intermediate level or higher.

Ce serait un plus :

• Hands-on experience designing and implementing Data Access Layers (DAL).
• Proven experience migrating MySQL/MariaDB databases to PostgreSQL.
• Solid familiarity with Python and working with ORMs.
• Practical experience operating in on-premise environments.
• Experience using and implementing database observability and monitoring tools.