Provide a short description of the Position: Design, develop and implement solutions for multiple applications and projects for the Office of Mental Health using C#, .Net, MVC, PL/SQL, Crystal Reports and various other programming tools.
Provide a list of the day-to-day tasks to be performed by the Selected Candidate: Daily Tasks will include but are not limited to the following: 1. Work closely with the ITS manager, technical team members and other project stakeholders to provide guidance throughout the System Development Life Cycle (SDLC). 2. Use Microsoft Visual Studio 2022 or higher and write code using MVC Architecture, .Net Core, JavaScript, CI/CD, Ajax, HTML, XML and APIs. 3. Prepare scripts to create and modify existing Oracle tables, create indexes, constraints, triggers, views, etc., code stored procedures and packages, convert and migrate data when necessary. 4. Diagnose and troubleshoot various rules, calculations, and data issues on application reports using Crystal Reports. 5. Mentor and assist other programmers, providing guidance for debugging, troubleshooting, securing and deploying applications, data access, data communications and system architecture configurations. 6. Use a source code repository, such as GitLab for checking source code in and out, and branching off new versions of the source code. 7. Work within the IT Service Management System to take in incidents and service requests for the application, as well as request services from other ITS groups. Diagnose and debug production issues reported via ITSM. Escalate critical calls as necessary and join bridge calls to assist in diagnosis.