Database Administrator (DBA) (SYS ADM 3 TX)

#CA-PS
The Systems Administrator position, reporting to the Director of IT Operations and the Systems Administrator Supervisor, is responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems. This role requires deep technical expertise in Microsoft SQL Server administration and database systems, as well as a proactive approach to optimizing and automating processes. The position involves ensuring the availability, consistent performance, security, and scalability of web applications and systems, while independently managing moderately complex database services and configurations. The Systems Administrator will collaborate closely with SVM-IT Sysadmins and developer staff to resolve system issues and assist in database design, backup and recovery planning, and maintaining security standards.

Apply By Date
3/17/2025 at 11:59pm

Qualifications
Minimum Qualifications - For full consideration, applicants are encouraged to upload license and/or certification if required of the position
* Bachelors degree in a related area of Information Technology or equivalent years of experience and/or training in Information Technology.
* Minimum of 5 years in Database Administration or equivalent
* Experience with Windows Server and Active Directory, including security policies and permissions related to database environments. Working knowledge with SQL Server Always On, clustering, replication, and other high-availability solutions.
* Proven expertise in MS SQL Server database administration, including independent installation, configuration, optimization, and upgrading of SQL Server databases and related products in accordance to industry best practices. Expertise in database tuning, optimization, and troubleshooting to ensure high levels of performance, availability, and security. Working knowledge of Ola Hallengren's Maintenance Scripts.
* Demonstrated ability to independently design and implement database backup, recovery, and disaster recovery strategies for complex systems while ensuring alignment with best practices and organizational requirements. Strong knowledge of T-SQL and experience with stored procedures, triggers, functions, configuring linked servers (particularly to Oracle DBs), scheduled jobs, encrypted connections.
* Familiarity with monitoring tools and methodologies to proactively ensure performance optimization and availability of databases. Experience in designing and implementing database security controls to comply with regulatory standards, security policies, and best practices.
* Applies advanced systems concepts in managing Active Directory services, including troubleshooting AD forests, domains, and trusts, user and group administration, Group Policy management, DFS file share services, DNS/DHCP configuration, PKI infrastructure, Intune custom profiles and experience with domain migration and consolidation.
* Applies advanced systems concepts in administering and optimizing complex Windows Server environments, including experience with Windows Server 2016/2019/2022. Demonstrated advanced knowledge of security principles and practices, with experience in securing Windows servers, Active Directory, and cloud-based environments against emerging threats.

Preferred Qualifications
* Microsoft Certified: Azure Database Administrator Associate
* Experience performing network administration in complex switched and routed IP network topologies.-Experience in a veterinarian health care related system and/or knowledge of the VMTH's VMACS system.
* Knowledge of cloud-based database services (e.g., Azure SQL Database or AWS RDS). Familiarity with other database technologies such as MySQL, PostgreSQL, or Oracle. Advanced experience with database automation and DevOps tools such as Jenkins, PowerShell, or other scripting languages, including the ability to design and execute automation workflows for database administration tasks. Experience in database migration, including on-premise to cloud migrations.
* Excellent problem-solving skills and the ability to troubleshoot complex database issues. Demonstrated ability to effectively communicate technical concepts to diverse stakeholders, including senior management and cross-functional teams, while providing strategic guidance and end-user support. Familiarity with ITIL best practices in service management and knowledge of security assessment principles and compliance with industry standards such as GDPR, PCI-DSS, or HIPAA.

Key Responsibilities
* 70% - Systems and Database Administration
* 30% - Operations and Consultation

Department Overview
This position is part of the UC Davis School of Veterinary Medicine Information Technology (SVM-IT) department. SVM-IT is a matrix organization consisting of the three main functions of IT Operations, Application Development and Project Management. SVM-IT provides services to the faculty, students, staff and affiliates of both the School of Veterinary Medicine, the California Animal Health and Food Safety Lab System (CAHFS), and the Veterinary Medical Teaching Hospital (VMTH).

POSITION INFORMATION
* Salary or Pay Range: $48.99/hr. - $68.60/hr.
* Salary Frequency: Bi-Weekly
* Salary Grade: STEPS
* UC Job Title: SYS ADM 3 TX
* UC Job Code: 004699
* Number of Positions: 1
* Appointment Type: Staff: Career
* Percentage of Time: 100% Fixed
* Shift (Work Schedule): M-F 8-5
* Location: Davis, CA
* Union Representation: TX-Technical Professionals
* Benefits Eligible: Yes
* This position is hybrid (mix of on-site and remote work)

Benefits
Outstanding benefits and perks are among the many rewards of working for the University of California. UC Davis offers a full range of benefits, resources and programs to help you bring your best self to work, as well as to help you and your family achieve your health, wellness, financial and career goals. Learn more about the benefits below and eligibility rules by visiting either our handy Benefits Summary for UC Davis Health Employees or Benefits Summary for UC Davis Employees and our Benefits Page.

