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

📌 Sr. DataOps/Cloud Data Engineer (Toronto)
🏢 Source Code
📍 Toronto