**DevOps/Cloud Engineer - Intermediate**

**Job Description:**

The successful candidate will be responsible for designing, developing, and optimizing data/database CI/CD pipelines, as well as managing cloud data platforms and ensuring seamless data exchange. This role is ideal for a professional with a strong background in Microsoft Azure technologies and expert data/database administration experience.

**Responsibilities:**
- Participate in the review of project, work request, and maintenance release artifacts.
- Deliver detailed system design documents conforming to Ministry standards.
- Design logical and physical data models using Sybase Power Designer.
- Prepare database changes in DACPAC and develop Azure CI/CD release pipelines.
- Promote database changes through various environments including Development, QA, and Production.
- Provision data in cloud environments according to requirements.
- Design and develop data loading, conversion, and migration programs.
- Implement data conversion for OLAP and OLTP environments to Cloud SaaS, PaaS, and IaaS.
- Design and implement data warehouse, data lake, and data lakehouse solutions.
- Plan and maintain databases, including performance tuning and administration.
- Support cloud-based data replication solutions.
- Develop and optimize Oracle PL/SQL programs and SQL server stored procedures.
- Monitor incidents and provide timely resolutions.
- Perform reference data administration and database backup/recovery.
- Document and resolve database issues.
- Provide knowledge transfer to Ministry staff.

**Mandatory Skills:**
- Expert experience with Microsoft Azure technologies such as Azure pipeline, DACPAC, and Azure DevOps.
- Experience with cloud data platforms, data management, and data exchange tools.
- Proficiency in DataOPS principles, CI/CD, and data provisioning automation.
- Strong background in data/database administration, including Azure SQL and Synapse databases.

**Preferred Skills:**
- Experience with digital product data analysis, data security, and DataOPS performance monitoring.
- Familiarity with structured, semi-structured, and unstructured data technologies.
- Experience in data replication with Azure SQL, Oracle, and IMS/DB2.

**Assignment Start Date:** ASAP – 3 months to start
**Assignment Location:** Toronto, ON – Work Hybrid