Senior MySQL Developer / Database Engineer

Role Overview: You will be responsible for architecting, developing, and maintaining databases for a large-scale ERP system, with a focus on MySQL. Your role will involve ensuring high performance, scalability, and reliability of the complete database environment. Key Responsibilities: - Architect, design, and maintain robust, scalable, and secure database structures to support complex business processes. - Develop, optimize, and maintain complex stored procedures, triggers, functions, events, and views. - Translate business requirements into efficient database logic and data models. - Lead advanced query optimization, indexing strategies, and performance tuning for high-volume environments. - Troubleshoot and resolve database performance, reliability, and data consistency issues. - Manage schema design, change control, versioning, and release management. - Implement and maintain replication, clustering, partitioning, backup, recovery, and high availability frameworks. - Establish and drive database standards, best practices, and governance. - Design and manage ETL processes, data pipelines, and integrations with external systems. - Conduct capacity planning, resource utilization analysis, and performance forecasting. - Collaborate with engineering, product, DevOps, and operations teams. - Provide technical leadership, mentorship, and knowledge sharing when required. Qualifications Required: - 8+ years of hands-on experience in MySQL development and administration. - Extensive experience with advanced SQL programming, stored procedures, functions, triggers, events, query optimization, execution plans, indexing, partitioning, and performance tuning. - Proven experience managing large, high-transaction, business-critical databases. - Strong knowledge of database design, data modeling, normalization, replication, clustering, and partitioning architectures. - Hands-on expertise in backup, recovery, disaster recovery, and high availability solutions. - Experience with ERP systems or complex business applications. - Familiarity with MySQL 8.x features such as JSON, CTEs, and window functions. - Exposure to cloud databases (AWS/GCP/Azure). - Soft skills: Strong analytical and problem-solving skills, ownership mindset, excellent communication, and documentation skills, ability to work in a fast-paced environment. Please note that the company description is not included in the provided job description.,