Junior Software Developer

Jatom Systems Inc.-CAN; Ottawa; Hybrid; CAD 55,000 - 75,000; Full time

Job summary

A technology solutions company in Ottawa is seeking a motivated Junior Database Developer / Analyst to support their Applications and Data team. This entry-level position focuses on SQL Server database management and requires a degree in Computer Science or related fields. The successful candidate will assist in database design and maintenance while working in a hybrid environment, reporting to the main office in Kanata, Ontario at least twice a week.

Qualifications

• Basic understanding of SQL Server database architecture, design principles, and T-SQL.
• Familiarity with indexing, normalization, backups, and storage management.
• Awareness of high availability setups like A / B side environments.

Responsibilities

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

Skills

SQL Server knowledge

Problem-solving skills

Attention to detail

Communication skills

Education

Post-secondary education in Computer Science or related field

Tools

SQL Server Management Studio

PowerShell

Python

Job description

Overview

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.

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.

About JSI

JSI is built on purpose, that of making a difference in the world.

Founded in 1979, this privately-owned technology company is the North American leader in designing and developing acquisition, collection and analysis solutions for law enforcement and intelligence communities.

With 4Sight – JSI’s single, unified, product suite – customers can combine any number of disparate data sources into a highly intuitive, visually-focused platform. The result? JSI’s customers spend less time working with data and more time seeing patterns, understanding trends, and gaining perspective (and making the world a safer place).

With over 400 employees and a strong, growing global presence in Canada, the U.S., Australia and Germany, JSI is not only the dominant player in its industry, it is also known for its fun, high-performing, purpose-driven corporate culture.

In accordance with the Accessibility for Ontarians with Disabilities Act (AODA), JSI will provide accommodation accessible formats and communication supports for the interview process upon request.