UC Berkeley

Application Review Date
The First Review Date for this job is: December 6, 2012.
Departmental Overview
The UC Berkeley Department of Civil and Environmental Engineering is undergoing a renaissance as its faculty and students are called upon to improve civil infrastructure, protect resources, mitigate natural hazards, and create efficient and sustainable engineered systems in order to address challenges facing society. As the department evolves to help students prepare to meet these challenges, it requires staff to demonstrate initiative, resourcefulness, flexibility, and professionalism.The rigorous programs of the Civil and Environmental Engineering department (CEE) at UC Berkeley prepare students for leadership in engineering careers.  US News and World Report ranks our graduate programs in civil engineering and in environmental engineering #1 for 2013 (4 years in a row).

The department has fifty full-time faculty members and twenty staff dedicated to the education of more than 400 undergraduate and 360 graduate students.

The Department of Civil and Environmental Engineering is seeking an Applications Programmer to develop departmental web applications and administer the department website content management system.

The Applications Programmer 3 is responsible for web application development and maintenance. The Application Programmer 3 develops and maintains the Drupal content management system providing the infrastructure for the department website. The Applications Programmer 3 establishes best practices, policies and procedures for web software development within the department. The Applications Programmer 3 must be experienced in systems analysis and software engineering.80% Web Application Development
• Independently manage the design, programming, modification and maintenance of complex web applications.
• Perform systems analysis by working with clients to determine needs and creating functional specifications and mockups.
• Utilize extensive knowledge of best coding practices to ensure security of all web applications and databases.
• Update and extend departmental web applications. Design user interfaces to ensure ease of use, visual appeal, and consistency.
• Troubleshoot problems, resolve security issues, and develop policy and procedures that apply to departmental web applications.
• Implement database applications using a thorough understanding of relational database design principles. Read and generate database schema and administer complex relational databases. Use extensive SQL experience to create complex queries with multiple joins.
• Configure, install, and maintain MySQL databases on Linux servers.
• Interface with and import data from external campus databases. Integrate applications with campus-wide secure authentication systems.
• Document databases and applications using database modeling tools, wikis, and text documents.
• Participate in campus-wide technical groups and mailing lists.

20% Drupal CMS Development
• Develop and maintain the department website Drupal content management system including installation of major version upgrades, security updates, module installation, and implementation of site functionality enhancements.
• Build web applications in Drupal and integrate existing web apps with Drupal.
• Enhance site usability and visual appeal through theming, CSS, and graphic design.
• Serve as a Drupal resource for IT staff throughout the College of Engineering.
• Create site sections and pages for editing by content editors.

Required Qualifications
• Advanced skills in web application programming, functional and object oriented programming using PHP, MySQL, Apache, LDAP.
• Highly developed knowledge of software engineering best practices, relational database design, and web application security.
• Ability to independently perform systems analysis and abstract application requirements from real-world processes.
• Demonstrated ability to develop and maintain Drupal websites.
• Proficiency in user interface design, visual design, CMS theming, and CSS.
• Motivation and ability to learn new technologies quickly and independently.
• Strong problem solving and critical thinking skills, creativity, and attention to detail.
• Ability to communicate and collaborate with technical and non-technical personnel at various levels in the organization.
Preferred Qualifications
• Knowledge of campus processes and procedures including faculty hiring, course data tracking, and department fund distribution.
• Bachelors degree in related area and/or equivalent experience/training
• 3 or more years of experience in software development
Salary & Benefits
$57,000 – $84,600 annually, depending on qualifications and experience.  This is to the midpoint of the salary range for Grade 22 in the Professional and Support Staff (PSS) program for classification as Applications Programmer 3 (UCB).For information on the comprehensive benefits package offered by the University visit:
Criminal Background Check
This position has been designated as sensitive and may require a Criminal Background Check. We reserve the right to make employment contingent upon successful completion of a Criminal Background Check.
Equal Employment Opportunity
The University of California, Berkeley is an Equal Opportunity/Affirmative Action Employer.

3 thoughts on “UC Berkeley

  1. The guy is friendly, told me about the job first without asking me about myself. The job is basically exactly the same as ECE, with less IT people than I imagined. And, it’s probably like the ECE before I started. They are still using plain PHP (!).

    He asked me not to be mistaken LA with the Berkeley.

    Q1: Why are you interested in the job?
    A: I enjoyed working in the university, had done that for 4 years.

    Q2: Tell me about a time you had a failed initiative.
    A: (confidently) The asset tracking project. The managers were confusing themselves and I ended doing more than is required. Probably need to be tackful and assertive.

    Q3: What would be the first thing you do after you start the job?
    A: Look into the database and get a feel for what is available and what the relationship between databases. Then get familiar with the PHP code.

    Q4: What is the next big thing for academic world?
    A: (I answered that off the track) PHP Framework,

    Q5: How do you deal with priorities? What are your strengths and weaknesses?
    A: Ask my supervisor, if I’m not sure.

    Q6: What is the biggest project you have worked on? What methologies you had used?

    Q7: How do you keep track of tasks and deadlines?

    Q8: Tell me about a disagreement you had eg technical preferences.

  2. Onsite interview
    Q: Why do you want to apply for this job?
    Q: Do you have screenshots for us to look at?
    Q: Do you have challenages when comes to non-technical users
    Q: Is PHP better than Python.
    Q: What are the CMSs you have worked on before, What are the adcantages
    Q: What’s your approach to design databases, normalisations.
    Q: What editor you use for CSS
    Q: What approaches you use for documentation
    Q: Do you know much about Drupal
    Q: What security measures you use for PHP
    Q: What are the advantages using jQuery vs. JavaScript
    Q: What is your personal visions

    I’m much more comfortable and at ease then with other interviews and come up with good answers. I never remember mentioning my WordPress empowered documentation site before. I think those people calm me down, and also make me want to perform better because I like university people.

    I also mention my personal vision to be a better requirement analyst, better documenter, which I have never done before.

    Compare to with Google, I kept getting nervous and not come up with answers.

  3. Even the replies are better, eg. using daily examples. Like mentioning that jQuery suck bad using on the asset database, but goes away after a version upgrade. It feels like that I’m really doing the work. Or mentioning that trying to install Django with MS SQL takes all day; whereas with MySQL takes 2 seconds.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s