Data Systems Administrator

University of Wisconsin Madison
$110,000 ANNUAL (12 months)
paid time off
United States, Wisconsin, Madison
21 North Park Street (Show on map)
Sep 14, 2024
Job Summary: The Office of Data, Academic Planning & Institutional Research (DAPIR) is seeking a Data Systems Administrator to join our Enterprise Data Management team. The position will be instrumental in helping shape the future of UW-Madison's data landscape. Enterprise Data Management is in the process of modernizing several elements of our data platform and is looking for an experienced data professional to help us grow beyond traditional databases into new technologies and methodologies (data lake, data lakehouse, data fabric, etc.) This role will be central to helping design, build, and maintain physical and virtual database systems and related data systems (AWS S3, etc.) in a hybrid cloud and on-premises environment, and will assist with the overall UW-Madison data platform to ensure data security and integrity. The Data Systems Administrator will develop related policy and procedure, facilitate training, and serve as a subject matter expert for related project planning. This person will also play a key role in proactively monitoring activity and performance to maintain responsible financial operations in cloud environments. Responsibilities: Designs, develops, builds, and maintains one or multiple database systems and environments or assists with an entire application to ensure data security and integrity. Develops related policy and procedure, develops and facilitates training, and serves as a subject matter expert for related project planning. 10% Develops data architectures and database management policies and standards 10% Identifies and resolves data issues and upholds database-use guidelines 20% Installs, configures, maintains, backs up, restores, and performance-tunes databases 15% Implements complex security measures to safeguard digital information 10% Monitors and analyzes database audit tables and logs and provides complex data warehousing support and data extraction 5% Identifies, develops, and facilitates unit staff training opportunities in the effective utilization of databases 10% Serves as a subject matter expert on database systems and procedures for new projects and facilitates planning 10% Configures, integrates, and manages internal applications and cloud tools (AWS, Azure, etc.) for use in UW-Madison's broader data platform 10% Monitors financial operations and performance of data systems and cloud platforms (FinOps) Institutional Statement on Diversity: Diversity is a source of strength, creativity, and innovation for UW-Madison. We value the contributions of each person and respect the profound ways their identity, culture, background, experience, status, abilities, and opinion enrich the university community. We commit ourselves to the pursuit of excellence in teaching, research, outreach, and diversity as inextricably linked goals. The University of Wisconsin-Madison fulfills its public mission by creating a welcoming and inclusive community for people from every background - people who as students, faculty, and staff serve Wisconsin and the world. For more information on diversity and inclusion on campus, please visit: Diversity and Inclusion Education: Preferred Bachelor's Degree Qualifications: Required: - Minimum of 5 years of professional work experience in database administration, cloud data management, or related field - Experience with database design, security, documentation, and coding in a cloud or cloud-hybrid environment Preferred: - Experience working in higher education - Experience in implementing new data systems and platforms - Experience migrating on-premises and legacy systems into cloud services and integrating cloud services into existing infrastructure - Experience managing both cloud databases (Snowflake, Redshift, etc.) and on-premise databases (Oracle, etc.) - Experience managing logical databases or lakehouses (Denodo, Dremio, etc.) - Experience managing cloud tools related to data management (AWS S3, ADLS, MPP clusters, etc.) License/Certification: Preferred AWS - Amazon Web Services Certification AWS/Microsoft/Google Cloud certifications preferred Work Type: Full Time: 100% This position may require some work to be performed in-person, onsite, at a designated campus work location. Some work may be performed remotely, at an offsite, non-campus work location. Appointment Type, Duration: Ongoing/Renewable Salary: Minimum $110,000 ANNUAL (12 months) Depending on Qualifications This position offers a comprehensive benefits package, including generous paid time off, competitively priced insurance plans, tax-advantaged savings accounts, and participation in the nationally recognized Wisconsin Retirement System (WRS) pension fund. Learn more at https://hr.wisc.edu/benefits/. Additional Information: The successful candidate will be responsible for ensuring eligibility for employment in the United States on or before the first day of employment. University sponsorship of an employment visa is not available for this position. How to Apply: Click the 'Apply Now' button above to begin. After creating a UW Jobs profile, you will be asked to upload a cover letter and resume. Your application materials should demonstrate how your knowledge, skills, and experience align with the qualifications listed in the job posting. Contact: Kory Breuer kory.breuer@wisc.edu Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information. Official Title: Database Administrator III(IT026) Department(s): A01-GENL EDUCATIONAL ADMIN/A0124/ENTRPRISE DATA MGMNT Employment Class: Academic Staff-Renewable Job Number: 305831-AS The University of Wisconsin-Madison is an Equal Opportunity and Affirmative Action Employer. Qualified applicants will receive consideration for employment without regard to, including but not limited to, race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, disability, or status as a protected veteran and other bases as defined by federal regulations and UW System policies. We promote excellence through diversity and encourage all qualified individuals to apply. For more information regarding applicant and employee rights and to view federal and state required postings, click here If you need to request an accommodation because of a disability, you can find information about how to make a request at the following website: https://employeedisabilities.wisc.edu/disability-accommodation-information-for-applicants/ Employment may require a criminal background check. It may also require you and your references to answer questions regarding sexual violence and sexual harassment. The University of Wisconsin System will not reveal the identities of applicants who request confidentiality in writing, except that the identity of the successful candidate will be released. See Wis. Stat. sec. 19.36(7). The Annual Security and Fire Safety Report contains current campus safety and disciplinary policies, crime statistics for the previous 3 calendar years, and on-campus student housing fire safety policies and fire statistics for the previous 3 calendar years. UW-Madison will provide a paper copy upon request; please contact the University of Wisconsin Police Department.