Canada DBA Job




Database Administrator /SQL Developer - Investment Industry Regulatory Organization of Canada (IIROC)

Database Administrator /SQL Developer, Investment Industry Regulatory Organization of Canada
Toronto, ON, CANADA
Posted Dec 14, 2010 1 Position(s)

IIROC is the national self-regulatory organization which oversees all investment dealers and trading activity on debt and equity marketplaces in Canada. Created in 2008 through the consolidation of the Investment Dealers Association of Canada and Market Regulation Services Inc., IIROC sets high quality regulatory and investment industry standards, protects investors and strengthens market integrity while maintaining efficient and competitive capital markets.
IIROC carries out its regulatory responsibilities through setting and enforcing rules regarding the proficiency, business and financial conduct of dealer firms and their registered employees and through setting and enforcing market integrity rules regarding trading activity on Canadian equity marketplaces.

Head Office (Toronto)


The Database Administrator ensures the continuous integrity, performance and capacity of the databases and related data stores of the organization. The position involves both hands on management, and strategic planning and design for the database environment.  Designing and implementing effective and standard security methods; practical capacity planning approaches; and integrated application design are fundamental components of the role. The position requires good team working skills in that working with staff that deploy internal and external business solutions is paramount. The development aspects of the role include creating test platforms, stored procedures and other database related programming methods as required.

. Post-secondary education in Computer Science or Information Management.

Experience/Skills/Special Requirements
. Expert-level knowledge of SQL Server, SQL Server Integration Services, reporting Services, Transact-SQL.
. Solid understanding of data security and maintenance procedures.
. Familiarity with Visual Basic/C#/J#/C++, Visual Studio and related Microsoft technologies
. Basic knowledge of Internet Information Server 6.0
. 5 years experience in MS SQL Server database administration
. 5 years experience in database related to web-based application development
. Experience in distributed, multi-tiered application development in a team environment
. Excellent analytical and problem solving skills
. Excellent communication skills
. Ability to communicate effectively with both technical and non-technical users.
. Good attention to detail and process.
. Experience in the financial services industry would be an asset.

Last updated on February 07, 2011