DataOps cloud Data Engineer 9217-2712

Foilcon; Toronto; Hybrid; CAD 110,000 - 130,000; Full time

Job summary

Foilcon is seeking a DataOps cloud Data Engineer to design, develop, and optimize data systems in a hybrid work setting. Key responsibilities include managing CI/CD pipelines, data models, and cloud services, requiring strong expertise in Microsoft Azure and database administration.

Qualifications

• Expert experience with Microsoft Azure technologies required.
• Extensive experience with SQL Server Stored Procedure and Oracle PL/SQL.
• Experience with data/database administration and performance tuning.

Responsibilities

• Design and implement data/database CI/CD pipelines.
• Develop and optimize data models and cloud services.
• Manage complex data operations and ensure performance optimization.

Skills

Cloud DataOPS

Database Management

Data Replication Pipelines

Job description

Join to apply for the DataOps cloud Data Engineer 9217-2712 role at Foilcon

Join to apply for the DataOps cloud Data Engineer 9217-2712 role at Foilcon

HM Note: This hybrid contract role is three (3) days in office. Candidates resume must include first and last name.

Description

Deliverables section:

Scope of Services and Deliverables - The Services and Deliverables to be provided by the Vendor will include the following:

• 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 Ministry 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 Ministry staff at all stages of this assignment.
  
  

Skills

Experience and Skill Set Requirements

Evaluation Table

Cloud DataOPS: 40%

• Expert experience with Microsoft Azure technologies, including Azure pipeline, DACPAC, storage account, disk, file share, Azure key vault, Azure portal, virtual machine, Azure DevOps, Data Lake, Data Lakehouse, Azure monitoring tools.
• Experience with Cloud data platforms, data management and data exchange tools and technologies.
• Experience with Data pipeline and workflow development, orchestration, deployment, and automation.
• Experience in DataOPS principle, best practice, and implementation and Agile project development and deployment.
• Experience in Continuous Integration/Continuous Development/Deployment (CI/CD) and Data provisioning Automation.
• Experience with digital product, data analysis, data exchange, data provisioning, and data security.
• Experience with structured, semi-structured, unstructured data collection, ingestion, provisioning and exchange technological development.
• Experience with DataOPS performance monitoring and tuning.
  
  

Database Management: 40%

• Expert data/database administration experience, e.g., Microsoft Azure SQL database and Synapse database, Oracle, IMS, DB2, etc.
• Extensive experience with SQL Server Stored Procedure, Oracle PL/SQL, PL/1 development and performance tuning.
  
  

Data Replication Pipelines: 20%

• Experience with Azure SQL, Oracle, IMS/DB2 data replication.
  
  

Must-haves

• Azure
• DBA
• SQL and Oracle

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Foilcon by 2x

Sign in to set job alerts for “Data Engineer” roles.

Mississauga, Ontario, Canada CA$110,000.00-CA$130,000.00 2 weeks ago

Richmond Hill, Ontario, Canada 1 month ago

Software Engineer, Backend (All Levels / All Teams)

Mississauga, Ontario, Canada 14 hours ago

Toronto, Ontario, Canada CA$120,000.00-CA$190,000.00 2 weeks ago

Mississauga, Ontario, Canada CA$70,000.00-CA$85,000.00 4 weeks ago

Software Engineer I, Entry Level (Fall 2024-Spring 2025) - Toronto

Ai and Data - Senior - Data Engineer - Toronto and Ottawa

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.