Is there a CDN oriented search engine that against a name inquiry will return place names, ages and related persons similar to www.peoplefinders.com or www.intellius.com for the States? I must be missing something,or maybe CDN privacy laws restrict this.

No, the closest is http://canada411.ca which lists only names, addresses & phone numbers of telephone subscribers.

Is there a database/website in Canada similar to the Social Security Death Index in the USA, and if so what time period does it cover and where do I access it?

No, Canada does not have a similar database.  We do have Social Insurance but those records remain private.