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.
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.
I love that Stanford is supportive of learning, and as an education institution, that pursuit of knowledge extends to staff members through professional development, wellness, financial planning and staff affinity groups.
Nora Cata
School of Engineering
I get to apply my real-world experiences in a setting that welcomes diversity in thinking and offers support in applying new methods. In my short time at Stanford, I've been able to streamline processes that provide better and faster information to our students.
Phillip Cheng
Office of the Vice Provost for Student Affairs
Besides its contributions to science, health, and medicine, Stanford is also the home of pioneers across disciplines. Joining Stanford has been a great way to contribute to our society by supporting emerging leaders.
Denisha Clark
School of Medicine
I like working in a place where ideas matter. Working at Stanford means being part of a vibrant, international culture in addition to getting to do meaningful work.
Laura Lind
Office of the President and Provost
Join Stanford in shaping a better tomorrow for your community, humanity and the planet we call home.