Serosoft - Team Lead - InnoDB / MyISAM

Description : About the Role :

Serosoft is seeking a Senior Database Developer / DBA Team Lead to lead and enhance our existing database team. The ideal candidate is a technically strong MySQL expert with a proven record in database design, optimization, replication, and administration, coupled with strong leadership and communication skills. You will play a key role in guiding the DBA team, analyzing current challenges, and implementing improvements that enhance performance, reliability, and productivity. You will also be expected to explore AI-driven insights or automation tools that can further optimize database management and efficiency.

Key Responsibilities :

• Lead, mentor, and manage the DBA team to ensure high productivity and collaboration.
• Design, architect, and maintain scalable, secure, and high-performing database systems.
• Create and maintain Entity Relationship Diagrams (ERDs) and Database Schemas.
• Write, review, and optimize complex SQL queries, stored procedures, triggers, and views.
• Perform query tuning, indexing, and performance profiling using advanced diagnostic tools.
• Manage MySQL replication setups (master-slave, GTID-based, group replication) and ensure data consistency.
• Perform routine database administration tasks, including backup / recovery, patching, capacity planning, and monitoring.
• Identify and address root causes of database performance issues and system bottlenecks.
• Plan and execute data migration between the customer and the Serosoft product databases.
• Evaluate and implement AI-based or automation tools for proactive monitoring, performance prediction, or query optimization.
• Collaborate cross-functionally with development, QA, and DevOps teams for smooth integrations.
• Continuously assess and improve database architecture to meet evolving business needs.

Education & Experience :

Skills :

Good to Have :

(ref : hirist.tech)