Data Systems Administrator

ACORD Solutions Group

  • Full time
  • 3 months ago
  • Madison,WI
  • OnSite

Job Description

Details

Posted: 19-Sep-24

Location: Madison, Wisconsin

Salary: Open

Categories:

Information Technology

Internal Number: 305831-AS

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

.

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

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:

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

.

Uploading
Skip to toolbar