Position: MySQL Database ProgrammerLocation: RemoteOverview:We are seeking a skilled MySQL Database Programmer with a minimum of 5 years of hands-on experience to join our team. The successful candidate will be responsible for designing, developing, and optimizing MySQL database objects, writing efficient queries/Stored procedures, and supporting application development teams with database-related tasks.Responsibilities:Database Development:Design and develop database schemas, tables, and relationships for applications.Write, optimize, and maintain complex SQL queries, stored procedures, functions, and triggers.Implement best practices for database normalization and indexing.Application Support:Collaborate with software developers to integrate databases with applications.Develop database-driven solutions to improve application performance and efficiency.Ensure seamless interaction between applications and MySQL databases.Performance Optimization:Analyse and optimize SQL queries for improved efficiency and faster response times.Work on query indexing, execution plans, and other performance-enhancing techniques.Database upgrade and migration:Ensure accurate and efficient data migration with minimal downtime.Support the database upgrade Security and Integrity:Implement best practices for database security, access control, and encryption.Ensure data integrity through the use of constraints, transactions, and validation techniques.Troubleshooting and Issue Resolution:Debug and resolve database-related issues, including performance and connectivity problems.Work closely with development teams to troubleshoot application database issues.Documentation and Knowledge Sharing:Maintain documentation for database structures, stored procedures, and best practices.Share knowledge with developers and team members to improve database development standards.Requirements:Bachelor's degree in Computer Science, Information Technology, or a related field.Minimum of 5 years of experience as a MySQL Database Programmer.Strong proficiency in SQL, stored procedures, functions, and triggers.Experience in database schema design and query optimization.Familiarity with data migration techniques and ETL processes.Knowledge of application-database interaction and database-driven application development.Excellent problem-solving and debugging skills.Effective communication and collaboration skills.Relevant certifications (e.g., MySQL Certified Developer) are a plus.Knowledge of Oracle and PostgreSQL is desirable.Benefits:Competitive salaryHealth insurancePaid time offTraining and development opportunities