Government of Canada / Gouvernement du Canada

Database Administration Technical Advisor

NOC 21223 Database and Database Administration Employee Digital
Apply Build a Job Description

Overview

As a Database Administration Technical Advisor, you will be responsible for designing, implementing, and maintaining database systems that support Department of National Defence operations and services. You will work with database technologies, data management strategies, and IT infrastructure to ensure reliable, secure, and efficient data storage and retrieval across the organization. This role involves providing technical expertise to colleagues, troubleshooting database issues, and recommending solutions that align with government IT standards and security requirements. Your day-to-day responsibilities will include monitoring database performance, managing user access and security protocols, conducting backups and disaster recovery planning, and documenting database configurations and procedures. You will collaborate with IT teams, system administrators, and business stakeholders to understand data needs and implement appropriate solutions. You may also be involved in evaluating new database technologies, training staff on database tools, and ensuring compliance with Treasury Board and DND policies. You will typically work in an office environment, though some flexibility may be available depending on operational needs. Your work will directly support critical defence and security operations, making reliability and attention to detail essential aspects of the role.

Key Responsibilities

Deliver database and database administration services supporting GC digital operations, Develop, configure, and maintain IT systems and infrastructure, Troubleshoot technical issues and provide user support, Document technical solutions and maintain system records

Required Skills

Systems administration, Programming/scripting, Network and security, Cloud technologies, ITIL/ITSM practices, Technical proficiency, Attention to detail, Collaboration, Continuous learning

Typical Education

Post-secondary education or equivalent experience relevant to the position

Training

Entry to this position typically requires a post-secondary diploma or degree in Computer Science, Information Technology, or a related field, or equivalent work experience in database administration or IT support roles. Many successful candidates have completed certifications from major database vendors such as Oracle, Microsoft SQL Server, or PostgreSQL, though these are often obtained after hire through professional development. The Government of Canada provides ongoing professional development opportunities, including technical training courses, certification programs, and access to learning platforms. Many employees pursue industry-recognized certifications such as Microsoft Certified: Azure Database Administrator Associate, Oracle Database Associate, or similar credentials. DND also supports attendance at conferences, workshops, and vendor training sessions relevant to database technologies and IT governance. Strong foundational knowledge of database concepts, SQL programming, data security, and system administration is essential.

Entry Plans

You can enter the Database Administration Technical Advisor career through several pathways within the federal Public Service. The most common route is through open competitions advertised on the Government of Canada Jobs website, where you can apply directly if you meet the stated qualifications. The Public Service Commission regularly posts positions for various government departments, including DND. Other entry options include lateral moves from related IT positions within the Public Service, such as from IT Support, System Administration, or Data Management roles. Some candidates enter through student employment programs or co-op placements while completing post-secondary education, which can lead to permanent positions. Indigenous candidates may have access to the Indigenous Talent Cloud program, and veterans transitioning from Canadian Armed Forces technical roles may find pathways through Veterans Hiring initiatives. Networking with DND's IT recruitment teams and checking the DND Civilian Careers website regularly for posted opportunities is recommended.

Part-Time Options

Part-time and flexible work arrangements are possible in many Database Administration Technical Advisor positions, though availability depends on specific operational requirements and team needs. Some positions may offer flexible hours or compressed work weeks, particularly for roles that do not require continuous 24/7 on-call support. Remote work options have expanded across the federal government, and some database administration work can be performed remotely, though this may depend on security classification levels and the sensitivity of the data being managed. Should you require accommodations, the Public Service is committed to creating an accessible and inclusive workplace. Many DND positions offer benefits including telework options, leave entitlements, and flexible scheduling where operationally feasible. When applying for or discussing specific positions, inquire about the flexibility available for that role, as requirements vary based on the database systems supported and whether emergency or on-call coverage is needed.