Temporary Solutions Integration Specialist (up to 8 months)

City of Saint John; New Brunswick; On-site; CAD 61,000 - 79,000; Full time

Job summary

City of Saint John is seeking an IT professional to administer and maintain the City’s website, web-based applications, data and enterprise systems. The role involves planning IT updates, configuring a range of applications, and guiding upgrades to ensure performance and security.

You will work with IT teams and vendors, document procedures, and participate in after-hours support on a rotation basis. Candidates should have strong Windows, SQL/Oracle and web tech skills.

Qualifications

• Strong working knowledge of Windows 10/11, productivity tools and data platforms.
• Experience with web interfaces, data integration and enterprise reporting tools.
• Proficiency in SQL/Oracle databases and basic scripting (PowerShell).
• Familiarity with cybersecurity best practices and data transfer interfaces.
• Ability to manage projects and communicate with vendors and teams.

Responsibilities

• Plan and implement IT changes for city software, applications and databases.
• Configure parameters for IT applications and interfaces.
• Guide development, installation, maintenance and upgrades of websites, apps, databases, or servers.
• Develop IT policies and SOPs for website, applications, and data.
• Monitor security configurations and ensure compliance with policies.
• Troubleshoot and coordinate with vendors and IT staff to resolve issues.
• Document processes and maintain records as required.
• Collaborate with stakeholders to achieve objectives.
• Provide after-hours support on a rotation basis.

Skills

Windows 10/11

Microsoft Office

SharePoint Online

Power Platform

Visio/Archimate

Cognos/Crystal Reports

SQL/Oracle

HTML/CSS

ASP.NET/JavaScript

XML/JSON

PowerShell

Cybersecurity basics

Project management

Education

Two-year diploma in database administration

University degree in Computer Science or related

Tools

Power BI

Crystal Reports

Cognos

SQL Server management

Job description

Position Overview

Under the direction of the IT Manager, the position is responsible for administration, implementation, and maintenance of the City’s website, web-based applications, software, data (including databases and interfaces), enterprise system and other applications.

• Plan and recommend information technology changes and or enhancements to the City’s software, applications, and databases to address specific problems or business requirements.
• Determine and implement configuration parameters for a wide variety of IT applications and interfaces
• Plan and guide the development, installation, maintenance, upgrades and repair of the City’s website, IT applications, databases, or servers as required
• Contribute to the development and implementation of IT policies and standard operating procedures related to the website, applications, and data
• Administer and monitor the security measures and configurations for applications and databases to ensure compliance with policies and standard operation procedures
• Maintain applications operation and ensure quick problem resolution as per the service level standards by monitoring all essential components of the application or database, establishing effective working relationships with vendors and communicating with the IT team
• Report and/or develop recommendations on the website, applications and database system performance, and security
• Complete and maintain documentation, as required.
• Works collaboratively with IT team members, customers, and other stakeholders to achieve objectives.
• Participate, on a rotation basis, in providing after hours support to users throughout the organization. Additional after-hours commitment may be required for application and database maintenance.
• Increase in responsibility and pay band with experience and certifications.

Competition Number

26-095

Salary

$61,043.00 - $79,412.00/Year

Job Type

Temporary Full Time

Closing Date

October 29, 2026

Position Overview

Under the direction of the IT Manager, the position is responsible for administration, implementation, and maintenance of the City’s website, web-based applications, software, data (including databases and interfaces), enterprise system and other applications.

• Plan and recommend information technology changes and or enhancements to the City’s software, applications, and databases to address specific problems or business requirements.
• Determine and implement configuration parameters for a wide variety of IT applications and interfaces
• Plan and guide the development, installation, maintenance, upgrades and repair of the City’s website, IT applications, databases, or servers as required
• Contribute to the development and implementation of IT policies and standard operating procedures related to the website, applications, and data
• Administer and monitor the security measures and configurations for applications and databases to ensure compliance with policies and standard operation procedures
• Maintain applications operation and ensure quick problem resolution as per the service level standards by monitoring all essential components of the application or database, establishing effective working relationships with vendors and communicating with the IT team
• Report and/or develop recommendations on the website, applications and database system performance, and security
• Complete and maintain documentation, as required.
• Works collaboratively with IT team members, customers, and other stakeholders to achieve objectives.
• Participate, on a rotation basis, in providing after hours support to users throughout the organization. Additional after-hours commitment may be required for application and database maintenance.
• Increase in responsibility and pay band with experience and certifications.

Essential Qualifications

• Strong working knowledge in one or more of the following aspects:
• Windows 10 or 11
• Microsoft Productivity Tools (Word, Excel, Power BI)
• Microsoft SharePoint Online and OneDrive, Power Platform
• Process mapping and architecture drawing software such as, MS Visio or Archimate
• Report Writing Tools, such as Cognos, Crystal Reports or other enterprise report writing tool
• SQL and Oracle Databases
• Web interfaces and data integration
• HTML / CSS
• ASP.NET
• JavaScript
• XML / XSLT / JSON
• Basic understanding in one or more of the following aspects:
• Networking, such as Active Directory, M365 administration, SQL server management, and/or Exchange)
• Developing PowerShell scripts
• Understanding with HTML5, CSS3, SQL, Javascript, PHP
• Laserfiche, escribe or other document repository systems
• Mobile app functionality
• Software implementation projects
• Strong technical, problem determination and resolution skills.
• Strong communication skills both verbal and written.
• Ability to identify, communicate and collaborate, with stakeholders including vendors and outside agencies
• Ability to establish, maintain and promote friendly, cooperative, and productive relationships with various members of the IT team.
• Must possess exceptional problem solving, critical thinking and analytical skills to troubleshoot and resolve issues and challenges.
• Ability to act with considerable degree of independence, scope, latitude, initiative and judgment in satisfying priorities, deadlines and requests concerning projects and issues being managed.
• Must have a demonstrated understanding of the underlying concepts of project management methodologies.
• Must have a demonstrated experience using project management methodologies.
• Must have a demonstrated understanding of cybersecurity best practices for program or data transfer interface protocols
• Must have a demonstrated experience with data analysis and report generation using tools such as Power BI, Crystal Reports or Cognos
• Must maintain expert knowledge of current technological developments / trends in area of expertise.
• Ability to handle emergency situations in a calm and directed fashion, and lead teams in a such situations as needed.

Education, Training & Experience

• Completion of a two-year diploma program in database administration, or programming from an accredited college OR completion of a university degree in Computer Science or in a related discipline.
• This position requires the technical and operational acumen generally gained through progressive training and experience managing websites, IT applications & databases.
• Number of years of IT field experience combined with certifications will be considered in the hiring process.

Must be Security Cleared. Must take Oath of Confidentiality. Must have Class 5 driver’s license.

The successful applicant may be eligible to participate in a Flexible Time Options Program which includes the option of working a 4 or 5-day work week, subject to business requirements.

Equal Opportunity Employer

We are an Equal Opportunity Employer. We are committed to building a workforce that reflects the diversity of the communities in which we live and which we serve. We encourage and support applications from Indigenous persons, persons with disabilities, and members of visible minority groups. Candidates who belong to such groups, who are qualified, will be given preference at the time of selection.