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
