MySQL Database Programmer

Design and develop database schemas, tables, views, and stored procedures.

Collaborate with application developers to define database requirements, best practices, resolve issues and optimize database performance. Write efficient SQL queries and optimize them for performance.

Perform data modeling and database schema changes. Implement data migration, transformation, and loading (ETL) processes.

Manage and maintain data integrity and consistency.

Monitor database performance and perform tuning to optimize SQL queries and database configurations.

Analyze and resolve performance issues, including identifying and fixing slow queries. update indexing, caching, and partitioning to improve database efficiency. Implement and enforce database security measures to protect sensitive data, security assessments and audits.

Manage database replication and high availability setups.

Document database changes and maintain version control of database scripts. Participate in code reviews and provide feedback to ensure database-related code is efficient and maintainable.

Work closely with developers, system administrators, and other stakeholders. Provide training and support to other team members as needed.