Intermediate Database Analyst (Information Technology)

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.

Qualifications: 

Required Education:  Bachelor's degree in management of information systems (MIS) or a computer-related field, AND: 

• 36 months of Data Processing, Data Management Systems, or related experience.

Equivalency/Substitution: Will accept 48 months of related experience in lieu of the Bachelor's degree, for a total of 84 months of related experience.)

Required Skills and Proficiencies:

• Ability to analyze large datasets.
• Ability to think critically, problem-solve, and exercise professional judgment.
• Strong oral and written communication skills.
• Proficient in Microsoft Office Suite (Outlook, Word, Excel).
• Knowledge of computer languages used within databases.
• Knowledge, understanding, and experience in database design and construction.
• Detail-oriented for accuracy of data and information.
• Highly organized and able to handle multiple projects and deadlines.
• Discretion and knowledge to work with and secure confidential client data.
• Ability to transition legacy Access databases to new relational database options.

Departmental Preferences:

• Microsoft Access database development with VBA coding.
• Working independently to complete database projects from start to finish.

Supervision:  This position does not have supervisory responsibilities.

 

Special Instructions: If you are selected as a final candidate for this position, you will be subject to The University of Oklahoma Norman Campus Tuberculosis Testing policy.  To view the policy, visit https://hr.ou.edu/Policies-Handbooks/TB-Testing.

Why You Belong at the University of Oklahoma: The University of Oklahoma fosters an inclusive culture of respect and civility, belonging, and access, which are essential to our collective pursuit of excellence and our determination to change lives. The unique talents, perspectives, and experiences of our community enrich the learning, and working environment at OU, inspiring us to harness our innovation, creativity, and collaboration for the advancement of people everywhere.

Equal Employment Opportunity Statement: The University of Oklahoma, in compliance with all applicable federal and state laws and regulations, does not discriminate based on race, color, national origin, sex, sexual orientation, genetic information, gender identity, gender expression, age, religion, disability, political beliefs, or status as a veteran in any of its policies, practices, or procedures. This includes, but is not limited to, admissions, employment, financial aid, housing, services in educational programs or activities, and health care services that the University operates or provides.