Applications Systems Specialist

**Requisition ID**:39446

**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, 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**

**Specific Duties and Responsibilities**
- Conducts system testing and integration testing to resolve systems issues and anomalies
- Conducts regular server software maintenance and patching
- 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 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
- Recommends procedural and technical changes to improve systems functioning
- Researches new products and hardware and process changes; evaluates, tests, and documents recommendations
- Monitors and tracks status of operationally critical systems
- 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
- Provides coverage for other IT team member, as required
- 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 programming techniques and languages, 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
- Recommended Microsoft Certified Professional - Enterprise Administrator, or equivalent certification

Knowledge, Skills and Abilities:

- 2+ years experience with programming and analysis is highly desirable
- 2+ years experience working with.NET environment and Web Services
- 2+ years experience working with SQL Server 2008 & above
- 2+ years experience working with Windows server management, ColdFusion Server Management, IIS configuration, Scripting (Windows PowerShell), and JavaScript
- 2+ years experience working with and configuring desktop PCs, and knowledge with peripherals such as Point of Sale (POS) devices, scanners, printers and related equipment
- 2+ years experience working with relational databases - Oracle, MS SQL
- 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
- POSSE, Tempest, Fairfax, AMANDA, Infor/Hansen, Lagan, ServiceNow, Legal Department systems (Litigation, Worldox, LawBase), TeleStaff Scheduling, OutSystems Productivity Platform, Ungerboeck USI, IVOS, TFS, Stone Orchard
- 2+ years with deployment techniques (TFS, Octopus, CICD)
- #2+ years experience with information technology concepts for networking, and operating systems
- 2+ years experience with user interface design, data integration, data extraction, data analysis, and reporting
- 2+ years experience using documentation, testing, trouble-shooting, and security tools and techniques
- 2+ years experience with problem definition, requirements definition, analysis and solution techniques applicable to systems and procedures
- 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
- Thor