Apptad - DevOPS/Cloud Engineer - Intermediate Job at Apptad Inc, Ontario, CA

YnFTcTdjNTB0SHJaNFIrWGNqNHBLaktFVnc9PQ==
  • Apptad Inc
  • Ontario, CA

Job Description

Job Title: Apptad - DevOPS/Cloud Engineer - Intermediate

Job Location: Toronto (Hybrid)

Job Duration: Long-Term Contract

One of our Government clients is looking for Intermediate DevOPS/Cloud Engineer

Job Description

Deliverables section:

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.

Must Haves:

  • Expert data/database administration experience, e.g., Microsoft Azure SQL database and Synapse database, Oracle, IMS, DB2, etc.
  • 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 Azure SQL, Oracle, IMS/DB2 data replication (knowledge of).





Selection Criteria

Evaluation Table

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.

Database Management 40%

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.

Data Replication Pipelines 20%

Experience with Azure SQL, Oracle, IMS/DB2 data replication.

Job Tags

Full time, Contract work, Remote job,

Similar Jobs

Two95 International Inc.

Sr ServiceNow Developer - Remote Job at Two95 International Inc.

 ...Title Sr ServiceNow Developer Position Contract (6+ Months) Location Remote Rate - $Open(Best Possible) Job Description: Experience implementing ServiceNow ITSM. Experience in Cataloguing. Experience in Javascript. Experience... 

DBA Web Technologies

Sr. Analyst Information Security (CISSP, Risk Management, Network Security, encryption, communication protocols) in Waukegan, IL Job at DBA Web Technologies

Sr. Analyst Information Security (CISSP, Risk Management, Network Security, encryption, communication protocols) in Waukegan, ILCISSP...  ...Full-Time Permanent position (no contracts, no corp to corp, no remote) Salary: Excellent Compensation with benefitsSKILLS:... 

Gourmet Foods International

Class B Class B Company Driver Job Job at Gourmet Foods International

Class B Class B Company Driver JobRESPONSIBILITIES AND DUTIES include, but are not limited to, the following:Performing all pre-trip responsibilities...  ...Create a Driver's Account.Person to Contact about this CDL Job: Priscilla GarciaGourmet Foods International Phone... 

ABM of South Dakota

Warehouse Janitorial Cleaner Job at ABM of South Dakota

 ...no tardies and no absences. **THIS IS A NEW FACILITY AND CONSTRUCTION IS STILL IN PROCESS, CLEAN UP IS THE FIRST MISSION! COME BE...  ...GROWTH AND OPPORTUNITY!! About the Job Set Schedule ( Night and Day shifts available ) | NO THC Testing | PAID TIME OFF | 401K | Medical... 

Specialty Care

Minimally Invasive Clinical Specialist I Job at Specialty Care

Minimally Invasive Clinical Specialist ISpecialtyCare is expanding! We are currently looking for the right candidate to start andtrain as a Minimally Invasive Clinical Specialist I (MIS) to work in and around the Operating Room. SpecialtyCare provides multi-stage...