If you are represented by a union, benefits are negotiated between the University of California (UC) and your union and finalized in a contract. Read your bargaining unit's employment contract, stay abreast of current negotiations and learn about collective bargaining at UC: https://ucnet.universityofcalifornia.edu/labor/bargaining-units/index.html

* High quality and low-cost medical plans to choose from to fit your family's needs
* UC pays for Dental and Vision insurance premiums for you and your family
* Extensive leave benefits including Pregnancy and Parental Leave, Family & Medical Leave
* Paid Holidays annually as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
* Paid Time Off/Vacation/Sick Time as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
* Continuing Education (CE) allowance and Education Reimbursement Program as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
* Access to free professional development courses and learning opportunities for personal and professional growth
* WorkLife and Wellness programs and resources
* On-site Employee Assistance Program including access to free mental health services
* Supplemental insurance offered including additional life, short/long term disability, pet insurance and legal coverage
* Public Service Loan Forgiveness (PSFL) Qualified Employer & Student Loan Repayment Assistance Program for qualified roles
* Retirement benefit options for eligible roles including Pension and other Retirement Saving Plans. More information on our retirement benefits can be found here
* UC Davis cares about building a community, which is why we provide resources to enhance diversity, equity and inclusion as well as Employee Resource Groups (ERGs) to support our staff

Physical Demands
* Standing - Occasional Up to 3 Hours
* Walking - Occasional Up to 3 Hours
* Sitting - Frequent 3 to 6 Hours
* Lifting/Carrying 0-25 Lbs - Occasional Up to 3 Hours
* Pushing/Pulling 0-25 Lbs - Occasional Up to 3 Hours
* Bending/Stooping - Occasional Up to 3 Hours
* Squatting/Kneeling - Occasional Up to 3 Hours
* Twisting - Occasional Up to 3 Hours
* Reaching overhead - Occasional Up to 3 Hours
* Keyboard use/repetitive motion - Frequent 3 to 6 Hours

Mental Demands
* Sustained attention and concentration - Frequent 3 to 6 Hours
* Complex problem solving/reasoning - Occasional Up to 3 Hours
* Ability to organize & prioritize - Frequent 3 to 6 Hours
* Communication skills - Frequent 3 to 6 Hours
* Numerical skills - Occasional Up to 3 Hours
* Constant Interaction - Frequent 3 to 6 Hours
* Customer/Patient Contact - Frequent 3 to 6 Hours
* Multiple Concurrent Tasks - Frequent 3 to 6 Hours

Work Environment
UC Davis is a smoke and tobacco free campus effective January 1, 2014. Smoking, the use of smokeless tobacco products, and the use of unregulated nicotine products (e-cigarettes) will be strictly prohibited on any UC Davis owned or leased property, indoors and outdoors, including parking lots and residential space.

(part remotely, part onsite as appropriate). * Work with noise and heat produced by many electronic computing devices. * Work occasional overtime and various, flexible hours on short notice (including covering staff shortages, nights, weekends, and holidays). * Must be available for week and weekend rotating on-call schedule. * May require working with or around areas with sick animals, hazardous materials, and/or infectious diseases, and distraught clients.

Special Requirements - Please contact your recruiter with questions regarding which activities apply by position
* This is a critical position, as defined by UC Policy and local procedures, and as such, employment is contingent upon clearing a criminal background check(s) and may include drug screening, medical evaluation clearance and functional capacity assessment

Misconduct Disclosure Requirement: As a condition of employment, the final candidate who accepts a conditional offer of employment will be required to disclose if they have been subject to any final administrative or judicial decisions within the last seven years determining that they committed any misconduct; received notice of any allegations or are currently the subject of any administrative or disciplinary proceedings involving misconduct; have left a position after receiving notice of allegations or while under investigation in an administrative or disciplinary proceeding involving misconduct; or have filed an appeal of a finding of misconduct with a previous employer.

Diversity, Equity, Inclusion and Belonging
At UC Davis, we're solving life's most urgent challenges to bring a fuller, healthier, and more resilient world within reach. We grow from every challenge we take on and we don't just maintain - we improve. We recognize that creating an inclusive and intellectually vibrant organization means understanding and valuing both our individual differences and our common ground. The most comprehensive solutions come from the most diverse minds and you belong here. As you consider joining UC Davis, please explore our Principles of Community, our Clinical Strategic Plan and strategic vision for research and education, and our latest efforts to outgrow the expected. The University of California, Davis 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, age or protected veteran status.

For the University of California's Affirmative Action Policy, please visit: https://policy.ucop.edu/doc/4010393/PPSM-20

For the University of California's Anti-Discrimination Policy, please visit: https://policy.ucop.edu/doc/1001004/Anti-Discrimination

Because we want you to be seen, our recruiting process at UC Davis fosters authenticity, diversity, and inclusion. Studies have shown that some people may not apply to jobs unless they meet every single qualification. Each unique role at UC Davis has a set of requirements and you could be perfect for this role, or you could be perfect for the next role! Don't meet all the requirements? We still encourage you to apply! #YouBelongHere

To learn more about our background check program, please visit: https://hr.ucdavis.edu/departments/recruitment/ucd/selection/background-checks