Job descriptionRQ11222 - Sr. DataOps/Cloud Data Engineer 10-month contract (200 business days) ONSITE 5 days - 87 Sir William Hearst Ave., Toronto, Ontario M3M 0B4 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 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. 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. INCORPORATED RATE RANGE (7.25 billable hours per day) $85.35/hr - $102.42/hr Inc. T4 RATE RANGE (7.25 billable hours per day) $68.28/hr - $81.94/hr T4