Sr Systems Developer/integrator, SharePoint

CityofOttawa • Ottawa, ON

4d • Onsite

About The Position

The mandate of Information Technology Services is to create business value by delivering innovative, secure, and strategic solutions that support the operational needs of the City of Ottawa. Specifically supporting Microsoft SharePoint and Microsoft 365 solutions, you are responsible for researching, architecting, designing, configuring, customizing, enhancing, and integrating SharePoint‑based solutions (including SharePoint Online/On‑Prem, Power Platform components, and Microsoft 365 services) for assigned clients. This work is performed in response to new or changing business requirements and within the context of approved projects. Responsibilities also include maintaining and supporting SharePoint solutions, such as intranets, document management systems, collaboration sites, workflows, and integrations with enterprise systems, and providing ongoing technical support to business users and stakeholders. You are also responsible for authoring and maintaining SharePoint technical and functional documentation, including solution designs, configurations, governance artifacts, and support materials. This role ensures all SharePoint customizations, scripts, and solution components are properly managed using source control and configuration management tools. You are expected to follow the approved Project Lifecycle (PLC) and SharePoint governance standards, as applicable. Additional responsibilities include mentoring and coaching other SharePoint developers and administrators, promoting reusable and scalable solution patterns, and planning and executing testing for SharePoint enhancements, new site deployments, workflows, and integrations prior to release.

Requirements

• 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.
• 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)
• 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
• 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
• English oral, reading, writing

Nice To Haves

• 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
• 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
• Oracle Application Server Technologies
• Apache, Tomcat, IIS, WebLogic, WebSphere, nginx; Unix/Linux/Windows Server
• development using Microsoft Office Suite tools and SharePoint
• 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
• 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
• Enterprise content management concepts including web content management, records management, and document management
• Knowledge of the records management process, categorizations, disposition rules, etc.
• 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
• 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
• GIS application development
• Enterprise GIS technology
• GIS development tools
• ESRI ArcGIS, Autodesk AMP, Powerbuilder, Safe Software FME
• Proficiency in ABAP/JAVA
• Experience with SAP ABAP development and methodology
• SAP specific object oriented programming
• 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
• Mentor junior staff (where applicable)

Responsibilities

• Researching, architecting, designing, configuring, customizing, enhancing, and integrating SharePoint‑based solutions (including SharePoint Online/On‑Prem, Power Platform components, and Microsoft 365 services) for assigned clients.
• Maintaining and supporting SharePoint solutions, such as intranets, document management systems, collaboration sites, workflows, and integrations with enterprise systems.
• Providing ongoing technical support to business users and stakeholders.
• Authoring and maintaining SharePoint technical and functional documentation, including solution designs, configurations, governance artifacts, and support materials.
• Ensuring all SharePoint customizations, scripts, and solution components are properly managed using source control and configuration management tools.
• Following the approved Project Lifecycle (PLC) and SharePoint governance standards, as applicable.
• Mentoring and coaching other SharePoint developers and administrators.
• Promoting reusable and scalable solution patterns.
• Planning and executing testing for SharePoint enhancements, new site deployments, workflows, and integrations prior to release.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree