As a Database Designer with the Department of National Defence, you will design, develop, and maintain database systems that support critical defence operations and administrative functions. You will work with stakeholders across the organization to understand their data needs and translate them into efficient, secure, and scalable database solutions. Your work ensures that DND personnel have reliable access to the information they need to carry out their missions, from personnel records to operational data.
Your daily responsibilities include analyzing business requirements, designing database architecture and schemas, creating data models, and documenting technical specifications. You will collaborate with database administrators, application developers, and IT security teams to ensure databases meet performance, security, and reliability standards. You may also troubleshoot database issues, optimize queries, and recommend improvements to existing systems.
You will work in a professional office environment within DND facilities, typically in major Canadian cities. The role offers opportunities to work on systems that directly support Canada's defence mission. You will be part of a team that values technical excellence, security, and continuous improvement.
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
A bachelor's degree in computer science, information technology, or a related field is typically required. Some positions may accept candidates with substantial relevant work experience in place of formal education. You should have strong knowledge of database management systems (such as SQL Server, Oracle, or PostgreSQL), data modeling, and database design principles.
Certifications valued for this role include: Microsoft Certified: Data Engineer Associate, Oracle Certified Associate Database Administrator, and CompTIA Security+ (for security-focused positions). Professional memberships in organizations like the Association of Canadian Data Administrators can support your career development.
The Public Service offers ongoing professional development opportunities. You will have access to training programs in emerging database technologies, security protocols, and DND-specific systems. Many employees pursue advanced certifications and technical specializations throughout their careers. Mentorship opportunities and knowledge-sharing sessions with senior database professionals are common in DND IT departments.
Entry Plans
Entry to this position typically occurs through advertised competitions open to Canadian citizens. DND regularly posts Database Designer positions on the Government of Canada's Job Bank website (jobs.gc.ca). You can also register with the Public Service Commission's hiring plans to learn about upcoming opportunities.
The Federal Student Work Experience Program (FSWEP) and the Post-Secondary Recruitment Initiative (PSRI) provide pathways for students and recent graduates to gain experience and potentially convert to permanent positions. Some candidates also enter this career through lateral moves from related IT positions within the Public Service.
To apply, you will need to demonstrate your technical qualifications, relevant experience, and ability to obtain a security clearance. Most positions require reliability level security clearance. Prepare examples of databases you have designed and be ready to discuss your technical problem-solving approach during the interview process.
Part-Time Options
Full-time positions are standard for Database Designer roles in DND, reflecting the critical nature of database support to defence operations. However, the Public Service does offer flexible work arrangements in many IT roles.
Remote and hybrid work options have become increasingly available for database design work, particularly for certain project-based or specialized tasks. Approval for remote work depends on operational requirements, team structure, and management discretion. You should discuss flexible work options during the hiring process or with your manager once hired.
Job-sharing and part-time arrangements are generally not typical for this position due to the need for continuity in database support and on-call availability, but individual circumstances may be considered. DND is committed to supporting work-life balance within the constraints of operational requirements.
