THE COMPANY
Versaterm is a Public Safety software company that has been in business for over 45 years. We provide industry-leading products in mission-critical areas for all areas of public safety including Police, Fire and EMS agencies across North America.Versaterm's FivePoint Solutions focuses on delivering solutions to state and local agencies, primarily courts and law enforcement. We are the U.S.-based leading provider of Pre-trial Services, Case Management, School Safety, Data Exchange, and Records Management services to governments.
FivePoint Solutions is a company that hasn’t forgotten why it exists. We make people’s lives easier by helping them work smarter.THE ROLEWe are seeking a Database Analyst (DBA) who will be responsible for the design, implementation, optimization, and maintenance of the company's database infrastructure. They will collaborate with the software development team to design and create an efficient database schema, ensure data integrity and security, optimize database performance, troubleshoot issues, and ensure regular backups and recovery procedures.
The Database Administrator should have expertise in database management systems, query optimization, data modelling, and be familiar with industry best practices for database administration.Please note that this role would be full-time in the Ottawa office.RESPONSIBILITIES
- Monitoring system performance and identifying problems that arise
- Responding in a timely manner to user-reported errors
- Protecting the database against threats or unauthorized access
- Ensuring that the database is adequately backed up and able to be recovered
- Improving database code for efficiency
- Converting data from legacy/client database sources
- Managing database security by controlling access permissions and privileges
THE ROLE REQUIREMENTS
- 3+ years of database management experience
- Strong Microsoft SQL skills
- Strong written and verbal communication skills
- Microsoft Azure SQL Server experience
