IS Data Services Specialist
There is an IS Data Services Specialist opportunity available in Instructional, Communication and Information Technology (iCIT). The work schedule for this full-time, year-round position is Monday through Friday, 7:45 a.m. – 4:30 p.m. The position description is available below.
To be considered for this position, you will need to create an account in Wisc.Jobs and apply online. For instructions go to http://wisc.jobs/public/index.asp and reference Job Announcement Code 1302207.
You will be required to upload a current resume and complete a 3 question Training and Experience. THIS IS YOUR EXAMINATION, and will be used to determine your eligibility for this vacancy. Resumes may not be substituted for item responses.
If you have questions regarding this recruitment, or if you are not able to complete the application or examination online due to a disability or system problem, please contact Stephanie Hartmann at 262-472-1397 or firstname.lastname@example.org Questions regarding the WiscJobs system or the online examination can be directed to email@example.com or 608-267-1012.
This position will remain open until filled. Application materials will be evaluated and the most qualified applicants will be invited to participate in the next step of the selection process. Incomplete application materials will not receive consideration.
Cert #: 4239
Instructional, Communication and Information Technology (iCIT)
This position is responsible for administration of highly complex database management system (DBMS) software, databases, and technology stack components for campus wide enterprise systems.
Primary duties include: Designing, implementing, and supporting database servers; administering databases and database management technology; designing, implementing and supporting database system infrastructure; establishing policies and procedures for gaining access to and using database system software; and consulting with various iCIT and campus wide areas on database system technology.
40% A. Database Administration and Technical Support
A1. Administer databases and database management technology.
A2. Design, and implement data structures consistent with logical data models.
A3. Design and implement data management objects, such as databases, redo logs, and rollback segments.
A4. Establish policies, standards, and procedures for securing, gaining access to and using database server software.
A5. Perform sophisticated performance measurement and tuning of database management systems.
A6. Perform sophisticated debugging, problem analysis, and problem resolution of database management systems.
A7. Act as liaison between iCIT and database software vendors to document and resolve problems.
A8. Design, implement, and execute database backup and recovery procedures to ensure that data can be restored.
A9. Study new releases and upgrades of database server software for their applicability for the campus wide enterprise systems.
A10. Acquire, install, test, and implement new releases and upgrades of database server software. Work with application users to minimize disruption caused by the installations.
A11. Acquire, and implement database management tools, such as tools for performance monitoring and tuning.
A12. Identify and diagnose existing and potential problems with database server technology, and take the appropriate corrective action.
30% B. Enterprise System Administration and Technical Support
B1. 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.
B2. 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.
B3. Study new releases and upgrades of vendor supplied enterprise application systems. Document their applicability for, and impact on, the University's systems.
B4. 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.
B5. Manage the technology environments and architecture of enterprise application systems. Perform capacity planning, availability planning, performance monitoring and tuning, and so on.
15% C. Enterprise System Project Management
C1. Assist in providing organization-wide leadership in establishing the technical direction for the technology infrastructure for enterprise systems in the University's computing architecture.
C2. Recommend policies and standards to ensure database security and integrity.
C3. Recommend standards, guidelines, methods, and techniques for gaining access to enterprise system database servers.
C4. Recommend the selection, acquisition, and deployment of specific technology, (e.g., database management systems, database monitoring and tuning tools, database gateways, application servers) for the technology infrastructure for enterprise systems.
C5. Negotiate agreements with customers and suppliers of products and services related to enterprise system servers, including technical specifications, cost estimates, and schedules.
C6. Independently manage projects related to the technology infrastructure for enterprise systems.
C7. Provide periodic project status reports to customers, suppliers, and management.
C8. Provide short- and long-range planning input for topics related to the technology infrastructure for enterprise systems.
10% D. Consulting and Training
D1. Provide advanced technical expertise and consulting on the effective use of database management software and other server-related software.
D2. Provide technical support backup to other AIS staff.
D3. 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.
5% E. Professional Development
E1. Through classes, conferences, and reading, keep abreast of hardware and software advances in the industry, and of forecasts for the development of future technologies.
E2. Through classes, conferences, and reading, keep abreast of the latest developments in database and computing technology in general.
E3. Participate in user groups, working groups, and information exchanges to share and expand knowledge of computing tools and technologies.
Knowledge and Skills
1. Knowledge of team-building concepts and techniques.
2. Knowledge of computer applications and systems programming principles, techniques, and capabilities.
3. Knowledge of the Microsoft SQL Server database management system internals, commands, and structures.
4. Knowledge of the Oracle database management system internals, commands, and structures.
5. Knowledge of Enterprise Resource Planning (ERP) systems technology stack internals, commands, and structures.
6. Knowledge of enterprise online learning systems technology stack internals, commands, and structures.
7. Knowledge of application development tools and languages.
8. Ability to install and maintain database management systems.
9. Ability to diagnose and solve highly complex problems with database management systems.
10. Knowledge of database management system monitoring techniques and tools, and database tuning techniques and tools.
11. Knowledge of computing environments and operating systems (for example, UNIX).
12. Knowledge of network computing environments.
13. Knowledge of project management principles.
14. Ability to develop project schedules, including such things as deliverables, tasks, time estimates, and critical path.
15. Knowledge of computer trends and developments.
16. Knowledge of effective written and oral communication skills.
17. Strong interpersonal skills.
18. Knowledge of systems analysis and design techniques.