Our Customer:
A fast-growing product startup in the Video AI domain, collaborating with global publishers and broadcasters to enhance video content experiences at scale.
Your Tasks:
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.
Required Experience and Skills:
4+ 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.
Would Be a 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.
