MySQL Developer

About the Role

We are currently seeking a proficient and detail-focused MySQL Developer to join our team. This role involves designing, creating, maintaining, and optimizing database systems that support various corporate applications and business functions. The candidate will collaborate closely with development teams to provide dependable database solutions, enhance query efficiency, and maintain data consistency and security.

Key Responsibilities

• Create and maintain MySQL database structures to back business applications and operations.
• Develop, fine-tune, and sustain complex SQL queries, stored procedures, functions, triggers, and views.
• Architect database schemas, tables, indexes, relationships, and enforce constraints based on application needs.
• Perform performance analysis and optimization for queries, indexing, and execution plans.
• Identify and correct database malfunctions, bottlenecks, and data anomalies.
• Ensure the accuracy, consistency, integrity, and security of the database systems.
• Write and update scripts for data migration, reporting, and ongoing database maintenance.
• Coordinate with software engineers, system admins, business analysts, and other stakeholders.
• Support database integration with software via APIs and backend services.
• Continuously monitor database performance, storage utilization, and resource consumption.
• Oversee backup, recovery, and disaster recovery procedures to safeguard data.
• Assist in managing database updates, migrations, configurations, and version control.
• Implement access controls and permissions to secure sensitive data.
• Document the database design, development procedures, changes, and problem resolution methodologies.
• Troubleshoot and resolve issues in production databases with minimal disruption.
• Participate in code reviews, testing phases, deployments, and continuous improvement efforts.

Qualifications and Skills

• Degree or diploma in Computer Science, Information Technology, Software Engineering, or related areas preferred.
• Relevant experience in MySQL development, administration, SQL programming, or backend development roles.
• Strong skills in MySQL and relational database management principles.
• Proficient with advanced SQL query writing, including joins, subqueries, and aggregate functions.
• Sound understanding of database normalization, indexing techniques, transactions, and query tuning.
• Experience with stored procedures, functions, triggers, views, and managing database constraints.
• Knowledge of backup, recovery strategies, security protocols, and performance oversight.
• Capability to identify and resolve database errors and maintain data integrity.
• Familiarity with integrating applications to databases and understanding data access patterns.
• Strong analytical abilities, meticulous attention to detail, and problem-solving orientation.
• Effective communication and teamwork skills to collaborate across technical groups.
• Ability to handle multiple responsibilities and meet project deadlines efficiently.

Preferred Additional Skills

• Hands-on experience with MySQL replication, high availability setups, scalability, and tuning performance.
• Exposure to cloud-based database services and managed MySQL environments.
• Knowledge of programming languages such as PHP, Python, Java, or JavaScript.
• Familiarity with Git workflows, testing, deployment processes, and continuous integration.
• Experience with database monitoring utilities, extract-transform-load (ETL) operations, and data migration.
• Awareness of cybersecurity principles and best practices for secure database development.

Additional Information

This is a full-time opportunity located onsite in Dubai, UAE, with a focus on MySQL database development and maintenance. Interested applicants should submit their CVs emphasizing their experience with MySQL development, SQL optimization projects, and database management skills. Mention "MySQL Developer" in your application.

We are eager to welcome technology professionals who are enthusiastic about database performance enhancement, data integrity, and reliable software solutions development.