TITLE System Administrator
CLASSIFICATION NUMBER 1798
MAJOR ADMINISTRATOR Vice President for University Advancement
The System Administrator is responsible for administration of the production database and management of daily computer system operations for the Missouri State University Foundation and the Missouri State Alumni Association. The System Administrator assists with conversion and migration to new computer systems for the Office of Development and Alumni Relations, including software installation, configuration, testing, documentation, security, training, and maintenance. The System Administrator is the primary liaison to Computer Services, Communication Services, Financial Services and vendors regarding to the computer system.
Education: A high school diploma or the equivalent plus completion of technical training or post-secondary school courses in a computer-related field are required.
Experience: At least two years of experience in computer programming and Structured Query Language (SQL) is required. Experience with database query tools (SEQUEL) is required. A working knowledge of Microsoft Office products is required. The following are preferred: DB2; experience with RPG and CL; familiarity with AS/400 (iSeries); experience with relational database systems, COBOL; and work experience in higher education.
Skills: Proficiency in the creation of queries using SQL, SEQUEL, and QRY/400 is required. Requires strong oral and written communication skills and effective interpersonal skills. Requires the ability to work independently with minimal supervision and to follow through on projects and work assignments. Must be detail-oriented. Must be able to manage multiple concurrent projects, reason analytically and to work with people possessing different levels of technical knowledge.
Effort: Occasionally required to lift and carry objects weighing between 25-50 pounds. Requires sitting and working at a video display terminal for extended periods of time.
ESSENTIAL DUTIES AND RESPONSIBILITIES
1. Facilitates effective utilization of the Office of Development and Alumni Relations databases by maintaining data integrity; controlling access to the database; designing, developing, and maintaining a logical view of commonly used data and communicating the existence of this information to users; creating, maintaining, and distributing documentation for the utilization of the database; responding to inquiries regarding utilization of the database and providing assistance to users as needed.
2. Ensures the ongoing operation of the database by developing, testing, and implementing appropriate backup and recovery procedures, maintaining hardware and software inventories, and providing applications support as needed.
3. Ensures the integrity of modifications to the system by assisting in the installation of application software, configuration, testing, and performing all application system tuning.
4. Assures coordination of daily system operations by printing production reports as requested, ordering and maintaining an inventory of computer forms, scheduling daily jobs, providing ad hoc reporting as needed, performing general maintenance of printers, troubleshooting, and creating daily backups.
5. Ensures the operational integrity of the system by serving as the department's liaison with vendors on all application system issues, coordinating the installation of new software, coordinating the purchase and development of all custom interfaces, installing and documenting all system customizations, assisting Computer Services with maintenance of interfaces to external systems, implementing and administering application and database security, and updating user accounts as requested.
6. Enhances usefulness of the database to users by coordinating and conducting database and applications training for staff and determining staff training needs.
7. Ensures system viability by identifying the information needs of the Office of Development and Alumni Relations, including Alumni Relations, Annual Funds, Athletics Development, Development, Donor Relations, Planned Giving, and University Advancement, researching available products, methodologies, and query tools, contacting other educational institutions and Computer Services for approaches to resolving information needs, assisting in the selection of products for hardware and software purchase by developing bid specifications, evaluating bid responses and recommending the selection of products that meet user needs and system compatibility requirements.
8. Facilitates coordination of effective support of the Office of Development and Alumni Relations computer system by developing and maintaining a cooperative working relationship with Computer Services, Communication Services, Financial Services and other resources.
9. Remains competent and current through self-directed reading of professional journals, developing professional contacts with colleagues, attending professional development courses, and attending training and/or courses as directed by the Director of Advancement Services.
10. Safeguards the confidentiality of information and projects undertaken by the Office of Development and Alumni Relations by exercising discretion in communicating information to faculty, staff, students and the public and in handling administrative records and files.
11. Contributes to the overall success of the Office of Development and Alumni Relations by performing all other essential duties as assigned.
The System Administrator is supervised by the Director of Advancement Services.
JOB FAMILY 3
Factor 1: Educational/Experience Requirements of the Job
Level 4 - 788 Points: A combination of education and experience equivalent to a Level 4 as indicated by the Equivalencies Chart, when permitted by the Minimum Acceptable Qualifications.
Factor 2: Supervisory Responsibility
Level 1 - 299 Points: Little or no supervisory responsibility for the work of others.
Factor 3: Skill, Complexity, and Technical Mastery
Level 4 - 1300 Points: Knowledge of information technology such as could be acquired through experience or classroom-based course work in either vendor-focused or technology specific training such as Oracle, HTML, Java, or Extensible Markup Language. Knowledge permits the employee to carry out routine assignments and to gain familiarity with operating systems, equipment, software, and business goals of the University. Alternatively, knowledge of established processes, methods, and techniques, as well as practical knowledge of a few specific technical and scientific principles. Alternatively, advanced knowledge of a skilled trade to solve unusually complex problems. Knowledge permits the employee to schedule and carry out the steps of a limited operation or project to complete important stages in a multi-step project.
Factor 4: Budgetary Control
Level 2 - 386 Points: Individuals in jobs at this level actively document, monitor, and control expenditures. At this level incumbents may recommend minor expenditures but have no real authority over budgets.
Factor 5: Work Environment and Physical Demands
Level 1 - 25 Points: The work environment has only everyday discomforts associated with an office or commercial vehicle. The work area is adequately lighted, heated or cooled, and ventilated. Work is largely sedentary involving mostly sitting with occasional walking, standing, bending, or carrying of small items. No special physical demands are required of the work.
Factor 6: Work Impact and Effect
Level 3 - 2340 Points: Work products or services directly impact the operation, accuracy, reliability, acceptability, or design of programs, systems, or equipment, that affect the operation of individual departments or units. The work activity may be complex, but normally involves addressing conventional problems or situations with established methods that allow departments, programs, or units to function properly. Improperly performed work and/or equipment or software failures likely produce significant errors and/or create delays that directly affect the ability of a department, program, or unit to function properly, and the welfare of faculty, students, or others that use the services and/or products of the department, program, or unit. While the scope of improperly performed work and/or equipment or software failure is limited, the nature of the activity may require that emergency repairs be performed.