Description:
The driving force behind that work, our people, are diverse, creative, and passionate, raising the bar for excellence on a regular basis. We, in turn, work hard to bring out the best in them as we strive to help them find their spark and become the best version of themselves that they can be.
Are you ready to be an important part of this ever-transformational journey?
At HCLTech Australia, we value the unique perspective and contributions of all individual and we actively encourage applications from Aboriginal and Torres Strait Islander people to apply for this role.
Key Responsibilities:
- Design, develop, and optimize MySQL database scheme as, 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