Back to top

RFP--Database Developer, Healthy Communities, Haldimand-Norfolk Health Unit

Simcoe, Ontario
Deadline December 17, 2010

Background:

In May 2009, the Ministry of Health Promotion and Sport launched the Healthy Communities Framework, an integrated approach to improving the health of Ontarians focusing on six risk factor areas: physical activity, sport and recreation; injury prevention; healthy eating; tobacco use/exposure; substance and alcohol misuse; and mental health. There are three components to the initiative: the Grants Stream; the Resource Stream, and the Partnership Stream.

The Haldimand-Norfolk Health Unit  has taken on the role of steward for the Partnership Stream. The aim of this part of the initiative is to bring together community members, partners, networks, leaders and decision-makers to identify local recommended actions, based on the six Ministry priority areas. These identified actions will then link locally to the Grants Stream. A second focus for the Partnership Stream is work with community leaders to build healthy public policy.

The community partnership is using the resulted-based accountability framework to guide the process. Results Based Accountability (RBA)is a disciplined way of thinking and taking action that communities can use to improve the lives of children, families and the community as a whole. RBA can also be used by agencies to improve the performance of their programs. RBA can be adapted to fit the unique needs and circumstances of different communities and programs. RBA Starts with Ends and works backwards, step by step, to means. Background information on RBA can be found at www.raguide.org and www.resultsaccountability.com.
   
Position Summary

An important part of the Healthy Communities Partnership Stream work is the development of the Community Picture. The Community Picture will provide a comprehensive profile of the community, including demographic make-up, health status data, current initiatives and policies that impact health and well-being in Haldimand and Norfolk. The community picture should also consider broader social, economic, political and environmental contexts affecting community health needs.  This community picture will be shared with a variety of audiences including the Ministry of Health Promotion and Sport and local partners and stakeholders.

The successful candidate will work with staff and management in the Health Unit and Norfolk County to develop a database to house demographic, health status and health behaviour information about Haldimand and Norfolk.  This database will be developed to provide the public, community stakeholders and public health staff with an easy web-based portal to local health data.

Deliverables for this RFP:

  • Develop and design a database for demographic, health status and health behaviour information.
  • Develop and design a web based application to display the database information in a user friendly format on the HNHU.org web site.

Key Qualifications:

  • SQL Database Development and Design
  • Web Application Development
  • Data Analysis and Reporting

Must Have:

  • A expert understanding of SQL RDBMS systems
  • Proven database and web based front end development experience (portfolio required) (minimum 5 years’ experience in database development and design)
  • Minimum 3 years’ experience in web based programming languages. (eg: HTML, XHTML, ASP.net, Linq, SQL, AJAX, jQuery, etc. )

Submission Requirements:

  • a resume that clearly demonstrates how your experiences reflect the key qualifications required
  • a detailed plan and description of how the requested deliverables will be executed
  • a breakdown of costs
  • the names and contact information of two references

Prior to the commencement of any work, the following shall be provided to the Haldimand-Norfolk Health Unit:

  • Workplace Safety & Insurance Board
  • Provide documents to confirm evidence from WSIB of Independent Operator Status and therefore not an employee of Norfolk County.

Insurance

Provide certificate(s) of insurance showing :

  • $2 million – Commercial General Liability, showing The Corporation of Norfolk County as an Additional Insured; and cross liability endorsement
  • $2 million – Automobile

Accessibility For Ontarians With Disabilities Act (AODA)  

Provide evidence of compliance with the requirements of Section 6 of Ontario Regulation 429/07, Accessibility Standards for Customer Service, under the Accessibility for Ontarians with Disabilities Act, 2005.

Deadline for submission of proposals is  December 17th.

Please send your proposals to:

Jill Steen
Program Coordinator,
Population Health Team
Haldimand-Norfolk Health Unit
12 Gilbertson Dr., P.O. Box 247,
Simcoe, ON N3Y 4L1
E-mail: jill.steen@hnhu.org

NOTE: Electronic submissions are also acceptable.

Proposed Timelines:

  • Release of RFP: November 30, 2010            
  • Deadline for submission of proposals: December 17, 2010    
  • Proposal Review Completed by: December 22, 2010         
  • Successful candidate notified: December 22, 2010        
  • Project start date: January 3, 2011            
  • Project completion date: March 31, 2011            

Budget: Quotations should not exceed $10,000.

Contact: Questions regarding the rfp and the project may be directed to:

Jill Steen
(519) 426-6170 ext. 3238
jill.steen@hnhu.org