Cloud Data Engineer

We are looking for a Cloud Data Engineer for a position based in Toronto!

Job Title: Cloud Data Engineer

Job Location: Toronto (onsite)

Job Type: Full-Time/ Contract

This is an on-site role based in Toronto, requiring five days of office work per week.

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 organization standards.
• Design, develop, and enhance CI/CD pipelines for data and databases.
• Design logical and physical data models using Sybase Power Designer.
• Prepare a database change in DACPAC and develop an Azure CI/CD release pipeline to promote DACPAC.
• Create complex Oracle PL/SQL programs and SQL Server stored procedures to meet project, work request, and maintenance requirements.
• Promote database changes through Development, Integration Testing, QA, UAT, and Production environments.
• Provision data in a cloud environment according to requirements.
• Design and develop a data loading, data conversion, and data migration program.
• Design, develop, and implement data conversion 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, and tune the performance of Oracle, Microsoft Azure SQL database, and Synapse database.
• Support a cloud-based heterogeneous data replication solution.
• Optimize the performance of PL/SQL program, SQL server stored procedure.
• Monitor and analyze incidents, 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/upgrading, monitoring, performance tuning, partitioning, capacity planning, OEM upgrade/enhancement, achieving, e
• Document and resolve any database problems/issues.
• Provide effective knowledge transfer to Ministry staff at all stages of this assignment.

Must Haves

The individual must possess advanced expertise in Microsoft Azure technologies, such as Azure pipelines, DACPAC, storage accounts, disks, file shares, Azure Key Vault, Azure Portal, virtual machines, Azure DevOps, Data Lake, Data Lakehouse, and Azure monitoring tools.

If you are a skilled Cloud Data Engineer looking for an exciting opportunity to work with cutting-edge technologies in a collaborative environment, we would love to hear from you.

Please apply via LinkedIn or send us your resumes at ***email_hidden***