MySQL Developer - Database Design

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 (ref:hirist.tech)

Location: mumbai, IN

Posted Date: 5/7/2025