University of Wisconsin - Madison

Position Vacancy Listing

PVL # 99924

Position Summary:
The Wisconsin State Laboratory of Hygiene (WSLH) with 350 staff, six divisions and a budget in excess of $40,000,000 serves as the public, environmental, and occupational health laboratory for the State of Wisconsin. WSLH is a public sector entity, attached to the University of Wisconsin, but with separate statutory authority. Its administrative and clinical laboratory functions are located in the heart of the UW-Madison campus; and its environmental and occupational health and information management functions located on the far east side of Madison.

Wisconsin State Statutes direct the WSLH to provide analytical support as well as teaching facilities and a full range of laboratory services to the Department of Health and Family Services, the Department of Natural Resources, as well as county emergency management, EMS/HAZMAT, local water utilities, waste treatment plants, licensed physicians, veterinarians, local health officers, resource management officials, coroners, and local law enforcement officials. The WSLH has been designated a Bioterrorism Level 3 (highest) laboratory, a Level 1 (highest) Chemical Terrorism response laboratory (one of only 10 in the United States), and is serving as a one of only two laboratories in the nation (the other is the CDC) to provide advanced virological testing services. The WSLH is directly linked to over a dozen federal agencies from the Office of Homeland Security to the Centers for Disease Control and Prevention to the Environmental Protection Agency and the Occupational Health and Safety Administration. Staff of the WSLH are trained to participate in the use of the Incident Command System and must be prepared to implement a continuity of operations plan.

We are seeking an experienced database administrator to join our Office of Information Systems Operations team.
This position is responsible for working with a team to ensure optimum performance, integrity, and availability of enterprise and departmental databases and their related infrastructure components, and for providing expert database services, and systems support to the staff in the various labs. The enterprise databases are used by applications systems that support every testing process and staff member in the laboratory system; the decisions and quality-of-work of the Database Administrators (DBA) therefore have significant and immediate impact on the entire enterprise.

This position is responsible for administration, database management, system software, and application support.
Hours will be primarily M-F 7:45 a.m. to 4:30 p.m. Occasional evening and weekend work is required.

Principal duties:
Overall responsibilities include, but may not be limited to:

45% Manage databases
1. Administer databases and database management technology.
2. Monitor current enterprise database space and system needs and plan for future requirements.
3. Design and implement data management objects, such as databases, redo logs, and rollback segments.
4. Establish standards, and procedures for securing, gaining access to and using database server software.
5. Perform sophisticated performance measurement and tuning of database management systems.
6. Perform sophisticated debugging, problem analysis, and problem resolution of database management systems.
7. Design, implement, and execute database backup and recovery procedures to ensure that data can be restored.
8. Acquire, install, test, and implement new releases and upgrades of database server software. Work with application users to minimize disruption caused by the installations.
9. Approve, acquire, and implement database management tools, such as tools for performance monitoring and tuning.
10. Identify and diagnose existing and potential problems with database server technology, and take the appropriate corrective action.

25% Database Support, Consulting and Training.
1. Run SQL supplied by vendors or development team to update data and database objects.
2. Provide advanced technical expertise and consulting on the effective use of database management software and other server-related software.
3. Consult with staff that are developing, implementing, and/or modifying application systems. Ensure that the application systems are taking the best advantage of database management software and other server-related software.

20% Enterprise System Administration and Technical Support
1. Identify and diagnose existing problems with the technology infrastructure for enterprise application systems, and take the appropriate corrective action. If necessary, report problems to the vendor and work with them to achieve resolution.
2. Identify potential problems with the technology infrastructure for enterprise application systems, and take the appropriate preventive action. Apply patches, fixes, adjust system parameters, and so on.
3. Study new releases and upgrades of vendor supplied enterprise application systems. Document their applicability for, and impact on, the lab's systems.
4. Plan and execute the installation, testing, and moving-to-production of new releases and upgrades of enterprise application systems. Work with users and owners of applications to minimize disruption caused by the installations.
5. Manage the technology environments and architecture of enterprise application systems. Perform capacity planning, availability planning, performance monitoring and tuning, and so on.
6. Configure, deploy and administer enterprise application servers.

5% Professional Development
1. Through classes, conferences, and reading, keep abreast of hardware and software advances in the industry, and of forecasts for the development of future technologies.
2. Through classes, conferences, and reading, keep abreast of the latest developments in database' and computing technology in general.
3. Participate in user groups, working groups, and information exchanges to share and expand knowledge of computing tools and technologies.

5% Other Duties as assigned

© 2019 Board of Regents of the University of Wisconsin System