Serosoft - Team Lead - InnoDB/MyISAM

5 days ago

Indore, Madhya Pradesh, India Serosoft (Academia): World's Fastest-growing Student Information System Company Full time ₹ 8,00,000 - ₹ 12,00,000 per year

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

  • Bachelors or Masters degree in Computer Science, Engineering, or a related field.
  • Minimum of 5+ years of experience as a MySQL Database Developer or DBA.
  • Proven experience in leading or mentoring a DBA/development team.

Skills

  • Strong proficiency in MySQL database management, architecture, and optimization.
  • In-depth knowledge of MySQL replication, backup/recovery strategies, and high availability setups.
  • Experience in query execution plans, indexing strategies, and performance profiling tools.
  • Understanding of MySQL storage engines (InnoDB, MyISAM) and partitioning.
  • Familiarity with AI concepts and tools relevant to database optimization or predictive analytics.
  • Knowledge of resource planning, data modeling, and query optimization best practices.
  • Experience with other SQL/NoSQL databases (PostgreSQL, MongoDB, etc.).
  • Hands-on experience with version control (Git/SVN) and CI/CD database deployment

Good To Have

  • Knowledge of PL/SQL and scripting (Python/Shell) for automation.
  • Familiarity with cloud database environments (AWS RDS, Azure SQL, Google Cloud SQL).
  • Exposure to AI/ML-based database monitoring or optimization tools.

)

  • Serosoft - Senior Database Developer - MyISAM/InnoDB

    5 days ago

    Indore, Madhya Pradesh, India Serosoft (Academia): World's Fastest-growing Student Information System Company Full time ₹ 8,00,000 - ₹ 16,00,000 per year

    DescriptionAbout the Role :Serosoft is seeking a Senior Database Developer 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...

  • Senior Database Developer

    7 days ago

    Indore, Madhya Pradesh, India Serosoft (Academia): World's Fastest-growing Student Information System Company Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    Job Location: IndoreExperience: 5+ yearsAbout 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...

  • Serosoft - Project Consultant - ERP Implementation

    2 weeks ago

    Indore, Madhya Pradesh, India SEROSOFT SOLUTIONS PRIVATE LIMITED Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Description : We are looking for a Project Consultant who will be responsible for managing and delivering successful ERP implementations for educational institutions. The ideal candidate will have strong functional knowledge, excellent project execution capabilities and a customer-first mindset to ensure smooth client onboarding and system...

  • Serosoft - Senior Software Engineer - Java

    2 weeks ago

    Indore, Madhya Pradesh, India SEROSOFT SOLUTIONS PRIVATE LIMITED Full time ₹ 10,00,000 - ₹ 25,00,000 per year

    About the Role : We are seeking a highly skilled Senior Software Engineer (Java) to join our team. In this role, you will design, develop, and deliver robust, scalable, and high-quality Java-based applications. You will play a key role in ensuring technical excellence, collaborating with cross-functional teams, and contributing to the overall...

  • Serosoft - Project Consultant - ERP Implementation

    2 weeks ago

    Indore, Madhya Pradesh, India Serosoft (Academia): World's Fastest-growing Student Information System Company Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    DescriptionWe are looking for a Project Consultant who will be responsible for managing and delivering successful ERP implementations for educational institutions.The ideal candidate will have strong functional knowledge, excellent project execution capabilities and a customer-first mindset to ensure smooth client onboarding and system adoption.Key...

  • Serosoft - Senior Software Engineer - Java

    2 weeks ago

    Indore, Madhya Pradesh, India Serosoft (Academia): World's Fastest-growing Student Information System Company Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    About The RoleWe are seeking a highly skilled Senior Software Engineer (Java) to join our team.In this role, you will design, develop, and deliver robust, scalable, and high-quality Java-based applications.You will play a key role in ensuring technical excellence, collaborating with cross-functional teams, and contributing to the overall success of our...

  • Senior Network Engineer

    1 week ago

    Indore, Madhya Pradesh, India Serosoft Solutions Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Job Category: TechnicalDepartment: AdminJob Location: IndoreExperience: 5+ yearsAbout the Role:A Sr. Network Engineer plays a pivotal role in designing, implementing, and maintaining the companys network infrastructure to ensure optimal performance, reliability, and security. Key responsibilities include configuring and managing network devices such as...

  • Performance Tester

    1 week ago

    Indore, Madhya Pradesh, India Academia by Serosoft, Inc. Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Job Category:TechnicalDepartment:QAJob Location:IndoreExperience:5+ yearsAbout the Role:India's leading Educational ERP Software company, a Deloitte Fast 50 Company, and ET Growth Champion, Serosoft is looking for an experienced Senior QA Engineer with deep expertise in Performance testing. The ideal candidate will have over 5+years of experience in...

  • Ethical Hacker

    1 week ago

    Indore, Madhya Pradesh, India Academia by Serosoft, Inc. Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Job Title:Ethical HackerJob Location:IndoreExperience:3+ YearsAbout the Role:As a key member of our technology leadership, we're seeking a skilled Ethical Hacker to assess and test the vulnerabilities in all components of the Academia ecosystem—including the Admin Portal, Student Portal, Faculty Portal, Teacher Portal, and Mobile Applications.Key...

  • Ethical Hacker

    5 days ago

    Indore, Madhya Pradesh, India Serosoft (Academia): World's Fastest-growing Student Information System Company Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Job Title :Ethical HackerJob Location :IndoreExperience :3+ YearsAbout The RoleAs a key member of our technology leadership, were seeking a skilled Ethical Hacker to assess and test the vulnerabilities in all components of the Academia ecosystem ethincluding the Admin Portal, Student Portal, Faculty Portal, Teacher Portal, and Mobile Applications.Key...