Senior Database Administrator

Government of Northwest Territories; Yellowknife; On-site; CAD 90,000 - 130,000; Full time

Job summary

The Government of the Northwest Territories is seeking a Senior Database Administrator to design and manage core data and database services for the ISSS under OCIO. Based in Yellowknife, you will join the Data & Analytics team delivering data platforms, analytics and BI solutions for departmental operations and planning.

You will be responsible for enterprise DB platforms such as SQL Server and Oracle, including architecture, security, administration and documentation.

Qualifications

• Completion of an undergraduate degree in computer science, MIS or business with 4 years or more of relevant experience and progressive experience in database design, implementation and administration.
• Completion of a post-secondary diploma in a relevant field with 6 years of directly relevant and progressive experience in database design, implementation and administration.
• Completion of a post-secondary certificate in a relevant field with 7 years of directly relevant and progressive experience in database design, implementation and administration.
• All other equivalencies will be assessed on a case-by-case basis.

Responsibilities

• Develops and maintains specialist knowledge of database and data warehouse concepts, design principles, architecture, software and facilities.
• Develops, executes and automates procedures and maintains documentation for databases and data platforms.
• Applies a variety of visualization techniques and designs the content and appearance of data visuals.
• Applies and ensures compliance of security administration procedures.
• Performs release management activities associated with complex system or solution implementations, upgrades and enhancements.

Skills

Database design

Data warehousing

SQL Server

Oracle

BI visualization

Education

Undergraduate degree in computer science, MIS or business with 4+ years of experience

Post-secondary diploma in a relevant field with 6 years of experience

Post-secondary certificate in a relevant field with 7 years of experience

Tools

Microsoft SQL Server

Oracle Enterprise Database

Job description

The Department of Finance has the mandate to provide leadership and direction to the public service in all areas of finance and human resource management. This mandate includes negotiating major financial arrangements with the federal government, providing analysis and advice to the Financial Management Board, and ensuring that financial and information resources are managed effectively, efficiently and economically. This mandate also includes the recruitment and retention of a competent public service that is representative of the people it serves andthe development of programs and services that effectively serve the human resource needs of the public service.

Job Information

The Information Systems Shared Services (ISSS) team in Office of the Chief Information Officer (OCIO) builds and maintains software applications, platforms and ecosystems for government departments to support program delivery to the citizens of the Northwest Territories.

As the Senior Database Administrator, you will be responsible for the design and management of the core data and database management services operated by the ISSS. This includes core database and data warehouse architectures; database implementation, management and operations; and Business Intelligence (BI), visualization and analytics platform services to support departmental operational and strategic planning and decision-making.

Located in Yellowknife, you will be part of the Data & Analytics team that focuses on delivery and operations of data platforms, analytics and BI solutions. You will have the opportunity to grow your own skillset as you work with other technical experts in the OCIO.

The successful applicant is an expert in enterprise-level database platforms, such as Microsoft SQL Server and Oracle Enterprise Database, ensuring the planning, architecture, design, security, administration and documentation of new and amended database management systems deliver agreed value to stakeholders and clients and meet the highest standards of data reliability and resiliency.

Key Responsibilities

• Develops and maintains specialist knowledge of database and data warehouse concepts, design principles, architecture, software and facilities.
• Develops, executes and automates procedures and maintains documentation for databases and data platforms.
• Applies a variety of visualization techniques and designs the content and appearance of data visuals.
• Applies and ensures compliance of security administration procedures.
• Performs release management activities associated with complex system or solution implementations, upgrades and enhancements.

Key Qualifications

• Completion of an undergraduate degree in computer science, management information systems or business with 4 years or more of relevant experience and progressive experience in database design, implementation and administration.
• Completion of a post-secondary diploma in a relevant field with 6 years of directly relevant and progressive experience in database design, implementation and administration.
• Completion of a post-secondary certificate in a relevant field with 7 years of directly relevant and progressive experience in database design, implementation and administration.
• All other equivalencies will be assessed on a case-by-case basis.

GNWT Inquiries

Inquiries Only:

Department of Finance
Government of the Northwest Territories
YELLOWKNIFE CENTRE 5TH FLOOR
BOX 1320 YELLOWKNIFE NT X1A 2L9
Tel [phone] Extension 14106
Fax [phone]
[e-mail]

Note: If you do not receive electronic notification confirming receipt of your application, please follow up via telephone.