Role: MySQL DBA
Location: Melbourne
Job Description:
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
About Us:
We are Delivery Centric, a dynamic technology company that is transforming the delivery of cloud implementations and cybersecurity. We are headquartered in Australia with a global presence. We are tenacious, future-thinking, and highly driven to achieve an ambitious vision to be the leading global provider of innovative technologies for companies that keep our world clean, safe, and secure.
Our fast-paced and supportive environment will offer you lots of benefits, including a competitive salary, a friendly team, a healthy work environment, and opportunities for training and development.
Please contact me at navya.murali@deliverycentric.com for additional details
Job Type: Full-time
Work Authorisation:
Australia (Preferred)