Server, Systems, and Applications Analyst (7309U), Berkeley Law
About Berkeley
At the University of California, Berkeley, we are committed to creating a community that fosters equity of experience and opportunity, and ensures that students, faculty, and staff of all backgrounds feel safe, welcome and included. Our culture of openness, freedom and belonging make it a special place for students, faculty and staff.
The University of California, Berkeley, is one of the world's leading institutions of higher education, distinguished by its combination of internationally recognized academic and research excellence; the transformative opportunity it provides to a large and diverse student body; its public mission and commitment to equity and social justice; and its roots in the California experience, animated by such values as innovation, questioning the status quo, and respect for the environment and nature. Since its founding in 1868, Berkeley has fueled a perpetual renaissance, generating unparalleled intellectual, economic and social value in California, the United States and the world.
We are looking for equity-minded applicants who represent the full diversity of California and who demonstrate a sensitivity to and understanding of the diverse academic, socioeconomic, cultural, disability, gender identity, sexual orientation, and ethnic backgrounds present in our community. When you join the team at Berkeley, you can expect to be part of an inclusive, innovative and equity-focused community that approaches higher education as a matter of social justice that requires broad collaboration among faculty, staff, students and community partners. In deciding whether to apply for a position at Berkeley, you are strongly encouraged to consider whether your values align with our Guiding Values and Principles, our Principles of Community, and our Strategic Plan.
Application Review Date
The First Review Date for this job is: December 2, 2019
Departmental Overview
Berkeley Law is one of the nation's premier law schools, located at one of the world's great universities, in one of the most vibrant places on the planet. As one of the 14 schools and colleges at the University of California, Berkeley, it is consistently ranked as one of the top law schools in the nation.
The law school has produced leaders in law, government, and society, including Chief Justice of the United States Earl Warren, Secretary of State of the United States Dean Rusk, American civil rights activist Pauli Murray, California Supreme Court Justice Cruz Reynoso, president and founder of the Equal Justice Society Eva Paterson, United States Northern District of California Judge Thelton Henderson, and Attorney General of the United States Edwin Meese.
The Statewide Database (SWDB) is the Redistricting Database for the State of California. The SWDB has highly specialized computing needs based on its state redistricting project mandate and statutory requirements. The SWDB is currently preparing for the upcoming census and redistricting in 2020 and 2021 and are assisting the State of California with numerous projects. We are also developing access systems to allow the residents of California to use our dataset online and participate in the redistricting.
The Server, Systems, and Applications Analyst requires an understanding of SWDB mandates and requirements to perform server and systems administration, hardware and desktop support, and networking of various desktops, laptops, servers and printers. The position will also assist with applications programming, communication with independent contractors, and development for the Statewide Database website.
This position will work with the Berkeley Law and the Statewide Database IT teams. Performance of duties takes into account staff needs, ongoing security threats to IT operations, outside user experience, and the specific public responsibilities of the Statewide Database. Tasks will include implementation of data infrastructure systems and performing computer and other hardware maintenance.
Responsibilities
Applies IT concepts to perform complex analyses and functions from multiple IT areas of specialization.
Server administration - Perform routine and non-routine maintenance tasks; urgent downtime response; security auditing
Web applications - Work on feature modules, design and migrate database schemas, deploy multi-server applications, implement security best practices
Geographic Information systems - Set up and maintain systems, test datasets with GIS for common tasks, read and analyze custom GIS code.
Data analysis systems - Design and write data processing scripts, configure and operate infrastructure for larger data analysis jobs
Analyzes complex programs or formulates logic for new systems.
Partner with external developers and collaborators on their code, analyze and contribute to their work, and integrate their projects into SWDB cloud infrastructure.
Develop logic and infrastructure to support such projects
Develop new tools for data storage, processing, filtering, and delivery on our servers and on the web
Design and implement test cases for both new and legacy code, writing Unit and Integration test suites for Python, JavaScript, and other codebases as needed. These will include web server and data processing code. Debug complex software, with an understanding of execution context and software architecture. Test datasets for consistency.
Develops conversion and system implementation plans.
Analyzes legacy and industry standard systems, and constructs phased plans to keep systems operational while making necessary changes to architecture and tools in multiple areas, such as server security, data backups, data delivery online, web accessibility, and data analysis infrastructure.
Prepares programming documentation.
Creates documentation for developers and data users, documenting internal practices and data analysis tools across tabular and geographic data
Maintains security configurations on locally-hosted and cloud-based (AWS) servers
Analyzes, installs, modifies and supports operating systems, database or utilities software.
Analyzes business problems to be solved with automated systems.
Including internal backups, secure data storage and transmission, the creation of geographic and other datasets
Analyzes and implements LAN and/or WAN system projects.
May recommend changes in development, maintenance and system standards.
Required Qualifications
Has knowledge of professional concepts.
Has knowledge of applications programming technologies, tools and protocols.
Has skills necessary to communicate effectively both in writing and verbally.
Working knowledge of server administration, security, and maintenance
Working knowledge of web application development, concepts, and security practices
Ability to work with users and area specialists to develop and test information systems
Ability to balance multiple projects and priorities, from long term projects to urgent security
Ability to analyze and process Census and Redistricting datasets and collaborate with various parties that collect and process these datasets, as well as data consumers, in order to facilitate their production and use
Knowledge of redistricting process and is able to use professional concepts to further the specific public mandate of the Statewide Database
Ability to work with and analyze geographic data and geographic information systems (GIS)
Ability to evaluate geographic toolsets and software for different roles, including desktop tools and backend software for processing and serving geographic data
Experience using containerized workflows for tasks such as batch data processing and application deployment
Advanced skills in python programming including Pandas and GeoPandas
Strong skills in computer networking and protocols such as TCP/IP, https.
Education/Training:
Bachelors degree in Computer Science or related area and/or equivalent experience/training.
Experience in database management, including schema design, query writing, and optimization.
Experience configuring and monitoring AWS resources.
Experience with server administration, IT security, and maintenance.
Salary & Benefits
This is an exempt, monthly paid position. Annual salary is commensurate with experience.
For information on the comprehensive benefits package offered by the University visit:
Please submit your cover letter and resume as a single attachment when applying.
Other Information
This is a two-year, full-time, 40-hours per week, Contract position. This position is eligible for vacation and sick leave accrual, and will be eligible to participate in our full benefits package. To learn more about what is available in our full benefits package, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/eligibility/index.html
Conviction History Background
This is a designated position requiring fingerprinting and a background check due to the nature of the job responsibilities. Berkeley does hire people with conviction histories and reviews information received in the context of the job responsibilities. The University reserves the right to make employment contingent upon successful completion of the background check.
Equal Employment Opportunity
The University of California is an Equal Opportunity/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, or protected veteran status. For more information about your rights as an applicant see: http://www.eeoc.gov/employers/upload/poster_screen_reader_optimized.pdf
The University of California was chartered in 1868 and its flagship campus - envisioned as a "City of Learning" - was established at Berkeley, on San Francisco Bay. Today the world's premier public university and a wellspring of innovation, UC Berkeley occupies a 1,232 acre campus with a sylvan 178-acre central core. From this home its academic community makes key contributions to the economic and social well-being of the Bay Area, California, and the nation.
