Job Title: Cloud Data EngineerJob Location:Toronto (onsite)Job Type:Full time/ ContractThis 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, 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 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 scriptsBuild and test database automation scripts.Perform database administration, including patching/upgrade, monitoring, performance tuning, partitioning, capacity planning, OEM upgrade/enhancement, achieving, eDocument and resolve any database problems/issues.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 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 fromyou. #J-18808-Ljbffr

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