Senior Systems Analyst, GIS

JOB SUMMARY

The mandate of Information Technology Services is to create business value by providing innovative and strategic technology solutions for the business operations of the City of Ottawa.

You are responsible for: researching, architecting, designing, developing, customizing, enhancing and/or integrating large-scale GIS/Esri applications/solutions for assigned clients in response to new or changing business requirements and/or for assigned projects; maintaining these applications/solutions; and providing client technical support.

You are also responsible for: writing and maintaining systems documentation; ensuring all code is managed appropriately by using software configuration management tools; troubleshoot and resolve issues with Esri products, solutions, integrations and infrastructure; Infrastructure as Code (IaC) and pipelines creation and maintenance, contribute to capacity planning and sustainment of the existing Esri infrastructure and solutions; following the approved project lifecycle (PLC), Agile or Kanban methodology, and Azure DevOps practice as appropriate; ensuring solutions are made bilingual and comply with the Accessibility for Ontarians with Disabilities Act (AODA) Web Content Accessibility Guidelines 2.0 AA (WCAG 2.0 AA); mentoring/coaching of junior GIS team members and developing test plans and performing tests on enhancements / new development/ new integrations.

EDUCATION AND EXPERIENCE

Completion of 3 year university degree or college diploma in information management, information technology, or related field

Minimum of 5 years of progressively more responsible experience in applications development and/or integration, including experience writing and supporting applications with databases.

Desirable Qualifications:

• Development:
  • Microsoft ASP, VB, C#, C++ and .Net programming languages;
  • Java 7/8, Java Server Faces, Spring/Struts, Java EE;
  • Python, Perl, PHP;
  • Web services (XML, SOAP, REST, JSON);
  • HTML5, CSS, XML, JavaScript;
  • ColdFusion;
  • PowerBuilder version 6.5 to 8.0
• Databases:
  • Oracle 11g/12c and higher, SQL Server 2014/2016, MySQL;
  • PL/SQL and T-SQL for creation of procedures and packages;
  • relational and non-relational (i.e. no-sql) database technologies;
  • tuning query performance and logical data modelling concepts
• Servers:
  • Oracle Application Server Technologies;
  • Apache, Tomcat, IIS, WebLogic, WebSphere, nginx; Unix/Linux/Windows Server
• Office:
  • development using Microsoft Office Suite tools and SharePoint
• Testing:
  • Unit, regression and load testing; Test plan creation
• System/Software Development Life Cycle
• n-tier Architecture Design
• Configuration management (Ansible, Jenkins)
• Creation of technical and non-technical documentation
• ITIL knowledge

KNOWLEDGE

For all positions:

• Application development best practices
• IT security best practices and standards relating to application development and/or integration
• In-depth knowledge of the current City of Ottawa development toolset
• Event-driven/object-oriented program design techniques
• Structured systems analyses and design techniques
• City network environment
• Understanding of database concepts relating to application and database security
• System testing techniques
• Knowledge of and experience with COTS system installation, configuration, administration and support
• A combination of knowledge and experience working with Oracle, .Net and/or Java development tool sets
• Troubleshooting application issues
• Good understanding of system failover and recovery strategies
• Applicable legislation (e.g. MFIPPA, AODA)

For Geographic Information System (GIS) positions:

• GIS application development
• Enterprise GIS technology
• GIS development tools

ESRI ArcGIS, Autodesk AMP, Powerbuilder, Safe Software FME are desirable

For Business Intelligence (BI) positions:

• Business intelligence tools and reporting
• Extract, Transform and Load (ETL) tools and workloads
• Dimensional data modeling and data warehousing techniques

IBM Cognos BI, IBM Cognos Analytics, IBM InfoSphere DataStage are desirable

For Enterprise Content Management (ECM) positions:

• Enterprise content management concepts including web content management, records management, and document management
• Knowledge of the records management process, categorizations, disposition rules, etc.
• Requires strong demonstrated training and development experience and knowledge in web technology including web application and server architectures, Java web application frameworks, web security, web-based user interface design, portal architectures, and web services
• Experience with content management tools and enterprise application server architecture Oracle UCM Stellent WebCenter, Oracle WebLogic, SAP Netweaver, Business intelligence tools, UNIX operating system are desirable

For Enterprise Service Bus (ESB) positions:

• Administration of ESB infrastructure including maintenance of highly available system, patches/upgrades, and deployments of applications
• Coordinate complex integrations of enterprise systems
• Ensure secure communications of data payloads

Oracle SOA Suite, including WebLogic, Oracle Service Bus (OSB), Solaris UNIX and Web Service Architectures/Infrastructure are desirable

For SAP positions:

• Proficiency in ABAP/JAVA
• Experience with SAP ABAP development and methodology
• SAP specific object oriented programming

For Web Developer positions:

• Good understanding of Apache, Tomcat, IIS, Drupal and JavaEE architecture
• Requires strong demonstrated training and development experience and knowledge in web technology including web application and server architectures, Java web application frameworks, web security, web-based user interface design, web accessibility principles, portal architectures, and web services
• Php or Perl development experience
• Drupal and PHP, SAP Netweaver, Solaris UNIX, CentOS Linux are desirable

COMPETENCIES, SKILLS AND ABILITIES

• Develop applications using current development toolset
• Install, customize and configure COTS applications
• Integrate hardware and software
• Liaise effectively with clients, all levels of ITS staff, vendors and consultants
• Gather and document user requirements
• Organize work and meet deadlines
• Demonstrate effective written and oral communication skills
• Work independently and as a team member
• Use effective judgment when immediate supervision is unavailable
• Research and analytical skills
• Good oral and written communication skills
• Mentor junior staff (where applicable) Organize, develop and document procedures
• Good organization and prioritization skills to handle multi-tasking
• Enterprise scale application deployments
• Development techniques for optimal performance and scalability
• Collaborative approach in working with others
• Converse effectively using both technical and general business terminology
• Diplomacy and tact
• Demonstrate initiative and self-motivation
• Work effectively under pressure
• Work with minimum supervision
• Flexible
• Able to meet deadlines
• Client-focussed and service-oriented
• High degree of interpersonal skills