TITLE Systems/Database Analyst - West Plains
CLASSIFICATION NUMBER 5185
The Systems/Database Analyst manages the ongoing operation of the administrative databases and the servers on which they reside; maintains data access and security; participates in the analysis, design, development, and documentation of information systems that integrate with the administrative software systems; and provides ongoing support to users through database and software maintenance, troubleshooting, and training.
MINIMUM ACCEPTABLE QUALIFICATIONS
Education:Completion of college courses that are equivalent to an associate degree with an emphasis on technology-related courses is required. The following are preferred: bachelor’s degree with an emphasis in a computer-related field; Oracle DBA certification; Microsoft MCDBA certification; MCSA certification.
Experience:At least two years of experience in relational database design, administration, and database application programming is required. Functional knowledge of database management systems and SQL is required. Experience in the use of computers in business applications is required. The following are preferred: Experience with Oracle and SQL/Server databases; database query tools and products; web development; COBOL; work experience in higher education.
Skills: Ability to manage multiple concurrent projects, reason analytically, and work with people possessing differing levels of technical knowledge is required. Effective oral and written communication skills and proficiency in writing technical specifications are required.
Other: Some evening, night, and weekend hours are required.
ESSENTIAL DUTIES AND RESPONSIBILITIES
1. Assures the availability of data resources by developing, testing, and implementing appropriate backup and recovery procedures, conducting periodic tuning of the databases, regularly monitoring space usage and allocating disk space for the databases, serving as a liaison with the technical support staff of software vendors, and providing technical support regarding the databases.
2. Keeps the administrative software systems and databases up-to-date by obtaining and installing patches, updates, and version upgrades, assisting web personnel in maintaining the web-based administrative software systems, and coordinating maintenance to cause as little interference with system operation as possible.
3. Resolves database-related problems by conducting a thorough analysis of the problem and employing appropriate troubleshooting techniques and aids to resolve the problem.
4. Supervises and participates in the maintenance of the servers upon which the administrative software systems operate, ensuring the operating systems are patched and secure.
5. Manages security of Missouri State University-West Plains data by creating and maintaining database security classes, administering user IDs and passwords for administrative software systems, coordinating with other Computer Services staff in resolving problems or questions regarding administrative software systems user IDs, and providing security access reports.
6. Participates in the automation of business processes or interfaces between information systems by analyzing, designing, developing, implementing, and documenting new processes and systems.
7. Develops instructions for programmer/analysts by creating detailed design specifications including system narratives, file layouts, screen layouts, report layouts, and program narratives.
8. Performs programming duties and responsibilities for projects when needed.
9. Facilitates faculty and staff utilization of the West Plains campus database and associated tools by understanding the functions of the user departments, analyzing current processing and procedures, and advising them on appropriate alternatives in meeting their computing needs.
10. Provides support for information needs by coordinating with software support specialists in designing, developing, and maintaining views and reports for the user community; creating and distributing documentation for utilization of the database; responding to inquiries regarding utilization of the database, and providing advice and assistance as appropriate.
11. Assists in the selection of database tools and products by researching available products and methodologies, making recommendations for purchase, developing bid specifications, evaluating bid responses, and recommending the selection of products that meet the database needs of the University.
12. Actively participates in planning for the future growth of the campus and the integration of information technology by serving on appropriate committees on the West Plains campus, participating regularly in departmental meetings, coordinating problem resolution with others in the department, suggesting improvements in the support operation, assisting in the development of short- and long-range goals for the department, and evaluating progress toward accomplishment of those goals.
13. Remains competent and current through self-directed professional reading, developing professional contacts with colleagues, attending professional development courses, and attending training and/or courses required by the Director of Computer Services.
14. Contributes to the overall success of Computer Services by performing all other duties as assigned by the Director of Computer Services, WP.
The Systems/Database Analyst is supervised by the Director of Computer Services, WP.
JOB FAMILY 3
Factor 1: Educational/Experience Requirements of the Job
Level 6 - 1182 Points: A combination of education and experience equivalent to a Level 6 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 6.5 - 2050 Points: Skill, complexity, and technical mastery is somewhat above requirements for a level at 1900, but somewhat below the skill, complexity, and technical mastery requirements at level 2200.
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 4 - 3060 Points: Work products or services directly impact the work of other professionals, the development and operation of programs, affect major activities across units, and/or impact the well-being of large numbers of individuals. Typically the work is complex and may involve addressing conventional problems or situations with established methods or resolving critical problems or developing new processes or models to address specific problems. Improperly performed work and/or equipment or software failures produce errors and delays that affect the operations and/or reputations of multiple or critical departments, programs, or units, and individuals. Improperly performed work and/or equipment or software failures may be remedied in the short to medium term, but at substantial cost of time and resources. The scope of improperly performed work and/or equipment or software failure is large and the nature of the activity requires that emergency repairs be performed.