Applications Systems Specialist

**Requisition ID**:38577

**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**
System Maintenance and Technical Support
- Conducts system testing, integration testing to resolve systems issues and anomalies and to respond to customer enquiries
- Conducts regular server software maintenance and patching
- Conducts ongoing technical audits for IT systems, and tracks and reports any anomalies to th 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/Python 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**
- 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

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

**Qualifications**
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
- Some programming and analysis experience is highly desirable

Knowledge, Skills and Abilities:

- 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
- GIS, ESRI ArcGIS Enterprise, AGOL and ArcGIS Pro, ESRI’s geodatabase, FME server, and Autodesk Map 3D & CADD
- 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 scanners, printers and related equipment
- Knowledge of relational databases - Oracle, MS SQL, Oracle Spatial, SQL Server Spatial
- Considerable knowledge of MS Office productivity tools
- Experience in a hybrid (on premise and cloud) infrastructure and platform environment leveraging cloud services such as MS Azure, Amazon Web Services
- 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
- Good attendance is of operational importance
- Ability to accommo