Search for University Jobs in Staff & Non-Managerial Professionals

Job ID: 188883

Database Administrator, Berkeley IT (0597U) 37734
University of California, Berkeley


Date Posted Jul. 25, 2022
Title Database Administrator, Berkeley IT (0597U) 37734
University University of California, Berkeley
Berkeley, CA, United States
Department
Application Deadline Open until filled
Position Start Date Available immediately
 
 
  • Other Administrative Categories
  • Information Technology
 
 


Database Administrator, Berkeley IT (0597U) 37734

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.

Departmental Overview

Berkeley IT believes in and fosters a workplace environment where people can bring their diverse skills, perspectives and experiences toward achieving our goals through a process of critical inquiry, discovery, innovation, while simultaneously committing to making positive contributions towards the betterment of our world.

In addition, members of the Berkeley IT community have created and endorse the following values for our organization to augment and amplify the campus principles:

We champion diversity.
We act with integrity.
We deliver.
We innovate.


Diversity, Inclusion, and Belonging are more than just suggestions for us. They are the guiding principles underlying how we come together, develop leaders at all levels of the organization, and create an environment that unites us. We affirm the dignity of all individuals, call upon our leaders to address critical issues with integrity and intention, respect our differences as well as our commonalities, and strive to uphold a just community free from discrimination and hate.

Team/Unit Overview
Berkeley IT is powered by problem solvers who deliver services and support to drive the campus experience. Campus IT Infrastructure (CITI) is a part of Berkeley IT that provides core infrastructure technology services to the campus; a common, reliable, standards-based technical environment; and cyber-infrastructure for research and education.

Position Summary
The UCB Database team manages over 2067 databases, with 121 MySQL, 156 Postgres, 316 SQL Server, and 1474 Oracle. This is for 100 applications, using > 100TB of space. Database administration involves planning and design, documentation, operational management and protection of campus data. The DBA ensures consistency and recovery of campus data. This position will be the technical lead for Postgres and Mysql on-premise virtualized unix based installations. Candidate will perform upgrades, configure backups with enterprise software, apply security, and do tuning and configuration option administration as needed for over a dozen key campus applications. Candidate will serve in Microsoft SQL on-call rotation as well and should have basic to intermediate knowledge on that platform to triage and fix critical issues for dozens of campus applications, and perform routine tasks. Candidate will support Oracle as needed and OEM experience is beneficial. Candidate will monitor and respond to the ticketing queue for database related issues for all platforms for a wide array of campus applications with a four hour response business hours SLA. Candidate will work with enterprise virtual, platform, storage/backup, networking, application teams as required to keep database systems running smoothly. Work collaboratively on Slack, Zoom, project management software, ticketing system (ServiceNow) with other team members.

Application Review Date

The First Review Date for this job is: 6/30/22

Responsibilities

Database Upgrades & Patches
Patches: Analyze and recommend when patching is needed. Consult with application programmers and managers of other organizations to plan, schedule and implement RDBMS patches and upgrades.
Upgrades: Communicate when support for current versions will expire and plan for upgrades with management and customers. Evaluate and test new functionality and communicate to customers in presentations or demonstrations. Lead efforts to develop and document standards and implement upgrades for identified databases

Database Installation & Design
Installation: Install, test, and deploy the RDBMS software with minimal interruption to services. Develop and document standards for creating instances with the initialization parameters and database structures that represent database best practices.
Design: Recommend, document and implement database-specific policies, procedures and design standards.

Database Operations
Database Monitoring: Oversee that standard baseline monitoring is documented, setup and consistently deployed on all databases. Utilize monitoring software or develop database administration scripts. Automate and continuously improve monitoring of databases for the efficiency of the team. Maintain databases for optimum performance (updating statistics, reorganizations).
Change Management, On Call Support & Troubleshooting: Utilize database best practices in implementing customer change requests. Work with application developers, system administrators,
network administrators and vendors to troubleshoot and resolve issues to minimize downtime. Provide 24 hour support for database issues when on-call. Lead cross-functional teams to resolve complex issues. Follow-up and make improvements to reduce potential for outages. Strive to meet service level agreements on tickets.
Database Backup & Recovery: Develop and maintain database backup and recovery procedures. Perform, evaluate and improve recovery procedures through testing of disaster recovery scenarios.
Tuning: Monitor the performance of databases and proactively identify issues that may occur and tune. Regularly review performance reports and SQL / physical database tuning opportunities with application and DBA teams. Utilize advanced performance tuning skills to work on critical or difficult issues.

Database Security
Develop and maintain database level security in all database environments. Ensure proper authorization procedures are followed for database accounts and permissions.
Knowledgeable of data policy and laws. Continuously research and improve servers, firewalls, network and database to ensure security best practices are documented and followed with emphasis on database security. Develop, document and implement security guidelines and mechanisms for databases

