"Alerted.org

Database Admstr 2

Department of Public Safety, Stanford, California, United States

Information Technology Services

Post Date Apr 25, 2025

Requisition # 106340

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.

Qualifications:

Bachelor’s in Information Systems Management, Software Engineering or a related field and five years’ experience as a database administrator or occupation in database administration or Master’s in Information Systems Management, Software Engineering or a related field and three years’ experience as a database administrator or occupation in database administration.

+ Must possess five years with a Bachelor’s or three years with a Master’s in the following:

+ Design and implementation of complex database architecture.

+ Supporting requirements of large database applications and systems including performance analysis and tuning of high-volume transaction systems.

+ Project management, systems analysis and design for secure web-based and database application development.

+ Development of front-end applications on a Windows Platform using Microsoft Access, Visual Basic, CONM, or similar tools.

+ Common enterprise technologies and techniques including caching, locking, fail over and encryption.

+ Developing websites and web applications using open source tools, languages, libraries and current standards-compliant code.

+ Prototyping web applications, designing and critiquing web user interfaces, with a focus on security, usability, and compliance.

+ Demonstrated proficiency managing cloud services across various platforms including but not limited to Microsoft Azure including setting up virtual machines and storage solutions, configuring networking, VPN and security policies that ensure infrastructure meets performance, scalability, and security requirements.

+ Web development using HTML, CSS, ASP, ASP.NET, VB.NET, XML, XSL, XSLT, Java Script and AJAX, PHP.

+ Must have working knowledge of standards such as LDAP, HTTP, iCAL, and RSS.

+ Must be able to demonstrate proficiency managing cloud services across various platforms including but not limited to Microsoft Azure and industry standards ensuring scalability and security requirements.

Location of Position: 233 Bonair Siding Road, Stanford, CA 94305.

Salary: $150,922 - $180,345 annually

_The job duties listed are typical examples of work performed by positions in this job classification and are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks, and responsibilities. Specific duties and responsibilities may vary depending on department or program needs without changing the general nature and scope of the job or level of responsibility. Employees may also perform other duties as assigned._

_Consistent with its obligations under the law, the University will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of his or her job._

_Stanford is an equal employment opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law._

Additional Information

+ **Schedule: Full-time**

+ **Job Code: 4762**

+ **Employee Status: Regular**

+ **Grade: K**

+ **Requisition ID: 106340**

+ **Work Arrangement : On Site**