Junior Software Developer

JSI; Ottawa; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

A Canadian technology firm is seeking a motivated Junior Database Developer to join its Applications and Data team. This entry-level position requires foundational SQL Server knowledge and offers a remote/hybrid work environment. Candidates should have a degree in Computer Science and strong problem-solving skills. Responsibilities include database design, performance monitoring, and routine maintenance tasks.

Qualifications

• Degree in Software Engineering, Computer Science or related field required.
• Basic understanding of T-SQL needed.
• Familiarity with indexing, normalization, backups, and storage management.

Responsibilities

• Assist in creation/design of SQL Server databases.
• Monitor database performance and storage usage.
• Perform routine maintenance tasks including backups and indexing.

Skills

Basic understanding of SQL Server database architecture

Strong problem-solving skills

Excellent communication skills

Education

Post-secondary education in Computer Science or related field

Tools

SQL Server Management Studio

PowerShell

Python

Job description

Description

We are seeking a motivated and detail-oriented Junior Database Developer / Analyst to join our Applications and Data team. This entry-level role is ideal for someone with foundational knowledge of SQL Server and a passion for supporting large-scale customer data environments. You’ll work closely with senior team members to ensure the health, performance, and reliability of our database systems. Candidates must hold a degree in Software Engineering, Computer Science, or a related field and be eligible for a Top Secret security clearance.

Key Responsibilities

• Assist in the creation and design of SQL Server databases to support customer data needs.
• Monitor database performance and storage usage; proactively identify and resolve issues related to capacity and performance.
• Support A / B side database environments, ensuring redundancy and failover capabilities are maintained.
• Perform routine maintenance tasks including backups, indexing, and updates.
• Help troubleshoot and resolve database-related issues in production and development environments.
• Document procedures and contribute to knowledge base articles for internal support.
• Collaborate with application developers and data analysts to support data integrity and accessibility.

Required Qualifications

• Post-secondary education in Computer Science, Information Technology, or a related field.
• Basic understanding of SQL Server database architecture, design principles, and T-SQL.
• Familiarity with concepts like indexing, normalization, backups, and storage management.
• Awareness of high availability setups (e.g., A / B side environments, failover clusters).
• Strong problem-solving skills and attention to detail.
• Excellent communication and willingness to learn from senior team members.

Preferred Qualifications

• Exposure to monitoring tools (e.g., SQL Server Management Studio, Azure Monitor).
• Experience with scripting or automation (PowerShell, Python).
• Understanding of data privacy and security best practices.

Personal attributes

• Excellent communication skills – both written and verbal
• Self-motivated and capable of managing multiple priorities and tasks
• Loves to be a part of a team.
• Creative and efficient in proposing solutions to complex, time-critical problems.
• Strong analytical and problem-solving skills with high attention to detail.

How We Work

You will be expected to work in a remote / hybrid environment reporting to our Kanata, Ontario location 2 or more times per week.