.Net developer

Design: 1. Special Education Hearings Case Management System (CMS):

o Design new workflows for the Special Education Hearings CMS using C#, ASP.NET, .NET MVC, .NET Core, and SQL Server 2019.

o Develop the front-end of the CMS using HTML, CSS, JavaScript, and Angular 8.

2. Application Submission Portal:

o Design and build an online submission portal for forms with embedded business rules and workflows.
o Ensure forms and workflows are mobile-responsive with key features accessible via mobile devices, including:
• Viewing case status.
• Reviewing and approving documents.

3. Bi-directional Web Services:

o Design and implement web services to integrate the CMS with external portals and process data files from various agencies.
o Build authentication web services to handle internal user authentication via Active Directory (AD) and manage user permissions.

4. New Workflow Features:

o Design and implement workflows to:
• Process online submitted forms.
• Support calendaring and scheduling for hearing rooms and related activities.

5. Reporting & Error Management:

o Design and develop new reports for the CMS using SSRS and Crystal Reports.
o Implement logic to capture and display error/warning messages during hearings.

Coding:
1. Development Framework:

o Develop the application using Service-Oriented Architecture (SOA) and ModelView-Controller (MVC) patterns.
o Apply Façade, Factory, Singleton design patterns for better application structure and scalability. o Utilize Database Access Application Block (DAAB) and Exception Handling Application Block (EHAP) for enhanced data access and error handling.

2. Technology Stack:

o Code using C#, ASP.NET, .NET MVC, .NET Core, SQL Server 2019, HTML, CSS, JavaScript, Angular 8, REST and SOAP Web Services, XML, SSRS, and Crystal Reports.

3. Web Services Development:

o Create new web services for:
• Communicating and processing data files from external agencies.
• Scanning service compatible with Microsoft Edge.
• Audio and video recording services compatible with Microsoft Edge.

Testing:
1. Unit Testing:
o Design and prepare unit test cases to ensure functionality meets requirements and to identify and fix bugs early in the development process.
o Conduct unit tests on the application code to verify compliance with design specifications.
o Deploy the code in a testing environment for sanity, regression, and functional testing before passing to the QA team for further validation.

MANDATORY SKILLS/EXPERIENCE Note: candidates who do not have the mandatory skills will not be considered
The selected candidate must have a minimum of 4 years' experience as described in "Attachment 2 - City Labor Category Description" for Programmer 2.

Backend Technologies:

o C#: Must have strong experience in C# for backend development, including writing clean, maintainable, and performant code.

o ASP.NET MVC: Proven experience in ASP.NET MVC for building scalable, maintainable web applications.

o .NET Core: Deep understanding and hands-on experience with .NET Core for building robust, highperformance, cross-platform applications.

Entity Framework (EF):

o Experience in EF Core or EF 6 for object-relational mapping (ORM).
o Experience in Code First or Database First approaches with EF.
o Proficient in writing LINQ queries to interact with databases.
o Strong understanding of EF migrations, optimizing EF queries, and managing complex data relationships.

o SQL Server 2019: Must have experience in designing databases, writing optimized SQL queries, stored procedures, and handling database performance tuning in SQL Server 2019.

Web Services:

o RESTful APIs: Experience in designing and consuming REST APIs using ASP.NET Core Web API.
o SOAP Web Services: Hands-on experience in working with SOAP web services, WSDL, and XML-based services.

Frontend Technologies:

o HTML/CSS: Solid knowledge of HTML5 and CSS3 for responsive web design and UI development.
o JavaScript: Proficient in JavaScript (ES6+), with the ability to write clean, efficient code for dynamic web functionality.
o Angular 8: In-depth experience in developing Single Page Applications (SPAs) using Angular 8, including knowledge of components, directives, services, and routing.

Reporting & Data Presentation:

o SSRS (SQL Server Reporting Services): Hands-on experience with SSRS to create and deploy interactive, parameterized reports integrated within a web application.
o Crystal Reports: Strong experience in designing and generating reports using Crystal Reports and embedding them into applications.

Software Design & Architecture:

o MVC Architecture: Solid understanding of the Model-View-Controller (MVC) architecture for web application development.
o Design Patterns: Experience with common design patterns like Repository Pattern, Factory Pattern, and Singleton Pattern.

o Unit Testing & TDD: Experience with Unit Testing using frameworks such as XUnit, MSTest, or NUnit. Familiar with Test-Driven Development (TDD) practices to ensure high code quality.

Version Control & CI/CD:

o Git: Proficiency in using Git for version control and collaboration in a team-based environment.

o CI/CD: Hands-on experience with Continuous Integration and Continuous Deployment (CI/CD) practices using tools like Azure DevOps, Jenkins, or GitLab CI.

Security:

o Authentication/Authorization: Experience in implementing user authentication and authorization, including OAuth, JWT (JSON Web Tokens), and role-based access control (RBAC) in a web application. OATH Consultant Services Scope of services


Soft Skills:

o Communication: Excellent communication skills to effectively collaborate with cross-functional teams, stakeholders, and non-technical team members.
o Problem-Solving: Strong analytical and problem-solving abilities to troubleshoot issues and devise optimal solutions.


Additional Preferred (Non-Mandatory) Skills:
• Microservices Architecture: Experience in designing and developing microservicesbased applications.
• Performance Optimization: Proven track record of optimizing both frontend and backend performance, including database query optimization.
• Containerization (Docker/Kubernetes): Familiarity with containerizing applications and deploying them using Docker and Kubernetes for scaling.

DESIRABLE SKILLS/EXPERIENCE: - Note: candidates who do not have the mandatory skills will not be considered
The selected candidate must have excellent verbal and written communication skills and have the ability to interact professionally with a diverse group including executives, managers, and subject matter experts. The candidate should be a team player.