What are the responsibilities and job description for the Intermediate Database Analyst position at The University of Oklahoma?
The National Resource Center for Youth Services (NRCYS) at the University of Oklahoma has improved human services’ effectiveness for over 50 years. NRCYS provides training and technical assistance to programs in Oklahoma and nationally. Specializing in training and consultation, NRCYS is a leader in youth service philosophy, best practices, and youth engagement.
Position Summary :
This position supports the selection, design, and maintenance of database solutions to meet customer needs for data and reporting.
Duties :
- Provides technical support to analyze, design, and implement software, relational databases, and systems. Assists in coding and maintaining utilities, job control language, compilers, and system software.
- Provides leadership and oversight to support and maintain database systems. Works collaboratively with other teams to resolve complex application performance issues.
- Provides software support for loading, dumping, and maintaining data in databases. Designs and performs various tests on all systems.
- Makes recommendations about the methods and ways to obtain and analyze data to improve the quality and efficiency of data systems.
- Assists systems and programming staff using data debugging tools. Assists with updates and reorganization of the databases to support user requests.
- Analyzes and assists in the performance monitoring of the database activity and identifies patterns and trends in data sets.
- Manages database security and controls access permissions.
- Manages release life cycles, including development and production environments, database installation, configuration, upgrades, and patches when necessary.
- Oversees the planning, coordination, and execution of data conversions and migrations.
- Responds to database system alerts and escalated service tickets as needed.
- Researches and evaluates new database technologies, recommends database strategy, and identifies potential solutions.
- Develops and maintains operational documentation for databases, including backup and restore procedures.
- Performs various duties as needed to successfully fulfill the function or the position.