Data Migration Engineer

* Utilise your data expertise to provide support and advice to the Victorian Institute of Forensic Medicine branch
* Fixed-Term (6 months), Full-Time opportunity to work with a high-performing and passionate team in the Victorian Public Service
* VPS Grade 6: $130,673 - $174,869 plus superannuation.
About Us:
The Victorian Institute of Forensic Medicine (VIFM) is an independent statutory authority governed by the Victorian Institute of Forensic Medicine Act 1985 (the VIFM Act). It is part of the Justice portfolio of the Victorian Government.
The VIFM Act creates a joint position of Director of the VIFM and Professor of the Department of Forensic Medicine (DFM) at Monash University. The Director/Professor is responsible for the strategic direction and activities of the DFM, which is housed at the VIFM and operates under the governance of the Monash University Faculty of Medicine, Nursing and Health Sciences.
About the Role:
VIFM is looking for a Database Migration Engineer to plan and execute the Data Migration activities for an exciting Digital Transformation project. The role includes moving the data and converting content as necessary, while considering risks and potential. The successful candidate will have an extensive background in migrating data from Oracle or SQL databases to Microsoft Dynamics Customer Service (365 Dataverse) through automated tools. The role will analyse existing database tables, understand the data, and build and test automated Data Migration.
Some of your duties will include:
* Analyinge and understanding existing data and information stored within
* If required, building logical data model of the related entities. Map physical entities to the logical data model
* Completing other duties as required by Enterprise Architect
* On some occasions, analysing Java application code to understand what data is mapped from the UI to the database tables
To learn more about this role before applying, please read the attached position description.
About You:
As an ideal candidate, you will possess:
* Minimum 3+ years' experience with migrating data into Dataverse using automated tools. o Minimum 3+ years' experience with expertise in Data Mapping, Data Conversion and Migration.
* Detailed knowledge and understanding of Oracle 19 databases o Experience defining the data object model of a complex business system by mapping its components required for Data migration and conversion
* Experience in developing logical data model and mapping it to physical data model o Experience in SQL scripts and stored procedure to understand data manipulation and document findings for Data Migration purposes
* Experience and understanding of Java programming language to investigate and troubleshoot data mapping issues
* Experience and knowledge of any health data model would be highly advantageous
* Experience in redesigning existing database model for mapping to the new system would be highly advantageous.
Qualifications:
* Tertiary qualifications (degree or higher) in Computer Science, Information Technology, or related field
How to Apply:
Please click the Apply button on this advertisement. Applications should include a resume and covering letter. Attachments can be uploaded in .doc, .docx, .pdf, .txt or .rtf formats.
The successful candidate will be required to undergo pre-employment checks which may include national police checks and misconduct screening.
If you require adjustments to the recruitment and selection process, or require an alternative format to any of the application material, please don't hesitate to get in touch with the contact person listed on this ad.
FOR INTERNAL VPS EMPLOYEES:
* For this particular vacancy, priority consideration applies to Victorian Public Service (VPS) and select employees of the Victorian Public Sector who apply through the Jobs Skills Exchange (JSE) jobs board platform.
* For all VPS employees, due to the new Jobs Skills Exchange (JSE) policy, please apply through the JSE to be eligible to be considered for this position in the first round.
IMPORTANT INFORMATION:
CHILD SAFE STATEMENT OF COMMITMENT:
The Department of Justice and Community Safety is committed to the safety and wellbeing of children and young people. We seek to prevent harm of any kind impacting children and young people and have zero tolerance for racism, child abuse and inequality. Children and young people's rights, relationships, identity, and culture must be recognised and respected, their voices heard, and their concerns acted upon. We aim to foster a culturally safe, child safe and child friendly environment for all children and young people we have contact with, deliver services to, or are impacted by our work.