5175 Senior Database Analyst

POSITION IDENTIFICATION

TITLE Senior Database Analyst

CLASSIFICATION NUMBER 5175

GRADE 36

CLASSIFICATION Exempt

IMMEDIATE SUPERVISOR Coordinator of Management Information Systems

MAJOR ADMINISTRATOR Chief Information Officer

GENERAL FUNCTION

The Senior Database Analyst is responsible for the strategic planning and routine maintenance of the University’s enterprise database systems, including coordinating with the West Plains Systems/Database Analyst on database issues affecting both campuses.  The Senior Database Analyst guides the Database Analysts working with Systems Analysts and Programmer/Analysts in database analysis and design and assists in the overall implementation and maintenance of database solutions.  The Senior Database Analyst assists the Coordinator of Management Information Systems in planning, personnel selection, and personnel training.  The Senior Database Analyst investigates database tools and products, provides training to Computer Services staff and campus users, establishes backup and recovery procedures, and is responsible for ensuring integrity and access control to all University data. 

MINIMUM ACCEPTABLE QUALIFICATIONS

Education: A Bachelor’s degree or the equivalent is required; a Bachelor’s degree in a computer-related field is preferred.

Experience: At least four years of experience in database design, administration, and database application programming is required.  Functional knowledge of database management systems and SQL is required.  A minimum of one year of supervisory experience is required.  A minimum of one year of project lead experience is required.  Experience with database query tools and products, Oracle, DB2 and SQL/Server databases, PL/SQL, and the use of microcomputers in business applications is required.  Oracle certification is preferred. Experience with ODBC, web development, Microsoft Excel, and Microsoft Access is preferred.  Work experience in higher education is preferred.

Skills: The ability to understand and manage complex software and database systems is required.  The ability to effectively coordinate the efforts of the database analysts, prioritize their work, and monitor their performance is required.  Effective interpersonal, customer service, organizational and team-building skills are required.  The ability to maintain confidentiality in regard to information processed, stored, or accessed by the systems is required. The ability to manage multiple concurrent projects and to reason analytically is required. The ability to work with and train people possessing differing levels of technical  knowledge is required.  Effective verbal and written communication skills and proficiency in writing technical specifications are required. The ability to develop knowledge of, respect for, and skills to engage with those of other cultures or backgrounds is required.

Other: The twenty-four hour scope of University operations requires this position to be available evenings, nights, and weekends to respond to calls regarding questions or problems with the University’s computing systems.

ESSENTIAL DUTIES AND RESPONSIBILITIES

1. Provides supervision and coordinates the efforts of other database analysts in the Computer Services department by prioritizing their work, reviewing plans, and monitoring results.

2. Coordinates efforts with the West Plains Computer Services staff on database issues affecting both campuses.

3. Provides direction and recommendations for purchases and upgrades of database technologies.

4. Ensures that the databases are backed up and can always be successfully restored.

5. Proactively monitors patch release announcements and determines the schedule for patch application.

6. Supports the efforts of database analysts and application development staff in database table design by providing guidance in logical and physical design, defining and/or updating database tables, and maintaining the data dictionary and associated tools.

7. Promotes the uniformity of the database-related programming effort by developing methods and procedures for database programming.

8. Supports the effort to optimize the use of relational database by monitoring, planning and organizing the University’s primary databases.

9. Promotes the development of Computer Services staff members and campus users by preparing and offering training and demonstrations regarding database-related design, development, and/or appropriate database querying tools. 

10. Ensures the ongoing efficient operation of the databases by developing, testing, and implementing appropriate backup and recovery procedures, conducting periodic tuning of the databases, capturing and reporting database usage statistics as appropriate, regularly monitoring space usage, and providing technical support (troubleshooting) regarding the databases as needed.

11. Provides continuity of management and support for the Management Information Systems group and end user departments by providing support for the systems of other Database Analysts during their absence.

