POSITION IDENTIFICATION
TITLE Database Analyst
CLASSIFICATION NUMBER 5174
GRADE 35
CLASSIFICATION Exempt
IMMEDIATE SUPERVISOR Senior Database Analyst
MAJOR ADMINISTRATOR Coordinator of Operations and Systems
GENERAL FUNCTION
The Database Analyst guides the use of database technology, works with various units within Information Services and the campus community 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 Ellucian’s Banner software suite 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 the campus community 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 and supports the Enterprise Systems team for server requests and troubleshooting.
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.
SUPERVISION
The Database Analyst is supervised by the Senior Database Analyst.
OFFICE OF HUMAN RESOURCES
REVISED SEPTEMBER 2018
