This is a contract position for a Database Administrator for our client who is in the Broader Public Sector. Work location will be in North York.
This is a Hybrid Role with 2 days in the office a week. This is a mandatory requirement of the role and is non negotiable outside of exceptional circumstances.
The Contract runs for one year.
...
Hours per day will be 7.25
Advantages
Good Compensation working on projects that will make a difference to the people of Ontario.
Responsibilities
Task 1
Monthly Performance Status Report
Deliverables
· All deliverables that consultant worked on during past month are included
· Progress and specific accomplishment against the deliverable are described
· Status of consultant’s deliverable compared to the project Baseline
Estimated Completion Date
Monthly
Task 2
Manage and administer the database and application servers used to support the Driver& Vehicle data quality analysis activities.
Deliverables
· Apply database and system patches and perform database change management activities
· Create, configure, reorganize, and migrate database / objects
· Conduct database capacity planning and database disaster recovery planning
· Design, test, and manage database backup and recovery
· Provide support for development and performance optimization of programs/jobs such as SQL*Loader jobs, data loading jobs, transformation/ETL jobs, PL/SQL & SQL scripts and Unix/Linus scripts etc
· Provide administration support on application server and the setup & development on IBM InfoSphere or Informatica Data Quality
Estimated Completion Date
Throughout the project
Task 3
Support the project delivery of data extraction, data analysis, data profiling and data cleansing of the Driver & Vehicle data.
Deliverables
· Support project related data extraction, profiling and data masking activities
· Liaise with project stakeholders to analyze data quality issues and provide root cause analysis
· Provide support for development and performance optimization of programs/jobs such as ETL, Perl, Java, Python and Machine Learning programs etc
Estimated Completion Date
According to the project schedule to be defined by the Project Manager and Technical
Coordinator
Task 4
Knowledge transfer to ministry staffs or resources designated by the ministry
Deliverables
· Documentations
· Walk-through sessions
Estimated Completion Date
Throughout the project
Qualifications
Experience and knowledge with Siebel and PowerBI
Extensive experience in administrating Oracle 12c on Linux/Windows and database performance tuning
Experience with data quality technologies and tools such as Infosphere and Informatica and the installation of the tools
Experience in database migration, setup and management of on Premise, Cloud or Hybrid environments
Experience and proficient in ETL technology, tools and programming
Experience and proficient in developing PL/SQL, complex queries with SQL, Unix/Linux scripts (e.g. Perl), Excel and one or more other programming language
Summary
If interested and qualified for this role, please apply today for immediate consideration!!!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
This is a contract position for a Database Administrator for our client who is in the Broader Public Sector. Work location will be in North York.
This is a Hybrid Role with 2 days in the office a week. This is a mandatory requirement of the role and is non negotiable outside of exceptional circumstances.
The Contract runs for one year.
Hours per day will be 7.25
Advantages
Good Compensation working on projects that will make a difference to the people of Ontario.
Responsibilities
Task 1
Monthly Performance Status Report
Deliverables
· All deliverables that consultant worked on during past month are included
· Progress and specific accomplishment against the deliverable are described
· Status of consultant’s deliverable compared to the project Baseline
Estimated Completion Date
Monthly
Task 2
Manage and administer the database and application servers used to support the Driver& Vehicle data quality analysis activities.
Deliverables
· Apply database and system patches and perform database change management activities
· Create, configure, reorganize, and migrate database / objects
...
· Conduct database capacity planning and database disaster recovery planning
· Design, test, and manage database backup and recovery
· Provide support for development and performance optimization of programs/jobs such as SQL*Loader jobs, data loading jobs, transformation/ETL jobs, PL/SQL & SQL scripts and Unix/Linus scripts etc
· Provide administration support on application server and the setup & development on IBM InfoSphere or Informatica Data Quality
Estimated Completion Date
Throughout the project
Task 3
Support the project delivery of data extraction, data analysis, data profiling and data cleansing of the Driver & Vehicle data.
Deliverables
· Support project related data extraction, profiling and data masking activities
· Liaise with project stakeholders to analyze data quality issues and provide root cause analysis
· Provide support for development and performance optimization of programs/jobs such as ETL, Perl, Java, Python and Machine Learning programs etc
Estimated Completion Date
According to the project schedule to be defined by the Project Manager and Technical
Coordinator
Task 4
Knowledge transfer to ministry staffs or resources designated by the ministry
Deliverables
· Documentations
· Walk-through sessions
Estimated Completion Date
Throughout the project
Qualifications
Experience and knowledge with Siebel and PowerBI
Extensive experience in administrating Oracle 12c on Linux/Windows and database performance tuning
Experience with data quality technologies and tools such as Infosphere and Informatica and the installation of the tools
Experience in database migration, setup and management of on Premise, Cloud or Hybrid environments
Experience and proficient in ETL technology, tools and programming
Experience and proficient in developing PL/SQL, complex queries with SQL, Unix/Linux scripts (e.g. Perl), Excel and one or more other programming language
Summary
If interested and qualified for this role, please apply today for immediate consideration!!!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
