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.
