About the role
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.
About JSI
As trailblazers in the industry, our team of engineering and consulting experts are prepared to craft and implement a broadband solution tailored to your specific needs.
JSI can assist with designing and operating broadband networks, funding applications, forecasting, competitive pricing, mapping, feasibility studies, intercarrier billing, operational reform, strategic partnerships, company valuations, and more. We also offer a full range of OSP and ISP engineering services, including central office, optical transport, FTTx, IPTV, CATV, and wireless. JSI has more than 700 professionals on staff in its Maryland headquarters and in its regional offices in Alaska, Georgia, Hawaii, Illinois, Louisiana, Michigan, Minnesota, North Carolina, Texas, Utah, and Wisconsin. To learn more, please visit us at jsitel.com.
About the role
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.
About JSI
As trailblazers in the industry, our team of engineering and consulting experts are prepared to craft and implement a broadband solution tailored to your specific needs.
JSI can assist with designing and operating broadband networks, funding applications, forecasting, competitive pricing, mapping, feasibility studies, intercarrier billing, operational reform, strategic partnerships, company valuations, and more. We also offer a full range of OSP and ISP engineering services, including central office, optical transport, FTTx, IPTV, CATV, and wireless. JSI has more than 700 professionals on staff in its Maryland headquarters and in its regional offices in Alaska, Georgia, Hawaii, Illinois, Louisiana, Michigan, Minnesota, North Carolina, Texas, Utah, and Wisconsin. To learn more, please visit us at jsitel.com.