Are you a seasoned Specialized IT Consultant with proven hands-on expertise in Oracle database administration and advanced data replication technologies. The successful candidate will be responsible for the design, deployment, and optimization of secure, scalable data solutions across on-premises and cloud environments using Oracle RAC, Data Guard, GoldenGate, and Azure services.
...
Our client is looking for a Specialized IT Consultant for this hybrid role which requires on-site presence at least 2 days a week in Toronto đ. It is a contract role of 3 months and the initial term may be extended once, with a maximum extension of 124 days. You will play a critical role in ensuring data integrity, implementing CDC strategies, automating replication tasks, and enhancing operational efficiency within Agile and DevOps environments âïž.
Advantages
đ Hybrid work setup with flexibility
đ Long-term engagement with a hybrid work schedule
âïž Hands-on work with Oracle 19c, GoldenGate, Azure, and Databricks
đ Opportunity to lead enterprise-level cloud migration and replication solutions
đ ïž Exposure to cutting-edge tools and practices in big data and cloud architecture
Responsibilities
âą Administer large-scale Oracle databases on RAC clusters
âą Configure, manage, and optimize Oracle Data Guard and GoldenGate for real-time replication
âą Implement Change Data Capture (CDC) and ensure high data integrity
âą Design and manage flat files and big data pipelines using Azure Storage and Azure Databricks
âą Automate replication and ETL workflows using scripting (Python, Shell, SQL)
âą Optimize database performance and implement enterprise-level data masking
âą Document technical architecture, write user guides, and provide knowledge transfer
âą Collaborate with cross-functional teams in Agile settings to deliver reliable solutions
âą Conduct risk assessments, troubleshoot complex issues, and review source code quality
Qualifications
Must Have:
âą Proven experience administering Oracle RAC environments
âą Deep knowledge of Oracle Data Guard and Oracle GoldenGate (on-prem to cloud replication)
âą Expertise in CDC, PL/SQL, and SQL tuning
âą Experience in deploying and optimizing Oracle 19c on Exadata
âą Familiarity with Azure Storage, Azure Databricks, and cloud integration best practices
âą Experience with scripting languages and automation tools
âą Hands-on knowledge of Oracle GoldenGate Big Data Edition
âą Strong understanding of data architecture and cloud data design
Nice to Have:
đ§Ș Experience with DevOps tools and automated CI/CD workflows
đ§° Understanding of ETL tools and practices
đ Ability to design and document technical solutions clearly
đĄïž Exposure to data masking standards in enterprise systems
đ„ Experience working in Agile teams and promoting software best practices
Summary
This role offers an exciting opportunity to work on complex data replication and migration projects involving Oracle and Azure platforms. You will bring together database administration, big data integration, and automation skills to drive secure, high-performance data operations in a collaborative and fast-paced hybrid work environment đ.
If you are interested in this role, please apply online at www.randstad.ca. Qualified candidates will be contacted.
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
Are you a seasoned Specialized IT Consultant with proven hands-on expertise in Oracle database administration and advanced data replication technologies. The successful candidate will be responsible for the design, deployment, and optimization of secure, scalable data solutions across on-premises and cloud environments using Oracle RAC, Data Guard, GoldenGate, and Azure services.
Our client is looking for a Specialized IT Consultant for this hybrid role which requires on-site presence at least 2 days a week in Toronto đ. It is a contract role of 3 months and the initial term may be extended once, with a maximum extension of 124 days. You will play a critical role in ensuring data integrity, implementing CDC strategies, automating replication tasks, and enhancing operational efficiency within Agile and DevOps environments âïž.
Advantages
đ Hybrid work setup with flexibility
đ Long-term engagement with a hybrid work schedule
âïž Hands-on work with Oracle 19c, GoldenGate, Azure, and Databricks
đ Opportunity to lead enterprise-level cloud migration and replication solutions
đ ïž Exposure to cutting-edge tools and practices in big data and cloud architecture
...
Responsibilities
âą Administer large-scale Oracle databases on RAC clusters
âą Configure, manage, and optimize Oracle Data Guard and GoldenGate for real-time replication
âą Implement Change Data Capture (CDC) and ensure high data integrity
âą Design and manage flat files and big data pipelines using Azure Storage and Azure Databricks
âą Automate replication and ETL workflows using scripting (Python, Shell, SQL)
âą Optimize database performance and implement enterprise-level data masking
âą Document technical architecture, write user guides, and provide knowledge transfer
âą Collaborate with cross-functional teams in Agile settings to deliver reliable solutions
âą Conduct risk assessments, troubleshoot complex issues, and review source code quality
Qualifications
Must Have:
âą Proven experience administering Oracle RAC environments
âą Deep knowledge of Oracle Data Guard and Oracle GoldenGate (on-prem to cloud replication)
âą Expertise in CDC, PL/SQL, and SQL tuning
âą Experience in deploying and optimizing Oracle 19c on Exadata
âą Familiarity with Azure Storage, Azure Databricks, and cloud integration best practices
âą Experience with scripting languages and automation tools
âą Hands-on knowledge of Oracle GoldenGate Big Data Edition
âą Strong understanding of data architecture and cloud data design
Nice to Have:
đ§Ș Experience with DevOps tools and automated CI/CD workflows
đ§° Understanding of ETL tools and practices
đ Ability to design and document technical solutions clearly
đĄïž Exposure to data masking standards in enterprise systems
đ„ Experience working in Agile teams and promoting software best practices
Summary
This role offers an exciting opportunity to work on complex data replication and migration projects involving Oracle and Azure platforms. You will bring together database administration, big data integration, and automation skills to drive secure, high-performance data operations in a collaborative and fast-paced hybrid work environment đ.
If you are interested in this role, please apply online at www.randstad.ca. Qualified candidates will be contacted.
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