Responsible for the design, implementation and maintenance of database and web applications for the Department of Public Safety (DPS), a 24/7, 365-day law enforcement operation. Maintain database and web systems currently deployed; additionally, the incumbent will perform needs-assessment studies of departmental processes in order to develop systems that will improve existing processes, provide data storage and access, maintain data security and integrity, and reduce data redundancy. Provide technical expertise in front-end and back-end web development. Support web infrastructure by providing end-user support, applications maintenance, back-end development and internal management in a cloud-based environment to ensure scalability and security requirements. Responsible for maintaining/developing database and/or web applications that are compliant with State and Federal Law Enforcement standards, university protocols and best practices using HTML, LDAP, HTTP, iCAL, RSS, ATOM CSS, Drupal, WordPress, ASP, ASP.NET, VB.NET, XML, XSL, XSLT, Java Script and AJAX, PHP. Review the physical and logical design of current data storage systems and conduct needs-assessment research with department stakeholders to determine where improvements should be made. This review includes but is not limited to a review of the department police records storage systems, daily activities tracking system, special events database and equipment inventory systems. Install, configure and support relational database management systems (RDBMS) and related software to resolve highly complex/unique issues for Public Safety. Implement solutions for optimal database structures, security and backup/recovery. Design, develop and maintain highly available databases, developing project plans that translate department needs into technical requirements. Execute complete database solutions from evaluation to implementation. This may include researching and implementing "off the shelf" database applications or the development of unique in-house applications which should be protected by an appropriate authorization constraint. Develop and enforce database standards and/or new development protocols that promote department and university standards and ensure that all applications are fully compliant with applicable regulations and best practices. Maintain the integrity of department databases through access controls such as multi-factor authentication; facilitate sharing of common data by implementing proper key and index management. Monitor database backups, install, upgrade and maintain database software; restore and/or recover data as necessary. Create data flow and data lifecycle documentation; develop and maintain internal database documentation describing requirements, design specifications, implementation and ongoing changes in applicable procedures for use by end users as well as other network personnel. Implement robust security measures for both web applications and database systems, including data encryption, and vulnerability assessments; monitor systems to protect sensitive data and mitigate cybersecurity risks. Track system performance, analyze trends, and proactively address issues before they impact service delivery.