Pl/Sql Database Analyst

Our client in public sector is looking for a PL/SQL database analyst to work on replacing current workflow system with a more modern version.

Contract duration: 6 months with extension option

Location: Hybrid - downtown Toronto

Responsibilities:

• A comprehensive documentation outlining the extracted business rules, presented clearly and accurately. These will be used as basis for constructing the new workflow solution.
• Produce Technical Analysis Report: A detailed report describing the technical analysis conducted on the existing system, highlighting insights and logic intricacies.
• Create a Quality Assurance Report: A report detailing the thorough quality checks performed on the extracted business rules, ensuring their accuracy and relevance
• Produce Integration Recommendations: Recommendations for integrating the extracted business rules into the new workflow management system, ensuring alignment with solution design.
• Utilize your PL/SQL skills to assess, understand, document existing business rules in the current workflow system.
• Create Decision Model Notation (DMN) Files: Translate business rules transformed into DMN files, ensuring their proper representation and compatibility with the designated format.

Experience:

• Strong understanding of DMN 1.1+ (Decision Model and Notation) and FEEL (Friendly Enough Expression Language) in order to deliver DMN models based on stored procedure.
• 5+ years experience in database administration and development for multiple environments (development, test and production databases), including writing scripts for data conversion, creating DDL scripts for database objects (tables, indexes, roles, stored procedures, functions, triggers, batch jobs, interfaces, etc.) using Oracle 19c, PL/SQL, SQL.
• 5+ years experience in Oracle administration and development, including managing standard database security utilizing user accounts, privileges, profiles and role-based security.