We are seeking an experienced Senior MySQL Developer to architect, develop, and maintain databases for a large-scale, highly complex ERP system, where 90% of the application logic is implemented in MySQL.
The ideal candidate should have the capability to independently own and manage the complete database environment, ensuring high performance, scalability, and reliability.
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.
Required Skills & Qualifications
- 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, and normalization.
- Experience with replication, clustering, and partitioning architectures.
- Strong hands-on expertise in backup, recovery, DR, and high availability solutions.
- Ability to independently own, manage, and scale the database environment.
Must to Have
- Experience with ERP systems or complex business applications.
- Familiarity with MySQL 8.x features (JSON, CTEs, window functions).
- Exposure to cloud databases (AWS/GCP/Azure).
Preferred / Nice to Have
- Knowledge of Linux server administration.
- Experience with DevOps, CI/CD, and automation scripting.
- Understanding of data warehousing and analytics platforms.
Soft Skills
- Strong analytical and problem-solving skills.
- Ownership mindset with ability to work with minimal supervision.
- Excellent communication and documentation skills.
- Ability to succeed in a fast-paced, dynamic environment.
