Job Title
: Cloud Data Enginee

rJob Location:
Toronto (onsite

)Job Type:
Full-Time/ Contrac

t
This is an in office role based in Toronto, requiring five days of office work per wee

**k.
Responsibiliti**

- es:Participate in the review of project, work request, and maintenance release artefacts - Use Case, System Requirement Specification, e
- tc.Deliver detailed system design documents and any other supporting documentation conforming to organization standar
- ds.Design, develop, and enhance CI/CD pipelines for data and databas
- es.Design logical and physical data models using Sybase Power Design
- er.Prepare a database change in DACPAC and develop an Azure CI/CD release pipeline to promote DACP
- AC.Create complex Oracle PL/SQL programs and SQL Server stored procedures to meet project, work request, and maintenance requiremen
- ts.Promote database changes through Development, Integration Testing, QA, UAT, and Production environmen
- ts.Provision data in a cloud environment according to requiremen
- ts.Design and develop a data loading, data conversion, and data migration progr
- am.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) environmen
- ts.Design,



develop and implement fact/dimension model, data mapping, data warehouse, data lake and data lakehou
- se.Plan, configure, maintain, administrate, and tune the performance of Oracle, Microsoft Azure SQL database, and Synapse databa
- se.Support a cloud-based heterogeneous data replication soluti
- on.Optimize performance of PL/SQL program, SQL server stored procedu
- re.Monitor and analyze incident, provide timely resoluti
- on.Perform reference data administration as requir
- ed.Build and test database backup/recovery scri
- ptsBuild and test database automation scrip
- ts.Perform database administration, including patching/upgrade, monitoring, performance tuning, partitioning, capacity planning, OEM upgrade/enhancement, achieving
- , eDocument and resolve any database problems/issu
- es.Provide effective knowledge transfer to Ministry staff at all stages of this assignme

**nt.
Must Ha**

ves: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 to

ols.
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.

#J-18808-Ljbffr

📌 Cloud Data Engineer (Calgary)
🏢 Socket.dev
📍 Calgary