-
S M Software Solutions Inc

DevOPS /Cloud Engineer - Intermediate (RQ08290)

S M Software Solutions Inc
Canada · Contract · Mid-Senior

The Ministry of Transportation is seeking an experienced DevOPS/Cloud Engineer for an intermediate-level role. This position requires a skilled professional with extensive experience in data/database administration and Microsoft Azure technologies. The successful candidate will work in a hybrid environment, with a mix of onsite and remote work.

Must Haves:

Expert data/database administration experience (e.g., Microsoft Azure SQL database, Synapse database, Oracle, IMS, DB2).

Expert experience with Microsoft Azure technologies (e.g., 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 Azure SQL, Oracle, IMS/DB2 data replication.

Responsibilities:

Participate in the review of project, work request, and maintenance release artefacts (e.g., Use Case, System Requirement Specification).

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 changes 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 environments according to requirements.

Design, develop data loading, data conversion, and data migration programs.

Design, develop, and implement data conversion of Very Large Data (VLD) for OLAP and OLTP environments to Cloud SaaS, PaaS, and IaaS environments.

Design, develop, and implement fact/dimension models, data mapping, data warehouse, data lake, and data lakehouse.

Plan, configure, maintain, and tune performance of Oracle, Microsoft Azure SQL database, and Synapse database.

Support cloud-based heterogeneous data replication solutions.

Develop complex Oracle PL/SQL programs and SQL server stored procedures to fulfill project, work request, and maintenance requirements.

Optimize performance of PL/SQL programs and SQL server stored procedures.

Monitor and analyze incidents, providing 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, and archiving.

Document and resolve any database problems/issues.

Provide effective knowledge transfer to Ministry staff at all stages of the assignment.

Thanks and regards,

Akshay Kothule PH: +1-512-800-8146

Linkedin:www.linkedin.com/in/akshay-patil-303015165

We're reaching out to you as a response to your interest in potential job opportunities. Whether you've contacted us directly or your resume is available for recruiters and HR specialists, we appreciate your interest in exploring career possibilities with our company.

Powered by JazzHR

7m6yuFXGOn

Key Skills

Ranked by relevance

sql oracle cloud sql server server cicd data warehouse storage devops vault saas paas
Login to Apply
Posted
Dec 28, 2024
Type
Contract
Level
Mid-Senior
Location
Greater Toronto Area

Industries

Internet Publishing

Categories

Engineering Information Technology

Related Jobs

3 roles aligned with this opportunity

View all jobs
View Job Details
Bright Vision Technologies
Related

Python Developer

2026-05-23

Full-time
Mid-Senior
United States
Internet Publishing
Engineering
View Job Details
XiFin, Inc.
Related

.NET Software Engineer

2026-05-26

Full-time
Not Applicable
United States
Business Intelligence Platforms
Engineering
View Job Details
Bright Vision Technologies
Related

.NET Full Stack Developer

2026-05-27

Full-time
Mid-Senior
United States
Internet Publishing
Engineering