Data Integration Specialist/Database Administrator

University of Wisconsin Green Bay - Green Bay, WI

Full-time - Mid Level

Hybrid - Green Bay, WI

Educational Services

About the position

The Data Integration Specialist/Database Administrator position at the University of Wisconsin-Green Bay is a hybrid role that reports to the Director of Enterprise Applications and Integrations. This role encompasses responsibilities in both data integration and database administration, focusing on the design, implementation, and maintenance of infrastructure and complex technical integrations across various systems, including in-house, enterprise applications, and cloud-hosted systems. The position also involves administering Microsoft SQL Server, MySQL, and Oracle database management software, ensuring that subsystems and infrastructure function cohesively to meet business needs.

Responsibilities

• 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.

Requirements

• 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).

Nice-to-haves

• 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.

Benefits

• Health insurance options with annual deductibles as low as $250/individual and $500/family.
• Dental and vision insurance.
• Life insurance options, AD&D and Accident insurance.
• Flexible Spending and Health Savings Accounts.
• Participation in the Wisconsin Retirement System (WRS) with immediate employer contributions.
• Supplemental retirement savings programs including a 403(b) and Deferred Compensation.
• Paid leave benefits including 9 legal holidays, 36 hours of personal holiday, and between 96-130 hours of sick leave annually.
• Vacation days ranging from 13-27 days each year, depending on years of service and employment type.