Database Systems Manager - Police

JOB SUMMARY The Police Department Database Systems Manager will be responsible for managing, maintaining, and optimizing the Records Management System (RMS), as well as developing innovative data solutions, improving reporting processes, and assisting personnel with hands-on system support all while maintaining CJIS security requirements.   ESSENTIAL JOB FUNCTIONS: CJIS Database Management: In coordination with IT and the software vendors, install, configure, troubleshoot, optimize, and maintain CJIS-compliant database systems (SQL Server, MySQL, etc.). Ensure databases comply with CJIS security policies and procedures Monitor database performance and collaborate with IT and the software vendors for them to implement changes, and apply new patches and versions, when required Manage user access and permissions in accordance with CJIS policies Conduct regular security audits and assessments with IT to ensure ongoing compliance with CJIS policies   Data Reporting and Analysis: Design and maintain dashboards and web-based tools for reporting, case management, and daily operational insights Review and develop SQL queries to ensure the accuracy of datasets used by Executive, Command, Investigations, Public Information, and Operations Staff Conceptualize, integrate, and maintain data from RMS, CAD, and State supported systems, leveraging comprehensive analysis, for the use of departmental decision-making Evaluate and recommend tools and platforms to enhance data integration and analysis within the Police Department   System Development and Innovation Build, test, and deploy user-friendly digital platforms that streamline internal workflows Identify long-term opportunities for system improvement and implement sustainable solutions Troubleshoot system and vendor-related errors, recommending corrective actions when needed Maintain detailed documentation to support future system maintenance and upgrades Determine appropriate database technologies, models, and storage architecture to ensure police records management systems maintain data integrity and are effective, secure, flexible, efficient, performant, reliable, maintainable, available, and scalable Manage the transition to new solutions and delivery of new technology   User Support & Customer Service Provide in-person assistance to staff needing help with RMS and other digital platforms Collaborate regularly with the Town IT Department to support system management and updates Develop and maintain scripts and stored procedures to automate routine tasks and support database operations to include SQL or SSRS Collaborate with development teams to integrate database functionality with applications Troubleshoot and resolve database-related issues and errors with software vendor support Ensure police personnel will always have accessibility to all required database application resources which may require responding to critical issues after hours, including weekends and holidays   MINIMUM REQUIREMENTS TO PERFORM WORK: Bachelor’s degree in computer information systems, computer science or related field.  Related experience may substitute for the bachelor’s degree on a year-for-year basis.  Five (5) years related work that may include: Troubleshooting database related problems Experience in developing and implementing data intensive applications Experience as a RMS Administrator with a focus on CJIS-compliant systems Must pass a background check and obtain CJIS certification. Knowledge and education in database administration to help provide guidance in utilizing the databases from our software vendors preferred. Knowledge of RMS design and development best practices preferred.   KNOWLEDGE, SKILLS AND ABILITIES: Familiarity with web development, data warehousing, and business intelligence tools. Proficiency in programming languages (SQL, PowerShell, Python etc.) as well as SQL Server Reporting Services. Strong understanding of database security, backup, and recovery processes. Excellent problem-solving skills and attention to detail. Ability to work independently and as part of a team. Strong communication and interpersonal skills.   PHYSICAL REQUIREMENTS: While performing the duties of this job, the employee is regularly required to talk or hear. Specific vision abilities required by this job include close vision, distance vision, usage of computers and reading.   This position requires substantial repetitive motion of wrists, hands, and fingers. The employee is frequently required to stand; walk; use hands to finger, handle, grasp or feel; and reach with hands and arms.   The work requires sitting to perform work tasks with intermittent periods of stooping, crouching, walking, and standing. Occasionally, work may require pushing, pulling, moving, and lifting heavy objects and carrying them (up to 20 lbs.). There may be need to stretch and reach to retrieve materials.   COGNITIVE REQUIREMENTS: The work requires the following mental abilities to perform critical tasks: use judgment, make decisions, interact with others, adapt to changes in jobs, verbal interactions, people skills - more than basic communication with others, and problem solving.   WORK ENVIRONMENT: The work environment involves everyday discomforts typical of offices, with occasional exposure to outside elements. The employee works in a small room with numerous radios, telephones, etc. and the noise or physical surroundings may be distracting, but conditions are generally not unpleasant.