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 Skills

• Experience 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 Skills

• Knowledge 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 Requirements

• Design 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.

Skills Required