---

---

Location

North York, ON | Canada

---

Job description

This is a contract position for a Specialized IT Consultant for our public sector client.
Work location: Downtown Toronto
Duration: Twelve Months
7.25 hours/day
This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)

Advantages
Good compensation working on projects that will make a difference to the people of Ontario.

Responsibilities
The services and deliverables to be provided by the Vendor will include the following:
· Providing Oracle database support to project teams

· Build Oracle database Infrastructure in Azure Cloud

· Provide ongoing support to all non-production and production database environments

· Refreshing the non-production databases from production data

· Tune all Oracle instance components including SQL and PL/SQL

· Provide data migration and data extract support

· Realtime data replication using Oracle Golden Gate technology

· Provide high availability using Active Data Guard technology

· Control access permissions and privileges

· Maintain data standards, including adherence to the Data Protection Act

· Test and enable new database features and customize them in order to make them fit the purpose

· Install, configure, and test Oracle Enterprise Manager (OEM) grid agent

· Provide performance tuning and optimization of Oracle databases

· Provide database documentation, including standards, procedures, and definitions

· Monitor and ensure CPU, memory, I/O, and storage are functioning as expected

· Collaborate with the project manager, IT leads, database administrators, project teams, and vendors

· Support deployment and release activities

Qualifications
· 10+ years experience with Azure Cloud and Oracle Database and technologies including, Data Guard, Automatic Storage Management (ASM), Oracle Wallet, and Oracle Enterprise Manager (OEM) on Solaris and Windows platforms

· 2+ years of experience with Oracle Golden Gate

· Experience with upgrading 12c version of databases to Oracle 19c

· Working knowledge of new features such as Oracle Multitenant option, Oracle Active Data Guard Far Sync, in-memory database, information lifecycle management enhancements, and new data types

· Experience with Oracle database upgrade and migration

· Experience with install, patch, and maintenance of all Oracle software

· Experience with tuning all Oracle instance components including SQL and PL/SQL

· Experience with installing and testing new versions of the RBMS and maintaining data standards while adhering to the Data Protection Act

· 5+ years experience with troubleshooting, problem solving, performance tuning, and hardware and system software infrastructure architecture design

· Proficient in troubleshooting, root cause analysis, and implementing solutions

· 2+ years experience with project planning and execution

· Ability to communicate regularly with technical, application, and operational teams

· Excellent analytical, problem-solving, and decision-making skills

· Strong leadership and collaboration skills

· Proven track record for building strong working relationships

· A demonstrated team player with a track record for meeting deadlines

· Previous experience working within the public sector would be an asset

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 [email protected] to ensure their ability to fully participate in the interview process. show more

---

Job tags

---

---

Salary