RQ11222 - Sr. DataOps/Cloud Data Engineer

Source Code; Toronto; On-site; CAD 117,000 - 141,000; Full time

Job summary

Source Code seeks a Sr. DataOps/Cloud Data Engineer to lead Azure-based data operations and cloud data engineering initiatives.

Responsibilities include designing and optimizing CI/CD pipelines for databases, modeling data with Sybase Power Designer, and managing data lakes/lakehouses across OLAP/OLTP environments in cloud platforms. The role requires expert Azure knowledge and substantial experience with SQL databases (Azure SQL, Synapse) and other databases (Oracle, IMS, DB2).

Qualifications

• Expert experience with Microsoft Azure technologies including pipeline, data lake, data lakehouse, Azure monitoring tools.
• DataOPS experience.
• Expert data/database administration experience with Azure SQL, Synapse, Oracle, IMS, DB2, etc.

Responsibilities

• Review project artefacts and maintenance releases (Use Case, System Requirements Specification).
• Deliver system design documents conforming to Ministry standards.
• Design, develop and optimize data/database CI/CD pipelines.
• Design data models using Sybase Power Designer.
• Prepare DACPAC changes and develop Azure CI/CD release pipelines.
• Promote database changes through environments (Dev, IT, QA, UAT, Prod).
• Provision data in cloud environments per requirements.
• Design and implement data workflows for OLAP/OLTP to SaaS/PaaS/IaaS in cloud.
• Design, develop and implement data warehouse, data lake, and data lakehouse.

Skills

Azure data services

DataOPS

Database administration

Tools

DACPAC

Azure DevOps

Sybase Power Designer

Job description

About the job RQ11222 - Sr. DataOps/Cloud Data Engineer

Security Level: CRJMC

Must haves:

• 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.
• DataOPS experience
• Expert data/database administration experience, e.g., Microsoft Azure SQL database and Synapse database, Oracle, IMS, DB2, etc.

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

AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting and business operations.

Note: The higher end of the range is intended for absolutely exceptional candidates who meet all must-have requirements and most or all nice-to-have qualifications. The client will evaluate candidates based on both rate expectations and overall skill set when shortlisting.

• $85.35/hr - $102.42/hr Inc.