Company Overview
About the job
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.
How to Apply