MySQL Database Programmer

Overview:

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 salary
• Health insurance
• Paid time off
• Training and development opportunities