Applications Systems Specialist - City of Vancouver

City of Vancouver

Applications Systems Specialist 

Requisition ID: 31977 

Company
Located on the traditional, ancestral and unceded lands of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səlilwətaɬ (Tsleil-Waututh), Vancouver has a commitment to becoming a City of Reconciliation. Vancouver consistently ranks as one of the world’s most liveable cities and is working towards being the greenest city in the world. Named among Canada's Top 100 Employers, BC's Top Employers, and Canada's Greenest Employers, the City of Vancouver seeks colleagues who can help shape and embody our core commitments to sustainability, decolonization, equity and outstanding quality of life for all residents.

Consider joining our committed team of staff and being part of an innovative, inclusive and rewarding workplace.

Main Purpose and Function
The Application Systems Specialist is responsible for software configuration, security management, server reliability, availability management activities, coordinating with vendors for software and hardware maintenance and upgrades to complex applications of significant business impact and usage, administrative and technical support for key computer applications, production deployments, and support of business processes.

The Application Systems Specialist works closely with vendors, internal City departments, and technical staff on issues involving operating system patch management, database management, business continuity requirements, service level agreements, package deployments, wireless network connectivity, and other activities necessary to maintain and enhance business applications.

Specific Duties and Responsibilities
  • Conducts system testing and integration testing to resolve systems issues and anomalies
  • Conducts regular server software maintenance and patching
  • Configures, tests, and installs new releases of, or enhancements to application systems
  • Conducts ongoing technical audits for IT systems, and tracks and reports anomalies to the team lead for the impacted system(s)
  • Works with IT staff, business staff and contractors to maintain and troubleshoot interactions and integration points between various enterprise systems, databases and other technologies
  • Investigates and resolves data integrity concerns
  • Designs, creates and supports reports for metrics and management needs
  • Designs and develops scripts for interfaces, notifications, and process automation
  • Writes SQL scripts to perform data extractions, queries and basic database updates
  • Analyzes systems configurations and code to assess functionality
  • Recommends procedural and technical changes to improve systems functioning
  • Researches new products and hardware and process changes; evaluates, tests, and documents recommendations
  • Conducts ongoing application configuration and verifies systems configuration
  • Monitors application server system alerts and logs
  • Monitors and tracks status of operationally critical systems
  • Maintains application security and user administration
  • Prepares and maintains detailed system documentation and technical training materials
  • Participates in the secure delivery of PCI systems. Provides support and training to IT staff and business clients
  • Acts as the technical liaison with vendors and business partners
  • Leads implementation of system components of larger projects to implement new products and process changes, including:
    • Task assignment, tracking, and implementation for both IT and internal City staff
    • Determines standards and procedures applicable for tasks
    • Documents tasks and provides updates to the Project Manager
    • Coordinates activities between other IT teams and internal City staff

     
  • Keeps up‑to‑date with systems infrastructure, programming languages and scripting, operating systems, and database management software
  • Other duties/responsibilities, as assigned

Qualifications
Education and Experience:
  • Completion of a Computer Systems Technologies two-year diploma course at a technical institute plus sound experience in programming; OR an equivalent combination of training and experience
  • 5+ years of proven experience in applications systems support and IT operations for a range of environments and platforms
  • 2+ years of experience in:
    • Configuration and administration of client/server, commercial off the shelf systems, and web-based applications
    • Scripting (e.g. PowerShell) and automation of repeatable processes
    • Customer service delivery and client communications related to application administration and security administration
    • Windows server management, ColdFusion Server Management, IIS and TomCat configuration
    • Desktop PC configuration, including peripherals (POS devices, scanners, printers, etc.)
    • Relational databases – Oracle, MS SQL 2016 and above
    • Deployment techniques (TFS, Octopus, CI/CD continuous integration / delivery)
    • Information technology concepts for networking, operating systems, security tools and techniques, and authentication (e.g. Kerberos)
  • Experience with IaaS Infrastructure as a Service, and experience in DevOps
  • Experience with the software development lifecycle, and common models (Agile, Kanban, iterative, waterfall, etc.) with familiarity in best software practices including source code control, requirements gathering and unit testing
  • Experience working with POSSE desirable

Knowledge, Skills, and Abilities:
  • Thorough working knowledge of office productivity tools (e.g. Windows, MS Office, MS Project, Visio, etc.), database tools and integrated development environment
  • Strong analytical and problem-solving skills
  • Combination of strong technical and business skills
  • Demonstrated ability to work both independently and as a member of a team
  • Excellent oral, written and presentation skills with ability to communicate to all levels of the organization
  • Ability to use SQL programming language to extract data from databases
  • Ability to use reporting software such as SQL Reporting Services, Crystal Reports and MS Access to extract and report data is desirable
  • Ability to manage projects, multiple priorities and respond to requests in a timely manner
  • Ability to establish and maintain effective working relationships both internally and externally with technical and non-technical staff
  • Ability to handle business critical and sensitive information
  • Demonstrated ability to work under pressure, manage multiple priorities and respond to requests in a timely manner
  • Continuous improvement and continuous learning mindset
  • Familiar with: programming in .NET environment, Web Services, and JavaScript
  • Desirable: a Microsoft Certified Professional – Enterprise Administrator certification, or equivalent

Business Unit/Department: IT, Digital Strategy & 311 (1070) 

Affiliation: CUPE 15 Non Pks 

Employment Type: Temporary Full Time 

Position Start Date: September, 2021

Position End Date: December, 2022 

Salary Information: Pay Grade GR-027: $42.96 to $50.76 per hour

Application Close: September 24, 2021

At the City of Vancouver, we are committed to recruiting a diverse workforce that represents the community we so proudly serve. Indigenous applicants, people of colour, all genders, LGBT2Q+ and persons with disabilities are encouraged to apply.  Accommodations will be provided upon request during the selection process.Learn more about our commitment to diversity and inclusion

To be considered for this exciting and impactful career opportunity with a generous benefits package, please apply on our careers site.

Apply here

Organization: City of Vancouver
Location: Vancouver, BC
Region: Lower Mainland
Professional Category(s): Information Technology
Posted: September 15, 2021, 12:15 pm
Expires: September 24, 2021, 4:30 pm

Employment Type: Full Time
Employment Length: Temporary
Education Requirement: College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 years
Job Experience: 5 years or more
Rate: $42.96 to $50.76 Hour

Back to Top

National Education Award

Civicjobs.ca supports education in the Local Government sector.

Tools & Resources

Canada's #1 Local Government job posting website.

Postings by Email

Receive email alerts, or sign up for our weekly e-bulletin.