The Cloud Database Administrator will design, optimize, and manage data pipelines, CI/CD processes, and provide database solutions for Azure and Oracle databases while ensuring performance and security.
If you are interested kindly send your updated resume to [email protected] by Tuesday, May 27, 10:00 AM EST
Job Title: RQ09217 - DataOps/Cloud Data Engineer – Senior
Client: Ministry of Public and Business Service Delivery and Procurement
Work Location: 87 Sir William Hearst Ave., Toronto, Ontario, Hybrid
Estimated Start Date: 2025-05-08
Estimated End Date: 2026-03-31
#Business Days: 231.00
Extension: 250.00
Hours per day or Week: 7.25 hours per day
Security Level: CRJMC
Must haves:
Deliverables
Scope of Services and Deliverables - The Services and Deliverables to be provided by the Vendor will include the following:
Cloud DataOPS - 40%
Note:
Job Title: RQ09217 - DataOps/Cloud Data Engineer – Senior
Client: Ministry of Public and Business Service Delivery and Procurement
Work Location: 87 Sir William Hearst Ave., Toronto, Ontario, Hybrid
Estimated Start Date: 2025-05-08
Estimated End Date: 2026-03-31
#Business Days: 231.00
Extension: 250.00
Hours per day or Week: 7.25 hours per day
Security Level: CRJMC
Must haves:
- Azure
- DBA
- SQL and Oracle
Deliverables
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, and Production environments.
- Provision data in cloud environment according to requirements.
- Design, develop data loading, data conversion, and data migration program.
- Design, develop, and implement data conversion 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, and tune performance of Oracle, Microsoft Azure SQL database, and Synapse database.
- Support cloud-based heterogeneous data replication solution.
- Develop complex Oracle PL/SQL program and SQL Server stored procedure to fulfill project, work request, and maintenance requirements.
- Optimize performance of PL/SQL program and SQL Server stored procedure.
- Monitor and analyze incidents and 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, archiving, etc.
- Document and resolve any database problems/issues.
- Provide effective knowledge transfer to Ministry staff at all stages of this assignment.
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.
- 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.
- Experience with Azure SQL, Oracle, IMS/DB2 data replication.
Note:
- The candidate is required to come to the office 3 days a week
Top Skills
Azure Devops
Dacpac
Data Lake
Data Lakehouse
DevOps
Azure
Oracle
Pl/Sql
SQL
SQL Server
Similar Jobs
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
As a Software Engineer III at CrowdStrike, you will research and develop software for Linux endpoint protection, focusing on detecting malicious activity and feature design, collaborating with remote teams.
Top Skills:
C/C++EbpfLinux
Artificial Intelligence
As a Product Engineer, you will create and enhance AI-driven products, develop APIs, and collaborate with various teams to improve user experiences.
Top Skills:
Next.JsNode.jsNoSQLPythonReactSQLTypescript
Artificial Intelligence
Design and develop state-of-the-art language models and ML systems. Collaborate with product teams and lead impactful ML projects in a fast-paced environment.
Top Skills:
Deep LearningLlmsPyTorchTransformers
What you need to know about the Montreal Tech Scene
With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.
Key Facts About Montreal Tech
- Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
- Major Tech Employers: SAP, Google, Microsoft, Cisco
- Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
- Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
- Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
- Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal
