Computer Engineering Job Resources
Students may also find the following links useful:
Computer Engineering Jobs
Back to Blog
Database and Web Application Developer
Tuesday, Jan. 14, 2014
Stanford University Department of Public Safety
Position Title: Database and Web Application Developer
Status: 100% FTE; 3 year fixed term; 4P3, JCC 5018
The Database and Web Application Developer will be responsible for the design, implementation and maintenance of database and web applications for the Department of Public Safety.
The incumbent will conduct needs-assessment studies of various departmental processes as well as become familiar with applicable law enforcement industry standards, and will develop database and/or web applications to address those needs in order to improve data storage and access, online forms, maintain data security and integrity, and reduce redundancy in currently existing data systems.
Work assignments will be performed in collaboration with various divisions and department personnel, requiring tact, discretion, good listening and customer service skills. The position requires both creative and technical ability, familiarity with law enforcement data security constraints, and the ability to exercise a high degree of independent judgment. Strong communication and interpersonal skills are necessary.
When conducting needs-assessments, the incumbent must ask questions which will ensure that the users’ needs are fully understood and ultimately address those needs in light of overall security and confidentiality concerns. The incumbent must be able to determine the scope of projects, handle multiple projects simultaneously, and provide accurate estimates and project plans. Attention to detail, strong customer service, high level of computer proficiency, and a high level of energy, enthusiasm and flexibility along with an understanding of the department’s Core Values and R.O.O.T.S. philosophies will be key characteristics of the successful incumbent.
All benefits-eligible members of the Stanford Department of Public Safety are considered essential (or required) university personnel for purposes of managing emergencies and critical incidents impacting significant portions of the campus. As such, all benefits-eligible DPS personnel are expected to respond to campus during a major emergency. In conjunction with other DPS personnel, the Database and Web Application Developer will be responsible for implementing ICS during large scale and/or high profile special events and critical incidents. Additionally, this position will play a key role in the special events management efforts. These responsibilities will require the incumbent to work nights and weekends, sometimes with little advance notice. This position is subject to shift work.
Database Application Development (45%)
- Review current data storage systems and conduct needs-assessment research with department stakeholders to determine where improvements should bemade. 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.
- Provide project leadership in both new and existing production, development andtest environments.
- Develop project plans that translate department needs into technical requirements. 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 authorization constraint.
- Promote department and university standards and ensure that all applications are fully compliant with applicable regulations and best practices.
- With input from others, create and maintain meaningful queries and reports for data extraction based on the reporting needs of key stakeholders including the Director and Command Staff.
- Work closely with Senior System Computer/Server Administrator to maintain the integrity of department databases through multiple access schemes; facilitate sharing of common data by overseeing proper key and index management. Monitor database backups, install, upgrade and maintain database software; restore and/or recover data as necessary.
- Develop, update 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.
- Employ industry standard tools and techniques in analysis and design, including business, object, data and process modeling.
Web Application Development (45%)
- Review the structure and content of the current department websites. Ensure the clear, comprehensive and accurate presentation of the Stanford Department of Public Safety’s online presence on the Internet. Ensure that department website content is accurate and updated as necessary.
- Design, develop and maintain web site documents, online forms, templates, graphics and navigational tools that will enhance the overall operations of the Department.
- Evaluate and implement content and design improvements to current web site to include the development of various online reporting systems both for internal department use as well as for external community access. Incorporate new web technology, features and functionalities including the development of database driven web pages and web-portals for existing department databases where appropriate.
- Ensure web applications are protected against vulnerabilities and perform periodic audits. Maintain security of data collected via web applications in accordance with applicable state and federal regulations.
- Develop the department intranet as a resource for information sharing, online forms, data access and improved efficiency for field operations.
- Develop site content, including writing original content and updating existing content. Review and approve content submitted by department divisions, editing to meet University and site standards.
- Work closely with Senior System Computer/Server Administrator to provide technical support to department personnel for database and web applications.
- Identify and support writing of collateral media that drive traffic to the web site.
- Collaborate on developing flyers and other types of web media to support Department recruiting efforts.
- Monitor other university and municipal police agencies sites in order to keep current with web site development, design issues, and web security protection.
- Evaluate, track, and report web site statistics including usage of department’s website, and recommend improvements to existing site for increased effectiveness and efficiency by statistical analyses, and usage trends.
- Provide training to end-users and personnel on an as needed basis.
- Suggest local/remote hosting solutions/requirements and security protections thereto.
Other Duties (10%)
- Provide basic computer administration support during Network Administrator’s short-term vacancies (sick days, time-off, training time, etc…).
- Provide logistics and other support during all home football games, major events and campus emergency situations.
- Weekend work and shift work will be required on short notice, including all home football games each year.
- The qualified candidate will have the following skills, knowledge and abilities:
- Familiarity with systems analysis and design for secure web-based and database application development.
- Strong working knowledge of relational database software including SQL Server and Oracle, graphical and event driven user interfaces, object oriented development using Visual Basic, and web based server and client technologies.
- Strong working knowledge of web development using HTML, Drupal, ASP, ASP.NET, VB.NET, XML, XSL, XSLT, Java Script and AJAX. Moodle Rooms development may require some PHP knowledge.
- Experience with browser compatibility issues.
- Experience prototyping web applications, designing and critiquing web user interfaces, with a focus on security, usability, and standards.
- Remain current and install latest security updates, and patch for any known vulnerabilities.
- Experience with common enterprise technologies and techniques including caching, locking, fail over and encryption.
- Experience in the development of front-end applications on a Windows Platform using Microsoft Access, Visual Basic, CONM, or similar tools.
- Strong verbal and written communication skills; excellent customer service skills.
- Knowledge of the principles, practices, and techniques of systems analysis, design and development, and experience in analysis, design development and implementation.
- Ability to analyze and determine the applicability of electronic data, to draw accurate conclusions and make appropriate recommendations.
- Ability to design, program and implement new systems as well as to understand and suggestions to improve existing systems.
- Experience with major web and application server products.
- Familiarity with standards such as LDAP, HTTP, iCAL, RSS, ATOM.
- Proven project management and organizational skills with the ability to work on multiple projects simultaneously, to prioritize, and to meet strict deadlines with minimal supervision.
- Ability to work under pressure, take initiative and prioritize tasks; good time management, problem solving, and customer service skills.
- Ability to maintain and exercise sound judgment and discretion in handling confidential information and to keep sensitive information strictly confidential and secure at all times.
- Demonstrate aptitude and attitude for learning new tasks quickly and efficiently.
- Ability to work in a team environment as well as independently.
- Desire to learn, accept and promote the Department’s Core Values and R.O.O.T.S. philosophies.
- Knowledge of University policies and procedures preferred.
Experience and Training Guidelines:
- Any combination of experience and training will qualify if it provides for the required knowledge and abilities.
- A bachelor’s degree from an accredited college or university with major course work in information systems, computer science, business administration or a closely related field is highly desirable.
- A minimum of three years experience in information systems, including database and web development/management.
- Experience with city government web sites desirable.
- Understanding of project management practices and principles.
- Applicants must pass a complete background including a search of local, state, and national files for criminal history.
- Must be able and willing to respond to and work large-scale events as well as unplanned critical incidents, sometimes with little advance notice.
- Interview with Department and University Personnel
- Personal History Questionnaire (PHQ)
- Background Investigation
- Personal Interview with the Director of Public Safety
Applicants can apply on-line at http://stanfordcareers.stanford.edu job # 61192
You may also e-mail firstname.lastname@example.org for assistance with instructions.
* Stanford Department of Public Safety does not pay the candidate for travel expenses associated with testing / interviewing, unless otherwise indicated by the department at the time of call for interview.
*Stanford University is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, age, national origin, veteran status, physical or mental disability, or sexual orientation.
Posted by Apryl Roberts