12. Assists Computer Services staff in application development considerations regarding the efficient use of the database.

13. Ensures the integrity of data and query results by establishing, publishing, and enforcing database standards and security procedures for the University.

14. Remains current with the industry by researching available products and methodologies to determine the feasibility of alternative database management systems, hardware platforms, communication protocols, middleware, and query tools.

15. Assists the Coordinator of Management Information Systems with special projects by performing functions such as collecting relevant information, conducting appropriate research, writing reports, and providing analysis and evaluations in a variety of areas including personnel staffing and technologies.

16. Assists in the development of a competent and effective staff by supervising and monitoring the productivity and skill level of the database analyst staff, participating in performance reviews and goal setting, promoting the professional development of Database Analysts and the ODS/EDW Database Analyst, and assuming a leadership role in the MIS group’s internal training program.

17. Contributes to the development of policies and procedures by serving on appropriate committees and supporting the missions of the department and the University.

18. Establishes, maintains, and prevents private or highly sensitive information from being accessed inappropriately by controlling the access by working with data owners to determine access rights.

19. Resolves database-related programming problems by conducting a thorough analysis of the problems and employing appropriate debugging techniques and tools to resolve the problems.

20. Maximizes computer system integrity by communicating with users and Computer Services staff to determine and resolve system problems using the appropriate debugging techniques and utilizing the appropriate database vendor support channels.

21. Assists in the selection of database tools and products, making recommendations for purchase, developing bid specifications, evaluating bid responses, and recommending the selection of products that meet the database needs of the university.

22. Ensures the availability of computer resources by managing disaster prevention and recovery efforts caused by events like power outages, hardware failures, etc.

23. Contributes to a work environment that encourages knowledge of, respect for, and development of skills to engage with those of other cultures or backgrounds.

24. Remains competent and current through self directed professional reading and researching available tools and products, developing professional contacts with colleagues, attending professional development courses, and attending training and/or courses as assigned by the Coordinator of Management Information Systems.

25. Contributes to the overall success of the Computer Services Department by performing other duties and responsibilities as assigned by the Coordinator of MIS.

SUPERVISION

The Senior Database Analyst is supervised by the Coordinator of Management Information Systems and directly supervises Database Analysts and the ODS/EDW Database Analyst. 

OFFICE OF HUMAN RESOURCES

REVISED MARCH 2013

JOB FAMILY 3

Factor 1: Educational/Experience Requirements of the Job

Level 9 - 1773 Points: A combination of education and experience equivalent to a Level 9 as indicated by the Equivalencies Chart, when permitted by the Minimum Acceptable Qualifications.

Factor 2: Supervisory Responsibility

Level 5 - 1495 Points: Supervision of a work group or department including hiring, training, disciplining, and directing the work of others. At this level the required supervision will likely include general rather than close supervision of others. Typically, the nature of the work may involve the supervision of other supervisors or team or work group leaders, the responsibility for a rather large group of operative employees in non-technical or non-highly skilled areas, or supervision of moderate to large numbers of student workers who perform relatively complicated technical or skilled work. At this level, supervisory responsibilities consume significant amounts of work time and include substantial responsibility for work planning activities.

Factor 3: Skill, Complexity, and Technical Mastery

Level 7.5 - 2350 Points: Skill, complexity, and technical mastery is somewhat above the requirements for a level 2200, but somewhat below the skill, complexity, and technical mastery requirements at level 2500.

Factor 4: Budgetary Control

Level 3 - 579 Points: Jobs at this level are responsible for identifying areas of need and for developing proposals that request funding to fulfill those needs.

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 5 - 3780 Points: Work products or services directly impact the entire university system and 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 the entire University. Improperly performed work and/or equipment or software failures may be remedied in the short to medium term, but at very substantial cost of time and resources. The scope of improperly performed work and/or equipment or software failure is system-wide and the nature of the activity requires that emergency repairs be performed.