Applications Systems Specialist - REPOST

Requisition ID: 31977 


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



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


All City of Vancouver employees are required to be fully vaccinated as a condition of hire and ongoing employment.  Candidates may only be exempted from this requirement if they request and are approved for an accommodation based a reason related to a Human Rights Code ground (such as disability). Such a request must be made during, not after, the recruitment process. 


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

Affiliation: CUPE 15 Non Pks 

Employment Type: Temporary Full Time 

Position Start Date: February, 2022

Position End Date: December, 2022

Salary Information: Pay Grade GR-027: $43.82 to $51.78 per hour


Application Close: January 21, 2022

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


Before you click Apply now

Once you start your application you can save your work and leave the applications page, however please remember to submit your profile to the specific job requisition before the posting closing date.

In addition to uploading your cover letter and resume, part of the application process may include answering application questions related to the preferred requirements of the role which may take approx.. 5-10mins. Cover letters should express interest and highlight additional information relevant to the position and resumes should include a tailored summary of skills and experience related to the position.


Job Segment: Network, Oracle, Database, Developer, Testing, Technology