Software Developer III

Job Summary Reporting to the Manager, Information Architecture, this senior level developer role will lead software development projects and work closely with stakeholders to provide software solutions. The Software Developer III will research and design software modules to be implemented and maintained by the development team in support of business and educational delivery needs at CNC. The Software Developer III oversees the catalogue of custom developed and third-party software to maintain high business value, ensure information security, and to ensure interoperability between various systems. Specific Duties • Creates and builds software modules and specifications for use by the development team in support of development projects• Designs web, desktop and console applications in support of business and educational delivery requirements and in alignment with IT Services architectural goals• Writes efficient and maintainable code, markup and queries to build software applications• Development of programming standards and practices within languages and frameworks used at CNC• Plan and coordinate testing, changes, upgrades, and deployments to fulfill specified requirements• Performs code reviews to assess quality and provide feedback• Trains users on newly developed software• Provides direction, advice and resources for integrating new software into the CNC environment following information architecture guidelines• Assist with the development of policy, standards, and procedures to assist your team in achieving consistent, standards focused outcomes through the automation and reuse of software tools• Oversee complex data integration and migration activities between information systems using custom tools and APIs• Create, maintain, and troubleshoot complex, multi-table SQL queries which make use of advanced SQL features while ensuring a high level of query optimization• Perform database administration such as security configuration, backup restoration, and creation of maintenance plans• Design and implement database availability plans to ensure minimal disruption to business functionality• Identifies areas for improvement within existing programs and subsequently implements those improvements• Participate on committees and working groups as a subject matter expert• Assists with software procurement exercises, providing recommendations on functionality and interoperability with existing CNC systems• Ensures the confidentiality, security, and stewardship of data, including compliance with freedom of information and protection of privacy legislation• Monitor internal logs and vendor security and patch feeds to identify vulnerabilities and schedule and apply upgrades and patches for risk mitigation• Work closely with stakeholders to identify business objectives and assist with the creation of plans to achieve them• Coordinate project and issue resolution work with your team and other stakeholders• Enterprise systems user account management activities, such as setting up user accounts and passwords, and retrieving user information• Troubleshoot simple network issues using tools such as nslookup, ping, tracert, and ipconfig• You will be part of a team actively engaged in contributing to and accomplishing the vision, mission, and goals of the College and in supporting the aspirations and needs of our learners.• You will promote a positive work atmosphere by interacting and communicating in a professional manner that demonstrates mutual respect with students and colleagues.• Perform other related duties as assigned. Skills & Qualifications • Bachelor’s degree (or higher) specializing in Computer Science or Software Engineering from a recognized institution.• 3 years or more Minimum of three years current experience in software design and development or equivalent education and experience.• Experience in post-secondary education or the public sector is preferred• Experience using Microsoft development and web tools such as Visual Studio, SQL Server Management Studio, and Microsoft Internet Information Server• Experience with ASP.Net, C#, Razor pages, Blazor pages, ASP.Net Web APIs, Javascript, CSS, JQuery and Knockout.js• Understanding of Azure AD and Azure development tools• Understanding of how Entity Framework interoperates between databases and programming languages• Understanding of external tables, triggers, database links, indexing, and sub-queries in Microsoft SQL Server databases• Understanding of high availability concepts like clustering, load balancing and hot standby databases• Ability to enhance existing process performance through the use of advanced techniques like SQL plans, index choice, and materialized views• Understanding of Azure app registration• Ability to read and execute basic shell scripts such as batch files and PowerShell to automate administrative tasks• Ability to use source control to branch and merge repositories• Understand how content management systems work (eg. Sitefinity)• Familiarity with structured approaches to system configuration management• Ability to conduct technical risk analysis, benchmarking and baselining to assist with solution selection• Ability to create systems diagrams and models• Ability to provide assistance and advice to less experienced members of your team• Understanding of network concepts and terminology like connections, sessions, sockets, packets, IP address assignment, gateways, and DNS• Ability to prepare and distribute progress reports• Experience leading projects• Demonstrated commitment to service excellence and teamwork• Ability to work effectively and cooperatively with a diverse group of individuals or departments• Excellent communication skills, both written and verbal