Job ID #32190: Application Support Analyst

City Of Hamilton; Hamilton; On-site; CAD 65,000 - 90,000; Full time

Job summary

The City of Hamilton is seeking an Application Support Analyst to design, code, test and maintain web-based cloud applications that support business activities. You will work with in-house and packaged solutions, translating functional specs into reliable code and test plans, while contributing to ongoing maintenance, documentation and improvements.

Applicants should have a degree or diploma in computer science or related fields, strong SQL/DB skills, and experience with SharePoint, Power

Qualifications

• University Degree or College Diploma in Computer Science, Information Systems, or related discipline.
• Experience supporting packaged solutions and developing/maintaining cloud-based applications.
• Knowledge of relational databases (SQL Server, Oracle) and SQL.

Responsibilities

• Design, code, test and support in-house and packaged cloud applications.
• Analyze functional specs and translate into technical specifications and code.
• Develop unit tests, scripts and data for validation and ensure quality assurance.

Skills

SharePoint

Power Platform

D365

SQL

C#.Net

VB.Net

JavaScript

TypeScript

XML

REST/SOAP

Azure DevOps

SOA integration

Cloud-based solutions

Education

University Degree, College Diploma in Computer Science or related discipline

Tools

SQL Server

Oracle

BizTalk

Azure

Job description

Contribute to the City of Hamilton, one of Canada’s largest cities - home to a diverse and strong economy, an active and inclusive community, a robust cultural and dining scene, hundreds of kilometers of hiking trails and natural beauty just minutes from the downtown core, and so much more. Join our diverse team of talented and ambitious staff who embody our values of sensational service, courageous change, steadfast integrity, collective ownership and being engaged empowered employees. Help us achieve our vision of being the best place to raise a child and age successfully. #BeTheReason

• Job ID #32190: Application Support Analyst
• Union: CUPE Local 5167
• Job Description ID #: 6393
• Duration: Up to 15 months
• Vacancy type: This posting is for an existing vacancy

Summary Of Duties

Reporting to the Supervisor, Business Applications (Business Services), the Application Support Analyst analyzes, designs, codes and maintains transactional, analytical and administrative custom and packaged, web-based cloud applications that support key business activities. Through project and operational roles for in-house developed applications, the Application Support Analyst is responsible for application and interface programming to resolve issues, DBMS coding and other scripting, developing test plans and scripts, generating test data and unit testing and conducting application testing.

As part of the Business Applications section, the Application Support Analyst supports and maintains enterprise and departmental systems, configures, , updates, and deploys custom cloud-developed, small to medium-scale applications. The development and maintenance of applications will conform to defined application strategies, architectures, specifications and the Application Support Analyst will apply established lifecycle development methodologies and change management processes.

GENERAL DUTIES

• For applications developed in-house, design, code, test and provide ongoing support for web-based cloud applications and their components, considering performance, serviceability, usability and maintainability, interfacing as directed with client in requirements gathering activities.
• For vendor packaged applications, provide ongoing second level support for web-based cloud applications and their components, considering performance, serviceability, usability and maintainability, interfacing as directed with client in requirements gathering activities.
• Analyze functional specifications and develop detailed technical specifications for new functionality and enhancements to existing functionality for custom and/or package applications.
• Develop application code from functional and technical specifications for in-house developed applications and packaged applications.
• Review product road maps, their update and patch schedules and make configuration or environment changes, as required.
• When required and approved, develop custom coding to modify, enhance and debug package solutions currently implemented at the City.
• Determine optimal code design, structure, program logic from detailed functional and technical specifications and process/business flows.
• Design, develop and execute unit test scenarios and plans including development of test cases and test scripts based upon design documentation in collaboration with the identified quality assurance and business process resources.
• Perform component testing and participate in the review of regression, system, user acceptance and stress tests and code promotion to production.
• Participate in the development and maintenance of application documentation for in-house and packaged solutions.
• Prepare or contribute to work plans including time/effort estimates to build, enhance, or implement application code and logic.
• Follow established SDLC methodologies, identifying areas for improvement and participating in their refinement as they are implemented at the City.
• Document issues/problems in relevant logs; participate in review of such issue/problem logs and in the identification of potential resolutions.
• Research, compile and synthesize information with regard to application development and maintenance processes for custom and packaged applications.
• Collaborate on cross-functional teams with other City staff and consultants that may be involved in application development projects throughout the Corporation.
• Maintain an effective and collaborative relationship with Information Technology staff and Vendors of packaged applications to assist with quality assurance, program logic, and data processing activities.
• Respond to application issues from the user community, normally via the service desk or as assigned; troubleshoot problems, work with systems analyst and Vendors as required to resolve issues and identify root cause. Escalate as required.
• Produce work products pertaining to the work assigned with initial guidance and moderate autonomy. Manage and report on application development, programming and testing activities for own work.
• May be required to provide on call support to users.
• Work in accordance with the provisions of applicable Health and Safety legislation and all City of Hamilton corporate and departmental policies and procedures related to Occupational Health and Safety.
• Perform other duties as assigned, which are directly related to the major responsibilities of the job.

Qualifications

• University Degree, College Diploma in Computer Science, Information Systems or related discipline
• Previous experience in supporting packaged solutions, application development and maintenance as an Application Support Analyst for cloud based-solutions in Microsoft SharePoint, Power Platform, or D365..
• Working knowledge of relational database management system software (ORACLE, SQL Server along with Microsoft Access) and SQL (Structured Query Language).
• Demonstrated ability to write, interpret and modify one or more standard computer programming and scripting language commonly used in the development and support of cloud-based solutions, such as C#.Net and VB.Net, SQL, , XML, JavaScript, Liquid Markup, and TypeScript.
• Working knowledge of SOAP and RESTful web services and Azure DevOps.
• Demonstrated experience integrating applications in a service-oriented architecture (SOA) environment using web services. Knowledge in Biztalk or other middleware platform is an asset.
• Working knowledge of application development lifecycles and supporting practices.
• Ability to translate functional and technical specifications into program code and logic.
• Experience creating and executing unit test plans/scripts.
• Knowledge of fundamental ITIL standards.
• Proven analytical and problem-solving abilities.
• Ability to make sound and logical judgments.
• Strong interpersonal, written, and oral communication skills.

NOTE 1:
As a condition of employment, the successful applicant(s) will be required to achieve a
satisfactory Criminal Record and Judicial Matters Check (CRJMC).

NOTE 2:
As a condition of employment, the successful applicant(s) will be required to undergo a Social Media Background Check which will be conducted by Human Resources. This report must meet the employer’s satisfaction to proceed with employment.

SALARY:
Salary Grade M

HOURS:
35 per week

Disclaimer:
Be advised that Human Resources frequently audits resumes of internal/external applicants to ensure/validate information provided is consistent and trustworthy. Falsification of information provided at any time throughout the recruitment process may be grounds for disqualification, and for internal applicants, subject to discipline up to and including termination.

Terms:
The City is an equal opportunity employer that is committed to inclusive, barrier-free recruitment and selection processes. Consistent with our Values and Corporate Culture Pillars, the City of Hamilton is committed to providing equitable treatment to all with respect to barrier-free employment and accommodation without discrimination. The City will provide accommodation for applicants in all aspects of the hiring process, up to the point of undue hardship. If you have an accommodation need, please contact Human Resources as soon as possible to make appropriate arrangements.