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.

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.