Job Description

Description

Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.

General SkillsExperience in programming and analysis at the specified experience level Ability to collaborate with IT Professionals throughout the Software Development Life Cycle Experience in structured methodologies for the development, design, implementation and maintenance of applications Experience in design, code, test, debug and document applications Experience in the use of object and/or third generation language development tools Experience in one or more programming languages Experience in application design, latest design patters, deployment and troubleshooting Experience with relational and hierarchical database technologies Experience in the use of information retrieval packages using query languages Experience with one or more communications protocols Experience in structured methodologies for the design, development, implementation and maintenance of applications Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills A team player with a track record for meeting deadlines


Desirable SkillsKnowledge and experience with programming Internet-ready applications Knowledge and experience in rapid application development (RAD) methodologies Experience with middleware and gateways Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards Ability to provide user and system documentation as required


This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.

Skills
Experience and Skill Set RequirementsDesign and Development Experience 35% 10+ years of experience with Microsoft SQL Server Reporting Services. 10+ years of experience in database development with Microsoft SQL Server. Demonstrated experience with database architecture, data modeling, logical and physical database design (OLTP, OLAP, Data Warehousing, ERwin, Visio, UML) and database capacity planning. Demonstrated experience with MS SQL Server performance tuning (Profiler, Tracing, Execution Plan Analysis), data and application integration (ETL, SSIS, OS scripting) and data migration Writing Python and SQL script for custom Computer Aided Dispatch (CAD) installations Demonstrated ability to translate complex business requirements into technical solutions Experience with and knowledge of UI Design Principles Experience in SOAP and REST web services for processing real-time data streams Demonstrated experience in responding to and troubleshooting issues related to data quality and performance and resolve them in a timely manner. Experience working with team-collaboration tools (Confluence and Jira)


Technical Skills 35%10+ years of demonstrated experience in development of enterprise-level information technology solutions by analyzing, coding, configuring, testing, and implementing new and by modifying/enhancing existing applications utilizing Microsoft SQL Server. Demonstrated experience with development and maintenance of complex SQL queries, views and stored procedures. End to end management of the Software Development Life Cycle (SDLC) for Computer Aided Dispatch (CAD) Developing process models and ongoing analysis of program effectiveness for Computer Aided Dispatch (CAD), Demonstrated experience in all aspects of the software development cycle (SDLC, Agile) Experience with designing and developing solutions for a 9-1-1 Public Safety environment Demonstrated experience in delivering and meeting project deliverable timelines.


Communication Skills 25%Strong verbal and written communication skills that enable to effectively communicate ideas and concepts. Strong Interpersonal and negotiation skills. Strong consulting skills to engage with all stakeholders, lead meetings with internal and external clients to gather and document business requirements. Ability to work with minimal supervision in an agile environment, be an effective communicator with other team members and the business owners. A demonstrated team player with a proven track record for meeting deadlines Demonstrated experience in creating of conceptual, logical, and physical data documentation for knowledge retention and transfer. Experience in working on multi-year projects


Public Sector Experience 5%Experience in working on multiple projects at the same time Experience in working on multi-year projects Experience with building enterprise level reporting solutions that protect high-sensitive information Demonstrated knowledge and experience with OPS governance methodologies (e.g. UPM, architecture gating)


MUST HAVES:10+ years of experience with Microsoft SQL Server Reporting Services. 10+ years of experience in database development with Microsoft SQL Server. 10+ years of demonstrated experience in development of enterprise-level information technology solutions by analyzing, coding, configuring, testing, and implementing new and by modifying/enhancing existing applications utilizing Microsoft SQL Server. * Demonstrated experience with development and maintenance of complex SQL queries, views and stored procedures.