GIS Applications Systems Specialist

  • Vancouver
  • City Of Vancouver
Requisition ID:  40654  Organization 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) Peoples, 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, reconciliation , 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 goal of the GIS & CADD Services Branch at the City of Vancouver is to empower City staff and citizens to effectively use geospatial information to improve decision making, analysis, city services and overall operations. We are currently implementing a strategic plan to renew the Geographic Information Systems (GIS) and related    applications. Major objectives are to create a robust governance and support model, strengthen and renew the  geospatial technology platform, maintain high quality geospatial data, provide data discovery and access, and develop high value geospatial applications.   This position is responsible for software configuration, security management, server reliability and availability management activities, as well as for coordination with vendors for software and hardware maintenance and upgrades to complex applications of significant business impact and usage. This position will liaise with 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.  This position will liaise with business staff across the city departments, as well as with vendors.  Duties also include administrative and technical support for key computer applications and support of business processes.    Specific Duties/Responsibilities System Maintenance and Technical Support:        Provides technical application support for a wide range of internally developed and 3rd party applications and platforms including desktop, network, client server, mobile, web, cloud, externally hosted environments Conducts system testing, integration testing to resolve systems issues and anomalies and to respond to customer enquiries  Conducts regular server software maintenance and patching Configures, tests, tracks, installs and manage new releases of, or enhancements to of server-based and workstation-based application systems  Conducts ongoing technical audits for IT systems, and tracks and reports any anomalies to the team lead 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   Advanced Technical Support:                           Designs, creates and supports reports for statistics and management needs Designs and develops automated scripts for interfaces and notifications Writes SQL scripts to perform data extractions, queries and basic database updates Analyzes systems configurations and code to assess functionality Participates in the development of architectural framework and design Recommends procedural and technical changes to improve systems functioning or adapt to new requirements Researches new products, hardware and process changes; evaluates, tests, documents recommendations   System Administration and Configuration: Conducts ongoing application configuration and configuration verification of systems Monitors database and application server system alerts and logs Monitors and tracks status of operationally critical systems Conducts security and user administration Prepares and maintains detailed system documentation and technical training materials Implements and monitors measures to ensure security of credit card information Work with the cybersecurity team to monitor, acknowledge and remediate application and server related security vulnerabilities, incidents, service requests, and unplanned outages   Backup and Support:                                       Provides support and training to IT staff  and to business clients  Acts as the technical liaison with vendors and business partners  Provides coverage for other IT team member duties as required   Project Management Duties:                              Leads application systems components of larger projects to implement new products and process changes including Assignments and tracking of tasks assigned to other IT staff and client staff Determines standards and procedures applicable for tasks Documents tasks and provides updates to project manager Plans implementation of tasks Coordinates activities between other IT teams  Minimum Position Requirements Education and Experience: Completion of a two-year diploma in Information Systems or Technology or an equivalent combination of education, training and experience is required Recommended Microsoft Certified Professional – Enterprise Administrator or equivalent Minimum of 5 years of experience in IT technical role Minimum of 2 years of experience in configuration and administration of client/server, commercial of the shelf systems, and web based business applications Some programming and analysis experience is highly desirable Experience in customer service delivery and client communications related to application and security administration    Knowledge, Skills and Abilities: Deep knowledge of the GIS application servers specific areas assigned to the position and wide knowledge of the following applications systems are desirable:  GIS, CADD, ESRI ArcGIS Enterprise, AGOL and ArcGIS Pro, ESRI’s geodatabase and Industry Model, FME, Autodesk Map 3D, Autodesk industry model (Topobase), and Google Maps Platform  City’s VanMap system, and its integration with other enterprise systems: Tempest, Infor/Hansen, Lagan, SAP, AMANDA, Open Data, and POSSE Experience in Windows server management, IIS configuration, Scripting (Windows PowerShell & Python), and ArcGIS API for Python Knowledge of desktop PCs and their configuration, software configuration and packaging, and knowledge with peripherals such as Point of sale (POS) devices, scanners, printers and related equipment Knowledge of relational databases – Oracle, MS SQL, Oracle Spatial, SQL Server Spatial Experience using ASP.NET deployment techniques, Web API, and MVC, and Web Services Experience in JavaScript, JQuery, and frontend frameworks such as Angular JS, Backbone, and Knockout JS Understanding of computer security concepts including identity & access management, network security and protocols, application security, and incident management Considerable knowledge of MS Office productivity tools, and Power Platform as asset  Experience in a hybrid (on premise and cloud) infrastructure and platform environment leveraging cloud services such as MS Azure, Amazon Web Services Demonstrated problem solving skills to investigate application system problems, formulate solutions, and seek assistance when required Ability to configure, test, and install new releases or enhancements to application systems Ability to make decisions and act quickly in an emergency situation, if required Ability to give advice, guidance, assistance or training staff in both manual and computerized system procedures  Ability to identify opportunities for process improvement Ability to develop, implement, and manage effective procedures related to the work, and to manage priorities and exercise independent judgment Superior customer service skills, strong oral and written communications skills, and the ability to establish and maintain effective working relationships with vendors, technical specialists, and staff Superior time management, organizational and interpretive skills, along with accuracy when performing detailed work Ability to work independently, and as part of a team Good attendance is of operational importance Ability to accommodate occasional variances in hours of work that may be required to ensure proper support coverage as per operational requirements.  Operations are 7:30 am – 6:00 pm Monday to Friday Ability to work after business hours, including weekends, to install application upgrades/releases Willingness to work on-call to address emergency situations or to work standby to provide extended support hours, including weekends Ability to handle multiple talks, deadline pressures, manage priorities,  exercise independent judgement, and work in an organized manner May be involved in sensitive, confidential or controversial problems and issues related to city staff   Where operationally appropriate and subject to change, the City of Vancouver has a Flexible Work Program. This program allows staff to work remotely 1 – 4 days a week from locations that are a daily commutable distance from their work at a City worksite.  At this time this position is eligible to be part of the Flexible Work Program.   Business Unit/Department:  IT, Digital Strategy & 311 (1070)  Affiliation:  CUPE 15 Non Pks  Employment Type:  Regular Full Time  Position Start Date: May, 2024    Salary Information: Pay Grade GR-027: $47.62 to $56.27 per hour   Application Close: March 29, 2024 At the City of Vancouver, we are committed to recruiting a diverse workforce that represents the community we so proudly serve . Indigenous peoples, people of colour, 2SLGBTQ+ persons including all genders  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-10 minutes. Cover letters should express interest and highlight additional information relevant to the position and resumes should include a summary of skills and experience related to the position.