Data Integration Specialist/Database Administrator

Position Information

WORKING TITLE: Data Integration Specialist/Database Administrator
UW SYSTEM OFFICIAL TITLE: Technical Integration Engineer II
POSTING DATE: November 27, 2024

Essential Job Functions

This position reports to the Director of Enterprise Applications and Integrations and functions in a hybrid role as a Data Integration Specialist and a Database Administrator, serving as a member of the Enterprise Applications and Integrations team. 

The data integration component of this position is responsible for the design, implementation and maintenance of infrastructure and complex technical integrations across multiple systems, including in-house, enterprise application and cloud-hosted systems. This position provides day-to-day maintenance and long-term assistance to ensure subsystems and infrastructure function together and business needs are met.

The database component of this position is responsible for the administration of Microsoft SQL Server database management software, MySQL software, Oracle software, database connectivity software, and other related software on database servers running Windows operating systems. This position will work closely with the Office of Institutional Strategy and Effectiveness to assist in making data more available and connected for reporting and strategic planning for the University.

What You'll Do

• Integrates, identifies, troubleshoots, monitors, and resolves complex, routine, and varied supported services, systems, network, and application problems according to established processes and procedures.
• Serves as a point of contact for internal and external stakeholders, identifies needs, provides solution options, and communicates issue updates and resolutions.
• Participates in the evaluation of new vendor software releases and impact. Documents and communicates system enhancements or changes.
• Assists with the planning and coordination of system resources, upgrades, security, implementations, and integrations.
• Configures, maintains, upgrades, develops, and tests IT systems and services in alignment with industry best practices.
• Runs, maintains, and operates technical systems and infrastructure.
• Plans and directs staff implementation of technical projects as needed.
• Administer Microsoft SQL Server and MySQL database management system software, including the acquisition, installation, and implementation of releases and upgrades.
• Design data models and create databases for Microsoft SQL Server and MySQL.
• Administer and create Microsoft SQL Server and MySQL databases for enterprise applications such as Mercury, ImageNow and Ungerboeck USI. Provide support for upgrades as needed.
• Design, implement, and execute database backup and recovery procedures. Evaluate backup and recovery scenarios to choose the appropriate strategy to meet availability agreements.
• Perform debugging, problem analysis, and problem resolution of database management systems. 
• Perform performance and tuning of database management systems. Design and create indexes to produce more efficient paths and faster execution of SQL statements.
• Recommend standards, policies and guidelines to ensure database access, database security and data integrity.

Qualifications

MINIMUM QUALIFICATIONS:

• Bachelor's degree in Computer Science or related field or equivalent experience
• Knowledge of database integration tools (e.g., Informatica)
• Knowledge of SQL and relational databases (e.g., Microsoft SQL Server)
• Knowledge of system reporting tools (e.g., SQL Developer, Tableau, Peoplesoft Query)

PREFERRED QUALIFICATIONS:

• Experience in a higher education environment
• Experience loading data into large enterprise applications (e.g., Salesforce)
• Skill using troubleshooting and problem-solving techniques
• Ability to learn new technical skills and concepts quickly with minimal training and a high level of self-motivation and attention to details
• Ability to work independently as well as contribute and collaborate as part of a team
• Experience supporting, maintaining and monitoring complex database systems such as Microsoft SQL Server, MySQL or Oracle
• Experience managing and optimizing databases in AWS 

The Successful Candidate

The successful candidate will be expected to work inclusively and respectfully within a diverse campus community and practice civility in the workplace. The University welcomes applicants who are dedicated to the appreciation and promotion of inclusivity and equity as crucial components in the pursuit of organizational excellence.

In addition, the successful candidate will have strong oral, written, interpersonal, and organizational skills, demonstrated integrity and strong leadership, and the willingness to work independently and as part of a collaborative team. The University invites applicants who are dedicated to enriching the quality of life for students and the community by embracing the educational value of diversity, promoting environmental sustainability, encouraging engaged citizenship, and serving as an intellectual, cultural, and economic resource.

Conditions of Appointment

Position is a full-time Academic Staff appointment. The standard schedule for this position is 7:45 a.m. - 4:30 p.m., Monday through Friday. This position may have the option to work on-campus or a hybrid schedule, subject to approved telecommuting request. Official transcripts of the highest degree achieved will be required of finalist(s). A criminal conviction investigation will be conducted on the finalist(s). In compliance with the Wisconsin Fair Employment Act, the University does not discriminate on the basis of arrest or conviction record.

All final candidates will be asked to provide names, email contact information, and/or phone numbers for three (3) references, with at least one being from a manager or supervisor, during the interview process. All final candidates must be asked, prior to hire, whether they have been found to have engaged in, are currently under investigation for, or left employment during an active investigation in which they were accused of sexual violence or sexual harassment. When obtaining employment reference checks, these same sexual violence or sexual harassment questions must also be asked.

The University of Wisconsin-Green Bay does not offer H-1B or other work authorization visa sponsorship for this position. Candidates must be legally authorized to work in the United States at the time of hire and maintain work authorization throughout the employment term. If you have questions regarding this, please contact Human Resources.

Compensation and Benefits

SALARY INFORMATION

Minimum salary of $80,000.

This position is exempt from the overtime provisions of the Fair Labor Standards Act (FLSA).

BENEFIT DETAILS

The UW System provides an excellent benefits package to meet the diverse needs of its employees. This includes several health insurance options, with annual deductibles as low as $250/individual and $500/family. Our benefits package also includes dental, vision, several life insurance options, AD&D and Accident insurance and Flexible Spending and Health Savings Accounts. We participate in the Wisconsin Retirement System (WRS), where employer contributions begin immediately and employees are fully vested after 5 years of service. The UW System also provides supplemental retirement savings programs including a 403(b) and Deferred Compensation.

In addition, employees receive several types of paid leave benefits, which are prorated for employees working less than 100%. This includes 9 legal holidays, 36 hours of personal holiday and between 96-130 hours of sick leave annually. Employees earn 13-27 days of vacation each year, depending on years of service and employment type.

For more details, please review the benefit quick guide linked below.

• UW System Employee Benefits Brochure
• Faculty, Academic Staff, and Limited Quick Guide
• Total Compensation Estimator

Apply

STEP 1: Please select the applicable link below:
External Applicants: (NOT currently employed by the University of Wisconsin System)
Internal Applicants: (Currently employed by the University of Wisconsin System)

STEP 2: From "Search Jobs" screen:

• Click "View All Jobs"
• Select "Data Integration Specialist/Database Administrator"
  • You must login before you can apply. Input your "User Name" and "Password" and select "Sign In."
  • If you have not yet registered, click "Register Now" to begin the registration process.

STEP 3: Submit application materials:

Please be sure to complete all required fields, and include all required documents before submitting your application. Once submitted, you will not be able to edit or attach any application materials. Files must be complete to be considered. Please include the following documents:

• Cover letter
• Resume

You must select "Submit" to forward your application materials to the search committee.

If you have any questions, need accommodations, or submitted your application with missing materials, call or email:

Arianna Hilbert
Phone: (920) 465-2985
Email: hilberta@uwgb.edu

Application Deadline

To ensure consideration, please submit application materials by Sunday, December 8, 2024.