MySQL Developer

Jero Technologies

Posted: 2 months ago
Openings: 10
Applicants: 0

Job Description

Design, develop, and maintain high-performance MySQL databases for enterprise applications.
Write and optimize complex SQL queries, stored procedures, triggers, and functions.
Perform database schema design, normalization, indexing, and partitioning for optimal performance.
Implement database security practices: role-based access control, encryption (at rest/in transit), audit logging.
Conduct performance tuning using EXPLAIN plans, query optimization, and profiling tools.
Manage database backups, replication, failover, and disaster recovery strategies (e.g., MySQL Replication, Galera Cluster).
Collaborate with DevOps teams to integrate database changes into CI/CD pipelines (Jenkins, GitLab CI, Azure DevOps).
Support database migrations (e.g., from legacy systems, Oracle, PostgreSQL to MySQL).
Document database architecture, data models, and operational procedures.
Troubleshoot production database issues, including deadlocks, replication lag, and slow queries.
Work in Agile/Scrum environments using JIRA, Confluence, and sprint planning.
Required Skills & Qualifications Bachelors degree in Computer Science, Engineering, or related field.
4+ years of hands-on experience in MySQL database development and administration.
Proficiency in SQL, stored procedures, triggers, views, and functions.
Strong understanding of database design principles, normalization, and data modeling.
Experience with MySQL 5.7, 8.0+, including replication, clustering, and high availability setups.
Familiarity with MySQL Workbench, phpMyAdmin, MySQL Shell, and command-line tools.
Experience with performance monitoring and tuning using tools like Percona Monitoring & Management (PMM), Prometheus, Grafana.
Knowledge of backup and recovery strategies (e.g., mysqldump, xtrabackup, Point-in-Time Recovery).
Understanding of database security (user roles, privileges, SSL/TLS, audit logs).
Experience in CI/CD integration for database changes (e.g., Liquibase, Flyway, Git-based schema versioning).
Experience working in Agile/Scrum teams using JIRA and Confluence.
Exposure to cloud-based MySQL services (AWS RDS, Google Cloud SQL, Azure Database for MySQL)