-
S M Software Solutions Inc
View all jobs
DevOPS /Cloud Engineer - Intermediate (RQ08290)
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
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
Related Jobs
3 roles aligned with this opportunity
View Job Details
Related
Python Developer
2026-05-23
Full-time
Mid-Senior
United States
Internet Publishing
Engineering
View Job Details
Related
.NET Software Engineer
2026-05-26
Full-time
Not Applicable
United States
Business Intelligence Platforms
Engineering
View Job Details
Related
.NET Full Stack Developer
2026-05-27
Full-time
Mid-Senior
United States
Internet Publishing
Engineering
Login to Apply
- Posted
- Dec 28, 2024
- Type
- Contract
- Level
- Mid-Senior
- Location
- Greater Toronto Area
- Company
- S M Software Solutions Inc
Industries
Internet Publishing
Categories
Engineering
Information Technology
Related Jobs
3 roles aligned with this opportunity
View Job Details
Related
Python Developer
2026-05-23
Full-time
Mid-Senior
United States
Internet Publishing
Engineering
View Job Details
Related
.NET Software Engineer
2026-05-26
Full-time
Not Applicable
United States
Business Intelligence Platforms
Engineering
View Job Details
Related
.NET Full Stack Developer
2026-05-27
Full-time
Mid-Senior
United States
Internet Publishing
Engineering