Database Administrator

Job Posting Title: Database Administrator

Job Category: Infrastructure

Language Requirements: English / Anglais

Flexible Work Agreement Type: Hybrid / Hybride

Posting End Date: 2024-11-13

Job Grade: PIPSC-4

Pay Range: $123,506 - $155,150

Job Summary: The Database Administrator’s main responsibility is to plan, organize, direct, participate and/or lead the design and implementation of national system changes and enhancements, a multi-layered architecture of hardware and software and communications technologies. Provide advanced specialization in one or more areas of specialization, and/or apply expertise cross-functionally.

Key Accountabilities:

• Provide technical/operational expertise and direction in one or more areas of specialization, and/or cross-functionally across the organization on systems.
• Represent Own Unit or Department as a technical expert in own functional area. Champion ideas and innovations.
• Under the Manager’s directions, lead on-going life-cycle support of national system(s) in own functional area for the company nationally, developing optimum performance levels, performance monitoring, capacity assessment, data management and operating systems, availability, failure modes and recovery, security, and technical support.
• As subject-matter expert, resolve issues that require a cross-functional solution. Resolve complex interrelated application, database, operating systems, hardware problems, provide advice and guidance on technical data management and systems administrative issues to ensure maintenance of performance standards.
• Provide input to development, identification, and resolution of potential inconsistencies with current and planned policies, training, plans, architecture, policies, national technical standards, and work instructions.
• Provide leadership in the development and implementation of new features, enhancements and special requirements, diagnostic and maintenance of databases, and procedures of assigned systems in own functional area and/or on cross-functional basis.
• Analyze, plan, specify, define technical requirements for new software/applications, databases to ensure current and future interoperability with NAV CANADA business systems infrastructure.
• Lead/participate in very complex or multiple complex project(s), including cross-functional projects, in the design, implementation and maintenance of system architecture for assigned systems for enhancements and meeting special requirements.

Job Requirements:

Education:

• A Degree from a recognized university or community college with an acceptable specialization in computer science or information systems or an acceptable combination of education, experience, and training.

Experience:

• A minimum of eight (8) years of hands-on experience in supporting Microsoft SQL Server (2008 to 2019).
• Minimum of one (1) year of experience in supporting Oracle databases (12c/19c).

Knowledge:

• Strong knowledge of administration, planning and deployment of Microsoft SQL Server.
• Strong knowledge of database design, performance tuning and licensing.
• Knowledge of Oracle Databases.
• Knowledge of cybersecurity considerations and best practices in data infrastructure and systems.

Abilities:

• Excellent assessment, analytical and testing skills.
• Ability to effectively lead multiple and cross-functional complex projects.
• Ability to identify and resolve complex and varied problems creatively and innovatively.
• Ability to make decisions in situations where solutions are not always clearly evident.
• Possess very good oral and written communication skills.
• Ability to review the evaluation of operational viability of enhancements and changes as well as effectively facilitate change requests.

Personal Suitability:

• Persuade, influence, lead, coach, mentor and facilitate team effort.
• Possess customer focus and strong relationship building skills.
• Resilient and open to change with innovativeness and creativity to achieve desired outcomes.
• Manage and prioritize multiple initiatives in a fast-paced environment.
• Possess willingness to learn and support multiple database platforms.

Working Conditions:

• This position is based at the Ottawa Logistics Centre location and is eligible for a flexible work arrangement.
• On-Call is required for this position.

NAV CANADA is committed to building a skilled, diverse workforce reflective of Canadian society. If you do not believe that you match every job requirement listed on this job posting, we still encourage you to apply. NAV CANADA encourages a culture of learning and growth, and recognizes that although some technical skills are mandatory, many others can be taught.

Our Company strives to create an inclusive and barrier-free selection process and work environment. If you require accommodations during this competition process, please ensure that you inform the interview coordinator or hiring manager of any accommodation measures you may require. NAV CANADA will provide accommodations throughout the recruitment and selection process to applicants with disabilities as required.

The successful candidate must meet the security requirement of the position and be legally able to work in Canada.

We thank all applicants for their interest; only those selected for an interview will be contacted.