Dotnet Developer

Terms of Reference BackgroundThe City is looking for a Senior Razor Pages Developer with .Net, C# and Oracle database experience to help with a web development project. The City’s Information Technology Services (ITS) Database Administration (DBA) team supports three websites for its Enterprise Directory Services (EDS) application. These websites must be modernized. The websites are currently using a .Net framework and will be rebuilt using Razor Pages. The business functionality will resemble the current websites, with enhancements to security and usability. Documentation, mentoring, and knowledge transfer are requirements for this project.

ObjectiveThe overall objective is to rebuild the existing three EDS websites using RazorPages. Requirements include:• Integration with Active Directory (AD)• Assessment to determine if the sites should be consolidated or remain separated.• Provide feedback on the design and recommended changes.• Design the website to resemble the architecture used for the DBA team’sAdmin website.• Integration with Database Oracle 19• Integration with CyberArk Secrets Management• Resemble former websites from a functionality point of view.• Support on the setup of the new web servers 2022• Publishing into new web servers (Windows 2022)• Accessibility review and enhancements• Complete documentation on site architecture, security, design, database integration and authentication/ authorization design.• Knowledge transfer to employees

Scope of Work / Project Description

EDS WEBSITE Phase 1This phase is to review the EDS websites in detail. The resource will also have access to the DBA Admin site to provide some references for consistency as the City would like to model it similarly where possible. After this, the City will review the findings and determine the next steps.1. Review the current .Net website and underlying database model.2. Support Configuring the new development, test/QA and production web servers based on City standards, including TLS certificates for encryptedconnections. The OS will be Windows 2022.

Phase 21. Develop the new website EDS Admin using a Visual Studio Razor Pages.2. Front side will need to include AODA design were possible.3. Leverage Azure DevOps for code repository.4. Replicate the core functionality of the existing website.5. Implement AD authenticated access based on group membership and one single City authentication process.6. Ensure the database knows the underlying OS user connecting to it.7. Document the website design and architecture.8. Provide knowledge transfer to the DBA team to ensure they can continue supporting it.

Phase 31. Develop the new website EDS Reporting using a Visual Studio RazorPages. Front side will need to include AODA design were possible.2. Leverage Azure DevOps for code repository.3. Replicate the core functionality of the existing website.4. Add new core functionalities based on client requirements.5. Implement AD authenticated access based on group membership.6. Ensure the database knows the underlying OS user connecting to it.7. Document the website design and architecture.8. Provide knowledge transfer to the DBA team to ensure they can continue supporting it.

Phase 41. Develop the new website EDS Self-Serve using a Visual Studio Razor Pages. Front side shall include AODA design were possible and responsive web design.2. Leverage Azure DevOps for code repository.3. Replicate the core functionality of the existing website.4. Implement AD authenticated access based on group membership.5. Ensure the database knows the underlying OS user connecting to it.6. Document the website design and architecture.7. Provide knowledge transfer to the DBA team to ensure they can continue supporting it. Project DeliverablesThe requirement is to rebuild the existing .Net website using Razor Pages. The general functionality can mimic the existing site providing a good idea for structure and functionality. The website coding must be done with simplicity in mind to ensure it can be reasonably supported by the DBA team moving forward, while still addressing secure development and design. 1. Initial Design ReportAfter reviewing the existing code for the EDS website, discussing with the EDS Solution Manager, provide an initial design report outlining the framework and tasks. The report may include findings, challenges, and recommendations. This will be to ensure all parties are on the same page. 2. Development Server & WebsiteAfter completing the initial design report, proceed with configuring the developing the website and validate the web server configuration to support it. Work will be coordinated with the project coordinator for the database elements and server setup. Functional validation will be completed before proceeding to the test servers. This can be done in phases as desired. 3. Test Server & WebsiteConfiguring the test web server and migrate code for further testing by the project coordinator. 4. Production Server & WebsiteConfiguring the production web server and migrate code for further testing by the project coordinator using a test database. Assist with the final cutover. 5. Documentation & Knowledge Transfer

Knowledge transfer must be provided to two (2) developers. This must be in the form of both a document outlining the framework, release/migration between environment processes, and web server setup, as well as virtual sessions reviewing code samples and code design.

Information and/or Services to be provided by the City• The City DBA team and EDS Solution Manager will manage all the database development work. They will create / test the procedures and packages for interacting with the database (inserts, updates, deletes).• The City EDS team will act as the subject matter experts for all tasks.• The City EDS Solution Manager will assist with setting up the Azure DevOps repository and providing access.• The City will provide access to the required technologies.• The City will provide a city network account and email address, with O365 licenses to enable MS Teams meetings, and email. Incumbent StatusThere is no incumbent in this role. Special RequirementsMost work will be performed remotely with the possibility of some on-site strategy sessions at 100 Constellation Drive, Ottawa.

Rated Requirements Project Experience (maximum 30 points)Respondents should describe the project experience of the Resource with three relevant projects of similar scope and magnitude, undertaken in the previous five years. Each project example should demonstrate the Resource’s project experience relevant to the Terms of Reference as outlined in Annex A. Respondents should complete the form provided as Appendix 1 – Project Description Forms (tables 3-5), to describe the Resource’s project experience. Respondents should use one form for each project experience description. The City will only evaluate three examples. Ten points will be assigned to each of the three requested project samples. If more than three project examples are provided, only the first three will be evaluated. Respondents are required to achieve a minimum score of 70% (21 out of 30) on B.1. Failure to achieve the minimum score will render a response non- responsive.

Relevant Experience (maximum 30 points)Respondents should describe the relevant experience of the Resource relevant to the Terms of Reference as outlined in Annex A. Respondents should complete the form provided as Appendix 2 – RelevantExperience Form (tables 6), to describe the Resource’s relevant experience. The Resource should demonstrate:• Ten (10) years of experience developing software architecture within large scale IM/IT technical environments. • Three (3) years of experience performing software development using Razor Pages and .Net and associated technologies within large scale technical environments including C#. • Five (5) years of experience performing software development using Microsoft Visual Studio, with three (3) years of experience working with Microsoft Visual Studio 2017/2022. • Five (5) years of experience integrating Oracle databases into web- based software applications with three (3) years of experience working with Oracle 12 or Oracle 19.

• Five (5) years of experience working within large IM/IT environments that utilized DevOps software development practices through the systems development lifecycle for a variety of IM/IT projects. • Three (3) years developing web sites with UX best practices. • Two (2) years of experience utilizing Azure DevOps for repos. • Experience developing Oracle procedures. • Experience working in an Agile environment. • Experience writing documentation. • Knowledge of Web Accessibility principles, Accessibility for Ontarians with Disabilities Act (AODA), and experience building Web Content Accessibility Guidelines (WCAG) 2.0 AA compliant websites • Strong interpersonal, communication and presentation skills • Leadership skills and ability to work well in a team environment.

Resource Education, Accreditation and Qualifications (maximum 10 points) Respondents should complete the form provided as Appendix 3 Resource Education, Accreditation and Qualifications (table 7), to outline the Resource’s Qualifications and Academic Standing relevant to the Terms of Reference outlined in Annex A. Respondents should have:• Three-year university degree or three-year college diploma inComputer Information Systems or a related discipline

Key Skills

• Project Management
• Marketing