Description:

Task 1

Monthly Performance Status Report

Deliverables

· All deliverables that consultant worked on during past month are included

· Progress and specific accomplishment against the deliverable are described

· Status of consultant's deliverable compared to the project Baseline

Estimated Completion Date

Monthly

Task 2

Perform systems, data and impact analysis on existing legacy Driver, Vehicle and other related systems

Deliverables

· Systems and data impact analysis

· Technical specifications of programs, transactions, workflows, interactions and interfaces

· Documentation of business and data rules, constraints, and data relationships

· Documentation of data profiling and data cleansing requirements

· Design, code and testing of data analysis, profiling and cleansing scripts and program

· All the deliverables to be reviewed and approved by MTO staff

Estimated Completion Date

According to the project schedule to be defined by the Project Manager or Technical

Coordinator

Task 3

Knowledge transfer to Ministry staffs or resources designated by the Ministry

Deliverables

· Documentations

· Walk-through sessions of all the deliverables

Estimated Completion Date

Throughout the project

Experience and Skill Set Requirements:

Must Haves:

• Looking for strong Java Developers.
  
• Experience with development of efficient data access layers using Spring Data JPA, with custom JPQL queries.
  
• Experience with JSON serialization, Base64 encoding, and secure data handling
  
• Proven ability to leverage Azure Durable Functions for managing complex business processes, including function chaining, fan-out/fan-in patterns.
  
• Extensive experience in Java, Spring Boot, and RESTful API design.
  
• Extensive experience with containerized microservices (Docker, Kubernetes, AKS).
  
• Collaborate on CI/CD pipelines (Azure DevOps) to automate container builds and deployments on AKS.
  
• Develop and deploy Spring Boot microservices that process orders, manage payments, and interface with external systems.
  
• Microservices
  

Skill Set Requirements:

• Proven experience in design and development of mainframe applications and client/server applications
  
• Experience in using JCL, TSO/ISPF, BTS, PLI, COBOL, RPG3/4, SQL, PL/SQL, stored procedure, REXX, CLIST, IMS DB/DC, DB2 and IMS Connect
  
• Experience with all stages of automated system implementation in large complex high-volume Client/Server systems, with online Mainframe Transactions
  
• Experience with relational and hierarchical database with high volume of data
  
• Experience in data extraction, data analysis, data quality and data masking for mainframe IMS and DB2 data
  
• Experience in structured methodologies for the development, design, implementation, and maintenance of applications
  
• Experience with software development methodologies, including Agile methodology
  
• Experience with IBM 3270SNA communications and Communications Manager
  
• Experience with relational and hierarchical database technologies
  
• Experience in the use of object-oriented and/or third-generation language development tools
  
• Experience in the use of information retrieval using query languages
  
• Experience with the Application Lifecycle Management (ALM) Tool
  
• Experience working in accordance with policies and procedures of Ontario Public Service
  
• Experience working in accordance with policies and procedures of Ontario Public Service
  
• Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal and negotiation skills
  
• Ability to work independently and with good quality on concurrent multiple projects
  

Technical Skills:

• Develop and deploy Spring Boot microservices that process orders, manage payments, and interface external systems.
  
• Secure integration with external payment processors, notification systems, and client data services using Feign clients and JWT-based authentication.
  
• Implementation experience with distributed system patterns such as circuit breakers, retry logic, and rate limiting to ensure service resilience.
  
• Performance improvement and optimization using Redis caching and asynchronous processing techniques.
  
• Implement robust transaction management, ensuring data integrity across distributed services.
  
• Collaborate on CI/CD pipelines (Azure DevOps) to automate container builds and deployments on AKS.
  
• Drive observability by implementing structured logging and monitoring using Prometheus, Grafana, and Azure Monitor.
  
• Extensive experience in Java, Spring Boot, and RESTful API design.
  
• Extensive experience with containerized microservices (Docker, Kubernetes, AKS).
  
• Familiarity with service discovery, load balancing, and API Gateway integrations.
  
• Strong grasp of OAuth2, JWT, and secure communication in distributed environments.
  
• Experience with development of efficient data access layers using Spring Data JPA, with custom JPQL queries.
  
• Experience with service meshes (Istio), and policy-based routing.
  
• Experience designing and developing long-running business workflows.
  
• Experience with developing trigger & activity functions for atomic business operations and integrate them into orchestration workflows with retry and compensation logic.
  
• Implement compensation logic to roll back failed steps, ensuring transaction integrity.
  
• Experience with developing queries to monitor orchestration states, failures, and performance metrics.
  
• Experience with implementation of alerting mechanisms for failed orchestrations or SLA breaches.
  
• Ensure idempotency and deterministic behavior in all orchestration steps to maintain workflow reliability on replays.
  
• In-depth understanding of Saga patterns, distributed transaction management, and fault tolerance.
  
• Proficiency in handling asynchronous workflows, timers, and external event correlation.
  
• Experience with JSON serialization, Base64 encoding, and secure data handling.
  
• Experience in writing custom application monitoring queries to wrangle data from multiple sources.
  
• Proven ability to leverage Azure Durable Functions for managing complex business processes, including function chaining, fan-out/fan-in patterns.
  

Problem Solving and Communication:

• Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal and negotiation skills.
  
• Ability to work independently and with good quality on concurrent multiple projects.