TITLE Database Analyst
CLASSIFICATION NUMBER 5174
IMMEDIATE SUPERVISOR Senior Database Analyst
MAJOR ADMINISTRATOR Coordinator of Management Information Systems
The Database Analyst guides the use of database technology, works with Systems Analysts and Programmer/Analysts to conduct database analysis and design, and assists in the overall implementation and maintenance of database solutions. The Database Analyst is responsible for the ongoing operation of the University’s enterprise database systems, investigates database tools and products, and provides training to Computer Services staff and campus users. The Database Analyst 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 two years of experience in database design, administration, and database application programming is required. Functional knowledge of database management systems and SQL is required. Experience with database query tools and products, Oracle, SQL/Server databases, and PL/SQL 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 manage multiple concurrent projects, reason analytically, and work with people possessing differing levels of technical knowledge is required. The ability to solve complex procedural and/or software problems by using logic, creativity, technical, and interpersonal skills is required. The ability to maintain confidentiality in regard to information processed, stored, or accessed by the systems is required. Effective verbal and written communication skills and proficiency in writing technical specifications are required. Knowledge of SungardHE’s Banner software suite or ODS/EDW is preferred. 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 support implementations or upgrades and to respond to calls regarding questions or problems with the University’s computing systems.
ESSENTIAL DUTIES AND RESPONSIBILITIES
1. Supports the efforts of Systems Analysts and Programmer/Analysts in database table design by providing guidance in logical and physical design, defining and/or updating database tables, and maintenance of the data dictionary and associated tools.
2. Promotes the uniformity of the database-related programming effort by developing methods and procedures for database programming.
3. Supports the effort to optimize the use of relational database by monitoring, planning and organizing the University’s primary databases.
4. 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.
5. 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.
6. Assists Computer Services staff in application development considerations regarding use of the database in both test and production environments by designing and creating database tables to meet application needs.
7. Ensures the integrity of data and query results by establishing, publishing, and enforcing database standards and security procedures for the university.
8. 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.
9. 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.
10. Resolves database-related programming problems by conducting a thorough analysis of the problems and employing appropriate debugging techniques and tools to resolve the problems.
11. 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.
12. 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.
13. Ensures the availability of computer resources by managing disaster prevention and recovery efforts caused by events like power outages, hardware failures, etc.
14. Contributes to a work environment that encourages knowledge of, respect for, and development of skills to engage with those of other cultures or backgrounds.
15. 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 Senior Database Analyst.
16. Contributes to the overall success of the Computer Services Department by performing other duties and responsibilities as assigned.
The Database Analyst is supervised by the Senior Database Analyst.
OFFICE OF HUMAN RESOURCES
REVISED MARCH 2013
JOB FAMILY 3
Factor 1: Educational/Experience Requirements of the Job
Level 7 - 1379 Points: A combination of education and experience equivalent to a Level 7 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 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.