Job Title
: Cloud Data Enginee
rJob Location:
Toronto (onsite
)Job Type:
Full-Time/ Contrac
t
This is an on-site 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 setting 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 (Alberta)
🏢 Socket.dev
📍 Alberta