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
Requirements
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.
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.