Role: MySQL Database Administrator
Work location: Melbourne
Role type: Contract
Key Responsibilities:
* Design, develop, and optimize MySQL database schemas, tables, views, stored procedures, and functions to meet application requirements.
* Develop and implement efficient SQL queries, ensuring optimal performance and resource utilization.
* Lead and execute data migration projects, including planning, data extraction, transformation, loading (ETL), and validation from various source systems to MySQL databases.
* Develop and maintain data migration scripts and tools, ensuring data accuracy and minimal downtime during transitions.
* Perform database performance tuning, including query optimization, indexing strategies, and schema adjustments.
* Monitor database performance, identify bottlenecks, and implement solutions to ensure high availability and responsiveness.
* Implement and maintain database security measures, including user access control, data encryption, and compliance with data governance policies.
* Collaborate with software development teams to integrate database solutions with applications and ensure seamless data flow.
* Develop and maintain comprehensive documentation for database designs, migration processes, and operational procedures.
* Provide support for database-related issues, including troubleshooting, bug fixing, and incident resolution.
* Stay updated with the latest advancements in MySQL technology and data migration best practices.
Required Skills and Qualifications:
* Bachelor's degree in Computer Science, Information Technology, or a related field.
* Proven experience as a MySQL Developer or Database Administrator.
* In-depth knowledge of MySQL database architecture, design, and optimization techniques.
* Extensive experience with data migration methodologies and tools, including ETL processes.
* Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
* Experience with database performance tuning and query optimization.
* Solid understanding of relational database concepts, including normalization, indexing, and data integrity.
* Familiarity with database security best practices and data encryption.
* Experience with scripting languages (e.g., Python, Shell) for automation of database tasks and migrations.
* Excellent problem-solving, analytical, and communication skills.
* Ability to work independently and collaboratively within a team environment