Consulting & Projects
Consulting, Tech Lead & Mentor: Provide database management consulting and technical leadership to the campus. Represent Berkeley IT on campus committees or projects.
Provide guidelines and best practices for optimum database performance to developers.
Keep abreast of new database and programming techniques to optimize database performance and function. Mentor other DBAs and cross-functional technical staff.
Project Management: Project management skills to facilitate the delivery of applications / technical modifications through managing scope, project plan development and maintenance and communication for cross-functional groups.

Capacity Planning & Architecture
Capacity Planning: Monitor, forecast and communicate with Storage and System Administration teams to ensure future storage and hardware needs are available.
Architecture: Research, evaluate and make database design recommendations. Develop database strategies and project proposals through an expert understanding of technology trends within the industry.

Administration
Provide status updates on projects, attend team, IS and IST meetings and track time spent on projects for activity based costing.
Professional development and training

Required Qualifications

  • Minimum 3 year experience as a production technical lead DBA with on-call support for one of the Berkeley IT supported database platforms (Oracle, SQLServer, MySQL, PostgreSQL), with PostgreSQL as the primary platforms
  • A thorough knowledge of the RDBMS's internal architecture is required including in-depth knowledge of advanced features.
  • Minimum 5 years total experience as DBA or DBA developer.
  • Minimum 3 year extensive in-depth experience with the IST database platform operating systems (Unix/Linux and/or Windows).
  • Thorough knowledge of SQL is required for the incumbent to perform complex analysis.
  • Minimum 3 years scripting (PowerShell, Unix Shell (Bash), PERL, or similar).
  • Minimum 1 year experience with technical project management, process development, capacity planning and technical leadership.
  • Must have effective interpersonal and written/verbal communication skills. Must demonstrate technical leadership and project management skills which include the ability to negotiate and clearly communicate the scope of database projects, provide regular status reports and deliverables. Must be able to train technical customers and peers on database techniques. Must be able to prepare publications and presentations on technical concept for campus-wide and/or industry groups. Must have strong documentation skills.
  • Works relatively independently and in consultation with Supervisor and high level technical experts to define systems design requirements and to implement complex systems. Must demonstrate good judgment and decision-making skills along with strong troubleshooting skills for quick problem identification and resolution.
  • The incumbent is required to have one year of experience with technical project management, process development, capacity planning and/or demonstrated technical leadership.
  • This position will require rotating after-hours and weekend on-call coverage.
  • Welcomes differing views and opinions and is able to work with people of diverse backgrounds.


Education:

  • Bachelor's degree in related area and/or equivalent experience/training
  • RDBMS, OS certifications bonus.


Preferred Qualifications

  • PeopleSoft application, Java, Python and/or web development.
  • Multiple database platforms skills.


Salary & Benefits

This is a 100% full-time (40 hrs a week) exempt career position, which is paid monthly and eligible for full UC Benefits.
Annual salary is commensurate with experience within the range of $95,900 - $135,000.
For information on the comprehensive benefits package offered by the University visit:

https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html

How to Apply

Please submit your cover letter and resume as a single attachment when applying. Please upload the document in the Resume section, then skip the (optional) Cover Letter upload section.

Referral Source info
This job is part of the Employee Referral Program. If a UC Berkeley employee is referring you, please ensure you select the Referral Source of "UCB Employee" and then enter the employee's Name and Berkeley email address in the Specific Referral Source field. Please enter only one name and email.
Other Information

May consider the option for fully remote or hybrid work with the ability to come on campus when needed.

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:

https://www.eeoc.gov/sites/default/files/migrated_files/employers/poster_screen_reader_optimized.pdf
For the complete University of California nondiscrimination and affirmative action policy see:
http://policy.ucop.edu/doc/4000376/NondiscrimAffirmAct



To apply, visit https://careerspub.universityofcalifornia.edu/psp/ucb/EMPLOYEE/HRMS/c/HRS_HRAM.HRS_APP_SCHJOB.GBL?Page=HRS_APP_JBPST&Action=U&FOCUS=Applicant&SiteId=21&JobOpeningId=37734&PostingSeq=1





Copyright 2022 Jobelephant.com Inc. All rights reserved.

Posted by the FREE value-added recruitment advertising agency


jeid-4011c5ace620864cbaf487234dcaa59c


 
Please reference AcademicKeys.com in your cover letter when
applying for or inquiring about this job announcement.
 
 

Contact Information

 
Please see the job description for contact details
pertaining to this university job announcement.

 

Refer this job to a friend or colleague!



New Search | Previous