MySQL Developer - Database Design (3-5 yrs)

Job Description :

Responsibilities :

- Design and implement efficient and scalable MySQL database schemas based on application requirements.

- Create and maintain database objects, including tables, views, stored procedures, functions, and triggers.

- Ensure data integrity and consistency through appropriate database constraints and validation rules.

- Perform routine database maintenance tasks, such as backups, restores, and performance tuning.

- Monitor database performance and identify bottlenecks, implementing solutions to optimize performance.

- Manage database security, including user access control and data encryption.

- Develop and optimize complex SQL queries for data retrieval, manipulation, and reporting.

- Write efficient and performant SQL code to support application functionality and data analysis.

- Troubleshoot and resolve SQL query performance issues.

- Analyze query execution plans and identify areas for optimization.

- Implement indexing strategies to improve query performance.

- Optimize database configurations and parameters for optimal performance.

- Conduct code reviews, and provide constructive feedback regarding SQL code.

- Extract and analyze data from the database to support business requirements.

- Generate reports and visualizations using SQL and other data analysis tools.

- Work closely with other developers and stakeholders to understand data requirements.

- Create and maintain clear and concise database documentation, including schema diagrams, data dictionaries, and query documentation.

Requirements :

Technical Skills :

- Expert-level proficiency in SQL, with a strong understanding of relational database concepts.

- Extensive experience with MySQL database administration and development.

- Proven ability to write complex SQL queries, stored procedures, and functions.

- Strong understanding of database performance tuning and optimization techniques.

- Familiarity with database backup and recovery procedures.

- Familiarity with database design tools.

Experience :

- 3 to 5 years of professional experience as a SQL Developer or in a similar database development role.

- Demonstrated experience in designing, implementing, and maintaining MySQL databases.

- Proven track record of optimizing SQL queries and improving database performance.

Education :

- Bachelor's degree in Computer Science, Information Technology, or a related field.

Soft Skill :

- Strong analytical and problem-solving skills.

- Excellent communication and collaboration skills.

- Ability to work independently and as part of a team.

- Detail-oriented and highly organized