Job Posting Title

Database Administrator (1 position)

Job Category

Application / System Development

Language Requirements

English / Anglais

Flexible Work Agreement Type

Posting End Date

2023-10-18

Job Grade

CS-4

Pay Range

$112,044 - $137,932

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.

Job Description

What NAV CANADA offers you:

• Challenging, team-oriented work environment
• Competitive compensation and flexible benefits
• Defined benefit pension plan
• Opportunities for growth and development
• Flexible work arrangements
• Diverse and inclusive workforce

Job Description

Key Accountabilities:

• Provide technical / operational expertise and direction in one or more areas of specialization, and / or across-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. This would involve conducting cost-benefit analysis, planning, organizing, directing, contributing to conceptual and physical design of the projects, participating in and leading implementation, coaching others on project management issues, and or recommending corrective actions to management

Job Requirements

Education:

• 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
• Oracle or MS SQL Server certification would be an asset.

Experience:

• A minimum of eight years of hands-on experience in supporting Oracle databases (12c/19c).
• Must have experience in Oracle 19c, RMAN, ASM, Data Guard, OEM, Oracle DB Upgrade and Patching
• Must have experience in Red Hat Linux Cluster
• Minimum of one year of experience in supporting Microsoft SQL databases.
• Experience with Microsoft Azure database service offerings and PostgreSQL would be an asset.

Knowledge

• Strong knowledge of administration, planning and deployment of Oracle Databases.
• Strong knowledge of database design, performance tuning and licensing.
• Knowledge of Microsoft SQL Server
• 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 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.

At NAV CANADA, safety is our priority. We require pre-employment drug screening for all candidates offered positions designated as safety sensitive in accordance with NAV CANADA’s Drug and Alcohol policy.

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