Database Systems Manager - Police

Town of Mount Pleasant•Mount Pleasant, SC

21h•Onsite

About The Position

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.

Requirements

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 experience that may include troubleshooting database related problems.
Five (5) years related work experience that may include developing and implementing data intensive applications.
Five (5) years related work experience as a RMS Administrator with a focus on CJIS-compliant systems.
Must pass a background check and obtain CJIS certification.
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.

Nice To Haves

Knowledge and education in database administration to help provide guidance in utilizing the databases from our software vendors.
Knowledge of RMS design and development best practices.

Responsibilities

Install, configure, troubleshoot, optimize, and maintain CJIS-compliant database systems (SQL Server, MySQL, etc.) in coordination with IT and software vendors.
Ensure databases comply with CJIS security policies and procedures.
Monitor database performance and collaborate with IT and software vendors for implementing changes, applying 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.
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.
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.
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.