5174 Database Analyst

POSITION IDENTIFICATION

TITLE Database Analyst

CLASSIFICATION NUMBER 5174

GRADE 35

CLASSIFICATION Exempt

IMMEDIATE SUPERVISOR Senior Database Analyst

GENERAL FUNCTION

The Database Analyst guides the use of database technology, works with various units within Information Services and the campus community to ensure the continuing operation of the University’s database systems and enterprise resource planning (ERP) software.  This position is responsible for maintaining, securing, and upgrading these core University systems. The Database Analyst acts as a subject matter expert for database and ERP products and provides training to Information Services staff and campus users. This position focuses heavily on security, scalability, and performance tuning of University systems.

MINIMUM ACCEPTABLE QUALIFICATIONS

Education: A Bachelor’s degree is required. An equivalent combination of years of experience and education may be considered for substitution of educational requirements.

Experience: Two years of information technology experience with demonstrated expertise in database administration and management, web server administration and management, Linux server proficiency, and troubleshooting complex systems is required. Knowledge of Ellucian’s Banner software suite is preferred.

Skills:  Must be able to perform the duties of an Oracle and MS SQL Server Database Administrator. The ability to apply creativity and logic towards troubleshooting complex issues. Ability to manage multiple concurrent and competing projects and priorities. Possesses excellent verbal and written communication skills. Familiarity with technical writing. The ability to maintain confidentiality regarding information processed, stored, and accessed. Develop knowledge and respect for those of other cultures and backgrounds.  Proficiency with SQL, PL/SQL, Python, Ansible, and Terraform languages.  Proficiency with command line (Bash, PowerShell) interfaces and scripting. Familiarity with automated dev-ops pipelines and Docker containerization is preferred. 

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. Ensures all Installs, upgrades, and support of Apache Tomcat web applications running in containers.

2. Manages the orchestration of Kubernetes pods in a cloud environment.

3. Improves the operational efficiency of Oracle databases by continuously monitoring and analyzing performance metrics. Implements automation where appropriate.

4. Applies security patches to Oracle databases on a quarterly basis and as needed.

5. Utilizes security best practices for Oracle databases to prevent unauthorized access and enforce uniformity standards.

6. Ensures availability of Oracle databases by developing, testing, and implementing backup and recovery policies.

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

8. Remains competent and current through self-directed professional learning opportunities, develops professional contacts with colleagues, attends professional development courses, and other learning as assigned by the Senior Database Analyst.

9. Contributes to the overall success of the university by performing other duties and responsibilities as assigned.

SUPERVISION

The Database Analyst is supervised by the Senior Database Analyst.

OFFICE OF HUMAN RESOURCES

REVISED AUGUST 2023

JOB FAMILY 3

Factor 1: Educational/Experience Requirements of the Job

Level 7.0 - 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.0 - 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.0 - 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.0 - 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.0 - 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.