MySQL Database Developer

We are seeking a highly motivated and experienced MySQL Database Developer to join our dynamic technology team. The ideal candidate will be responsible for the design, development, implementation, maintenance, and optimization of our MySQL databases. You will play a crucial role in ensuring the availability, reliability, performance, and security of our data infrastructure. This role requires a strong understanding of MySQL internals, excellent SQL skills, and a proactive approach to :

• Design, develop, and implement robust and scalable MySQL database schemas.
• Manage and maintain multiple MySQL database environments (development, staging, production).
• Perform database installations, configurations, upgrades, and patching as needed.
• Monitor database performance and identify areas for optimization.
• Implement and maintain database security measures, including user management, access control, and data encryption.
• Develop and implement backup and recovery strategies to ensure data integrity and availability.
• Write and optimize complex SQL queries, stored procedures, triggers, views, and functions.
• Identify and resolve performance bottlenecks in SQL queries and database design.
• Perform query tuning and optimization using various techniques and tools.
• Design and implement effective database indexing strategies to improve query performance.
• Ensure data integrity and consistency across all database environments.
• Implement and maintain data validation rules and constraints.
• Develop and implement processes for detecting and resolving data errors.
• Utilize various tools and techniques for efficient data and schema import/export.
• Participate in data migration projects, ensuring data accuracy and minimal downtime.
• Potentially work with SSIS or other ETL tools for data integration tasks.
• Create and maintain comprehensive documentation for database schemas, configurations, and procedures.
• Adhere to and promote database best practices and standards within the team.
• Stay up-to-date with the latest MySQL features, trends, and security vulnerabilities.
• Demonstrate understanding of the limitations and workarounds in MySQL compared to other popular relational databases like MSSQL.Required Skills and Experience :
• 2+ years of proven working experience as a MySQL Developer.
• Strong proficiency in MySQL database management principles and practices.
• Decent experience working with recent versions of MySQL.
• Thorough understanding of MySQL's underlying storage engines, such as InnoDB and MyISAM, and their implications.
• Solid knowledge of various MySQL features, including event scheduler, triggers, views, and functions.
• Proficiency in writing and optimizing complex SQL queries.
• Proven ability to identify and resolve database performance bottlenecks and tune database configurations and SQL queries.
• Experience in ensuring the availability, reliability, and security of MySQL databases in production and staging environments.
• Hands-on experience with various tools for data and schema import/export.
• Strong understanding of data integrity concepts and methods for detecting data errors.
• Expertise in index design and usage in SQL queries for performance optimization.
• Experience with backup and recovery procedures for MySQL databases.

Desired Skills :

• Experience with MSSQL database administration and development.
• Familiarity with SSIS (SQL Server Integration Services) or other ETL tools.
• Experience with database monitoring and alerting tools.
• Knowledge of scripting languages (e.g., Python, Bash) for database automation.
• Experience working in an Agile development environment.

Education : Bachelor's degree in computer science, Information Technology, or a related field )