Do you have the knowledge of Azure and DBA? Do you have the knowledge of SQL and Oracle? If so, this would be a great opportunity for you!
Our client is looking for a Senior DataOps / Cloud Data Engineer for a 11 months contract in Toronto.
This is a hybrid role 3 days a week onsite 2 days remote.
Advantages
...
• Potential for extension
• Hybrid – 3 days a week onsite
• Earn a competitive rate within the industry
Responsibilities
· Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc.
· Deliver detailed system design documents and any other supporting documentation conforming to standards.
· Design, develop and optimize data/database CI/CD pipelines.
· Design logical and physical data models using Sybase Power Designer.
· Prepare database change in DACPAC and develop Azure CI/CD release pipeline to promote DACPAC.
· Promote database changes through Development, Integration Testing, QA, UAT, Production environments.
· Provision data in cloud environment according to requirements.
· Design, develop data loading, data conversion, data migration program.
· Design, develop and implement data conversation of VLD (Very large Data) of Online analytical processing (OLAP) and online transaction processing (OLTP) environments to Cloud Software-as-a-service (SaaS), Platform-as-a-service (PaaS) and Infrastructure-as-a-service (IaaS) environments.
· Design, develop and implement fact/dimension model, data mapping, data warehouse, data lake and data lakehouse.
· Plan, configure, maintain, administrate, tune performance of Oracle, Microsoft Azure SQL database and Synapse database.
· Support cloud-based heterogeneous data replication solution.
· Develop complex Oracle PL/SQL program, SQL server stored procedure to fulfill project, work request, maintenance requirements.
· Optimize performance of PL/SQL program, SQL server stored procedure.
· Monitor and analyze incident, provide timely resolution.
· Perform reference data administration as required.
· Build and test database backup/recovery scripts.
· Build and test database automation scripts.
· Perform database administration, including patching/upgrade, monitoring, performance tuning, partitioning, capacity planning, OEM upgrade/enhancement, achieving, etc
· Document and resolve any database problems/issues.
· Provide effective knowledge transfer to staff at all stages of this assignment.
Qualifications
Must-haves skills , knowledge and requirements:
· Azure
· DBA
· SQL and Oracle
Summary
If you are interested in the Senior DataOps/Cloud Data Engineer role in Toronto, 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
Do you have the knowledge of Azure and DBA? Do you have the knowledge of SQL and Oracle? If so, this would be a great opportunity for you!
Our client is looking for a Senior DataOps / Cloud Data Engineer for a 11 months contract in Toronto.
This is a hybrid role 3 days a week onsite 2 days remote.
Advantages
• Potential for extension
• Hybrid – 3 days a week onsite
• Earn a competitive rate within the industry
Responsibilities
· Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc.
· Deliver detailed system design documents and any other supporting documentation conforming to standards.
· Design, develop and optimize data/database CI/CD pipelines.
· Design logical and physical data models using Sybase Power Designer.
· Prepare database change in DACPAC and develop Azure CI/CD release pipeline to promote DACPAC.
· Promote database changes through Development, Integration Testing, QA, UAT, Production environments.
· Provision data in cloud environment according to requirements.
...
· Design, develop data loading, data conversion, data migration program.
· Design, develop and implement data conversation of VLD (Very large Data) of Online analytical processing (OLAP) and online transaction processing (OLTP) environments to Cloud Software-as-a-service (SaaS), Platform-as-a-service (PaaS) and Infrastructure-as-a-service (IaaS) environments.
· Design, develop and implement fact/dimension model, data mapping, data warehouse, data lake and data lakehouse.
· Plan, configure, maintain, administrate, tune performance of Oracle, Microsoft Azure SQL database and Synapse database.
· Support cloud-based heterogeneous data replication solution.
· Develop complex Oracle PL/SQL program, SQL server stored procedure to fulfill project, work request, maintenance requirements.
· Optimize performance of PL/SQL program, SQL server stored procedure.
· Monitor and analyze incident, provide timely resolution.
· Perform reference data administration as required.
· Build and test database backup/recovery scripts.
· Build and test database automation scripts.
· Perform database administration, including patching/upgrade, monitoring, performance tuning, partitioning, capacity planning, OEM upgrade/enhancement, achieving, etc
· Document and resolve any database problems/issues.
· Provide effective knowledge transfer to staff at all stages of this assignment.
Qualifications
Must-haves skills , knowledge and requirements:
· Azure
· DBA
· SQL and Oracle
Summary
If you are interested in the Senior DataOps/Cloud Data Engineer role in Toronto, 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