Senior Database Administrator
- Employer
- University of California-Irvine
- Location
- Irvine
View more
- Administrative Jobs
- Technology, Database Administration
- Employment Type
- Full Time
- Institution Type
- Four-Year Institution
Job Details
University of California Irvine
Senior Database Administrator
Updated: Sep 9, 2022
Location: Irvine-Campus
Job Type:
Department: OIT Central Srvcs Operations
Job Opening ID: 36953Reports To: Data Systems Supervisor IIWorking Title: Senior Database AdministratorDepartment: OIT Central Srvcs OperationsBargaining Unit: 99FLSA: ExemptPayroll Job Code: 000597Job Location: UCI Campus- IrvinePercent of Time: 100%Work Schedule: VariesEmployee Class: Career Position Summary: The Office of Information Technology (OIT) is responsible for supporting the IT needs of UC Irvine faculty, students, and staff. Our mission is to provide information technology leadership, services, and innovative solutions to promote the research, education and community service goals of the University. The OIT Database Administration Team is responsible for the deployment, ongoing maintenance, support, security and availability of databases for campus systems. Under direction of the Manager, Database Management, the Senior Database Administrator position applies advanced database administration concepts and campus objectives to support highly complex, heterogeneous mission critical database systems. Assesses business needs and technical considerations with minimal direction in order to complete database administration projects of advanced scope and complexity. Selects methods, techniques and evaluation criteria to obtain results. Implements database solutions from evaluation to implementation of large enterprise level hardware and software. Candidate will work in a highly complex technical environment that requires expert knowledge of MySQL and also preferably advanced Oracle database administration skills. Candidate will use advanced database knowledge to work with system administrators to establish optimal operating system, database and network parameters for campus database systems and also will provide advanced technical assistance to application development groups. Leads large, highly complex database migrations and projects of advanced scope and complexity that span many months. Candidate has responsibility for capacity planning and disaster recovery for campus-wide mission critical large databases. Compensation Range: Commensurate with experience Department Website: https://www.oit.uci.edu/org/ Required:
- Five (5)+ years' experience in MySQL Database Administration. Prefer three (3)+ years of Oracle Database Administration experience.
- Five (5) plus years with BA/BS OR three (3) to five years with MA/MS or equivalent combination of education and experience.
- Advanced knowledge of MySQL 5.7/8 database administration concepts and architecture.
- Ability to install/upgrade MySQL in Oracle Linux 7 and above.
- Strong skills writing and maintaining custom shell scripts in Oracle Linux V7 environment and above.
- High proficiency in SQL for MySQL.
- Should be able to understand and troubleshoot any SQL performance issues.
- Significant experience with performance tuning, troubleshooting, capacity planning and optimization of MySQL environment.
- Strong skills and experience working with MySQL Support to do troubleshooting and resolution of MySQL database problems.
- Skills associated with implementing database enhancements that improve performance and reliability of the system at the software, hardware and operating system level.
- Advanced knowledge of MySQL InnoDB High Availability cluster configuration with 3-5 node cluster, including troubleshooting if needed.
- Strong knowledge of configuring MySQL source/target environment for database replication and data preservation.
- Proficiency in patching/upgrading MySQL including doing so while maintaining database uptime in High Availability InnoDB cluster or with minimum downtime for source/target replication.
- Strong knowledge of backup/restore steps in InnoDB and MyISAM environments.
- Be able to perform point in time recovery.
- Advanced knowledge of MySQL monitoring tools and configuring alerts for any issues.
- Demonstrates good judgment and decision-making; problem identification and resolution; identifying measures of system performance and the actions to improve MySQL performance through database configuration and programming techniques.
- Demonstrates reasoning and ability to develop original ideas to solve problems.
- Skills necessary to develop procedures and standards relating to database management systems.
- Demonstrates interpersonal skills, problem solving skills, service orientation, active listening, effective verbal and written communication skills and organizational skills.
- Able to multi-task and prioritize tasks.
- Ability to work independently on complex technical projects as well as on a team of technical professionals and relevant decision-makers.
- Strong security skills for protecting the operating system, software, data and hardware.
- Technical skills to develop, implement and test disaster recovery functions using data replication and/or backup technologies.
- Adhere to OIT's cultural values: Collaboration, Respect, Trust, Transparency, Quality, Inclusiveness, Customer Centricity, and Learning and Growth.
- Experience securing MySQL 8 databases using recommendations in CIS benchmarks.
- Implementation of Transparent Data Encryption for MySQL database tables.
- Strong knowledge of using MySQL router and implementing this for MySQL InnoDB Clustering to implement High Availability for campus systems.
- Advanced knowledge of Oracle 12/19c database administration concepts and architecture.
- Significant experience with Oracle database administration, performance tuning, troubleshooting, capacity planning and optimization of Oracle environment.
- DataGuard implementation of Oracle disaster recovery databases.
- Experience with administering databases running on Oracle Database Appliances.
The University of California, Irvine is an Equal Opportunity/Affirmative Action Employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories covered by the UC nondiscrimination policy.
UCI provides reasonable accommodations for applicants with disabilities upon request. For more information, please contact Human Resources at (949) 824-0500.
#OIT
Job Opening ID: 36953Reports To: Data Systems Supervisor IIWorking Title: Senior Database AdministratorDepartment: OIT Central Srvcs OperationsBargaining Unit: 99FLSA: ExemptPayroll Job Code: 000597Job Location: UCI Campus- IrvinePercent of Time: 100%Work Schedule: VariesEmployee Class: Career Position Summary: The Office of Information Technology (OIT) is responsible for supporting the IT needs of UC Irvine faculty, students, and staff. Our mission is to provide information technology leadership, services, and innovative solutions to promote the research, education and community service goals of the University. The OIT Database Administration Team is responsible for the deployment, ongoing maintenance, support, security and availability of databases for campus systems. Under direction of the Manager, Database Management, the Senior Database Administrator position applies advanced database administration concepts and campus objectives to support highly complex, heterogeneous mission critical database systems. Assesses business needs and technical considerations with minimal direction in order to complete database administration projects of advanced scope and complexity. Selects methods, techniques and evaluation criteria to obtain results. Implements database solutions from evaluation to implementation of large enterprise level hardware and software. Candidate will work in a highly complex technical environment that requires expert knowledge of MySQL and also preferably advanced Oracle database administration skills. Candidate will use advanced database knowledge to work with system administrators to establish optimal operating system, database and network parameters for campus database systems and also will provide advanced technical assistance to application development groups. Leads large, highly complex database migrations and projects of advanced scope and complexity that span many months. Candidate has responsibility for capacity planning and disaster recovery for campus-wide mission critical large databases. Compensation Range: Commensurate with experience Department Website: https://www.oit.uci.edu/org/ Required: Preferred: Special Conditions Required: May be required to work evenings/weekends as needed to apply system patches or upgrade databases. Position qualifies to work fully remote. If candidate is in local area, may require occasional meetings on campus. Final candidate subject to background check. As a federal contractor, UC Irvine is required to use E-Verify to confirm the work status of individuals assigned to perform substantial work under certain federal contracts/subcontracts.
The University of California, Irvine is an Equal Opportunity/Affirmative Action Employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories covered by the UC nondiscrimination policy.
UCI provides reasonable accommodations for applicants with disabilities upon request. For more information, please contact Human Resources at (949) 824-0500.
To apply, visit https://careersucirvine.ttcportals.com/jobs/9753670-senior-database-administrator
Copyright ©2022 Jobelephant.com Inc. All rights reserved.
Posted by the FREE value-added recruitment advertising agency jeid-e9c1dcf0cce8464aaf55fdea35c3fba2
Organization
Founded in 1965, UC Irvine combines the strengths of a major research university with the bounty of an incomparable Southern California location. Over five remarkable decades, UCI has become internationally recognized for efforts that are improving lives through research and discovery, fostering excellence in scholarship and teaching, and engaging and enriching the community.
With more than 33,000 students, 1,200 faculty members and 10,000 staff, UCI is among the fastest-growing campuses in the University of California system. Increasingly a first-choice campus for students, UCI ranks among the top U.S. universities in the number of undergraduate applications and continues to admit freshmen with highly competitive academic profiles. Orange County’s second-largest employer, UCI generates an annual economic impact on the county of $5 billion.
UCI is a center for quality education that honors classic instruction while incorporating the best new scholarship. U.S. News & World Report consistently ranks UCI among the nation’s best universities. Achievements in the sciences, social sciences, social ecology, arts, humanities, medicine and business also have garnered numerous national rankings for UCI’s schools, departments and programs. Three UCI researchers have won Nobel Prizes – most recently Irwin Rose, in chemistry, in 2004.
Interdisciplinary research, a UCI hallmark, is evident in the California Institute for Telecommunications and Information Technology, or Calit2, Newkirk Center for Science and Society, Center for the Study of Democracy, Institute of Transportation Studies, Institute for Genomics and Bioinformatics, and innovative instructional programs in biomedical engineering, international studies, global cultures, arts and technology, and other collaborations.
The university is dedicated to excellence through diversity and to the goal of reflecting equity and inclusion in our faculty, staff and student populations. Faculty and staff diversity affinity groups foster cross-departmental social interaction, professional networking, cultural competencies, recruiting and mentoring.
Committed to the Community
UCI reaches beyond the classroom and laboratory to help solve societal issues and support human development. In the health sciences, UCI is noted for its research on cancer, the neurosciences and the genetic underpinnings of disease. UCI Medical Center, Orange County’s only university hospital and Level I trauma center, has been ranked among the nation’s best hospitals by U.S. News & World Report for 16 consecutive years.
A major intellectual and cultural center, UCI engages the community through public activities and events. Speakers on campus, for example, have included Nobel Peace Prize winners His Holiness the XIV Dalai Lama, former Soviet leader Mikhail Gorbachev and Iranian human rights activist Shirin Ebadi, all of whom also received the UCI Citizen Peacebuilding Award for their efforts toward world peace.
The university is also addressing the needs of the community and growing world population in an environmentally sustainable way. From the development of new and reliable processes for electricity and alternative fuels to critical water and waste management solutions, UCI consistently tops the list in Sierra magazine’s “Coolest Schools” report, its annual sustainability ranking of U.S. colleges and universities.
A hub for innovation and entrepreneurship, the university collaborates with the community on many strategic partnerships such as UCI Applied Innovation , a center which brings campus-based discoveries together with Orange County’s vibrant business sector to support job creation and economic growth. Development also continues on the 185-acre University Research Park adjacent to campus, where R&D companies enjoy collaborative opportunities in medical research, biotechnology, engineering, computer science and business.
UCI is benefiting the community and the world in countless ways through its scholarly, scientific, creative and economic contributions. On its way to becoming a flagship UC campus and one of the nation’s very best universities, UCI has embarked on a strategic plan that will ensure the campus continues to inspire excellence as it fulfills its research, teaching and public service missions in the decades ahead.
- Website
- http://www.uci.edu/
- Telephone
- 949-824-5011
- Location
-
University of California, Irvine
Irvine
CA
92697
US
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert