About the position
Duties
• Analyzes, defines and documents requirements and recommends database management solutions; conducts impact analysis studies under supervision.
• Plans, develops, tests, installs or upgrades database and other data administration systems, development tools, and user productivity tools.
• Provides technical support to the departmental software development teams and for clients.
• Manages and monitors the allocation of hardware resources to all database management systems; and manages user account profiles and ensures database security and availability including database back-up and recovery.
• Conducts the administration, design, review, development, integration, quality assurance, and maintenance of database management; and enforces data security standards.
• Provides technical support in the planning, development, testing, integration, implementation and maintenance of database management solutions and services.
• Supports the development of departmental/agency work processes, standards and guidelines.
• Participates as a member on projects, leads short-term projects and/or reviews/monitors work of contractors.
Work environment
The Department of National Defence (DND) is one of the largest federal government employers, offering over 70 types of civilian career opportunities. DND's role is to provide services and support to the Canadian Armed Forces (CAF) in their operations and missions at home and abroad. The civilian workforce is an essential part of the Defence Team. Your knowledge and expertise contribute to the overall mission. In this regard, the department fosters a work environment where you have opportunities to learn, to develop your talents, to progress in your career and have job satisfaction over the long-term.
Intent of the process
The intent of this process is to fill one (1) position on an indeterminate (permanent) basis in Halifax, Nova Scotia.
A pool of partially or essentially qualified candidates may also be established to fill current and future vacancies with various employment tenures, language profiles, security requirements, and conditions of employment in various locations within the Department of National Defence.
Important messages
📢 How does this work?
Step 1: Read the entire advertisement. Want to join our team! Let us know you’re interested! Click “Apply online.” 👍
Step 2: Tell us about you! Attach your resume and answer the screening questions in the online application.
Step 3: We will carefully review all of your qualifications. If your talent matches one of our immediate or upcoming opportunities we may contact you for further information or assessment.
Creating an environment where diverse perspectives are valued begins with self-declaration. Count yourself in and self-declare by identifying to which employment equity group(s) you belong to. In order to self-declare, please ensure to indicate this by checking off the appropriate box within the online application as part of the Employment Equity section.
𝐎𝐭𝐡𝐞𝐫 𝐢𝐧𝐟𝐨𝐫𝐦𝐚𝐭𝐢𝐨𝐧 (𝐧𝐨𝐭𝐞𝐬)
▶ Persons are entitled to participate in the appointment process in the official language of their choice.
▶ Our organization will only accept on-line applications for this opportunity. Please click “Apply online” to submit your application. If there are limitations or special circumstances preventing you from submitting your application via the GC Jobs online portal, you must contact us and receive approval to apply via an alternate means PRIOR to the closing date.
▶ Depending on the position being staffed:
↪ Additional qualifications, operational requirements and/or conditions of employment may be required
↪ Varying degrees of breadth and depth of experience may be deemed essential
↪ Asset qualifications may be invoked as essential qualifications
↪ You may be contacted and asked to submit information or be further assessed
▶ Applicants who apply to this selection process must include in their application a valid email address and make sure that this address is functional at all times and accepts messages from unknown users.
▶ All information obtained throughout the selection process, from the time of application to close of process, may be used to evaluate the applicants. Your overall conduct and communications, including email correspondence, may be used in the assessment of qualifications and competencies.
▶ To ensure the integrity of the selection process, the content and questions of the assessment must remain confidential. Please do not discuss or share the assessment content with anyone, including other candidates. You must complete the assessment, including screening questions, by yourself, without the help of others, including the use of unapproved internet resources and artificial intelligence (such as ChatGPT or any other forms of artificial intelligence). Plagiarism and the use of artificial intelligence is strictly prohibited throughout the entire process and suspected non-compliance will be investigated. Any violation may result in potential consequences which could include your elimination from this selection process.
▶ If, at any point in this process or upon qualifying in this process, your Values and Ethics do not align with that of the Department of National Defence and Canadian Forces Code of Values and Ethics and Values and Ethics Code for the Public Sector, you will be eliminated from further consideration in this process. (Copy and paste these links in your browser for more information: https://www.canada.ca/en/department-national-defence/services/benefits-military/defence-ethics/policies-publications/code-value-ethics.html AND https://www.tbs-sct.canada.ca/pol/doc-eng.aspx?id=25049)
Conditions of employment
Secret security clearance
Learn more about personnel security screening processes.
• Willing and able to travel
• Willing and able to work overtime as required, possibly on short notice
• Willing to work on standby and call-back support
• Willing and able to safely lift and move IT equipment up to 20 kg
• Strict adherence to the Department of National Defence and Canadian Forces Code of Values and Ethics, Values and Ethics Code for the Public Sector, Directive on Conflict of Interest, and Defence Administrative Orders and Directives (DAOD) 7021-1, Conflict of Interest.
Copy and paste these links in your browser for more information: https://www.canada.ca/en/department-national-defence/services/benefits-military/defence-ethics/policies-publications/code-value-ethics.html AND
https://www.tbs-sct.canada.ca/pol/doc-eng.aspx?id=25049 AND
https://www.tbs-sct.canada.ca/pol/doc-eng.aspx?id=32627 ANDhttps://www.canada.ca/en/department-national-defence/corporate/policies-standards/defence-administrative-orders-directives/7000-series/7021/7021-1-conflict-of-interest.html
You need (essential for the job)
Your application must clearly explain how you meet the following
❗ Essential qualifications are qualifications that you must meet in order to be considered for the position. This means that when you apply, your application must clearly demonstrate how you meet the education and experience listed below.
ESSENTIAL EDUCATION
Graduation from a two-year program of study from a recognized post-secondary institution with acceptable specialization in computer science, information technology, information management or another specialty relevant to the position to be staffed.
Note:
1. Indeterminate incumbents in the IT group on December 9, 2021 who do not possess the education prescribed above, are deemed to meet the minimum education standard based on their education, training and/or experience. They must be accepted as having met the minimum education standard whenever this standard is called for when staffing positions in the IT group.
2. Indeterminate incumbents of positions in the CS group on May 10, 1999, who do not possess the education prescribed above, are deemed to meet the minimum education standard based on their education, training and/or experience. They must be accepted as having met the minimum education standard whenever this standard is called for when staffing positions in the IT group.
3. At the manager’s discretion, an acceptable combination of education, training and/or experience may serve as an alternative to the minimum education stated above. Whenever the minimum education is met using this alternative, it is met for the specific position only and must be re-assessed for other positions for which this alternative has been specified by the manager
Learn more about degree equivalency.
______________________________________________________________
ESSENTIAL EXPERIENCE
EX1: Experience in Database Administration using Oracle, including tasks such as backup and recovery, monitoring, and patching.
EX2. Experience working with Oracle Multitenant architecture.
EX3: Experience analysing and documenting technical IT problems, proposing IT solutions and providing IT support services.
EX4: Experience providing IT technical advice and guidance.
Applied / assessed at a later date
COMPETENCIES
C1: Demonstrating integrity and respect
C2: Working effectively with others
C3: Showing initiative and being action-oriented
C4: Thinking things through
C5. Communication
______________________________________________________________
ABILITY
A1: Ability to prioritize in order to meet deadlines under pressure
You may need (asset qualifications)
May be applied / assessed at a later date
ASSET EXPERIENCE
AEX1. Experience troubleshooting Oracle database problems within Production environments
AEX2. Experience in planning and coordinating Oracle database upgrades
AEX3. Experience with Linux operating systems
AEX4. Experience in programming languages such as: Python, SQL, Oracle PL/SQL
AEX5. Experience with relational database design
AEX6. Experience with the following Databases; MS SQL Server, Postgres, Accumulo, Mongo, Memgraph, neo4j, qdrant
Equity, diversity and inclusion
The Public Service of Canada is committed to building a skilled and diverse workforce that reflects the population it serves. We promote employment equity and encourage you to self-declare if you belong to one of the designated employment equity groups when you apply.
Learn more about diversity and inclusion in the public service.
_______________________________________________________________
ORGANIZATIONAL NEEDS
The Department of National Defence is committed to creating a diverse and inclusive team that reflects Canada's population.
To achieve a representative workforce, selection may be based on qualified candidates self-declaring as belonging to one or more of the designated groups: Indigenous Peoples, members of visible minorities, persons with disabilities, and women.
We encourage you to indicate if you belong to any of the designated groups when you apply.
As means to support our military families and linked with the Department of National Defence priorities, consideration may first be given to the spouses or common-law partners of serving Canadian Armed Forces (CAF) members.
Learn more about employment equity.