Intermediate Database Analyst -
Job Number:
233296
Organization
: E-Team
Job Location
: Oklahoma-Norman-Norman Campus
Schedule
: Full-time
Work Schedule: M-F 8am - 5pm
Work Type: Hybrid
Salary Range: Targeted salary $45,600 - $60,400 based on experience
Benefits Provided: Yes
Required Attachments: Resume, Cover Letter
Job Description
The Educational Training, Evaluation, Assessment & Measurement (E-TEAM) department at The University of Oklahoma College of Continuing Education designs research and evaluations to help organizations understand and use information and data to solve real-world problems. Currently, we have an opening for a Intermediate Database Analyst within our department.
The Intermediate Database Analyst provides technical support to analyze, design, and implement software, systems, and operating system capabilities. Assists in coding and maintaining utilities, job control language, compilers and system software.
Essential Duties:
- Provides leadership and oversight for the support and maintenance of database systems. Works collaboratively with other teams to troubleshoot and resolve complex application performance issues.
- Provides software support in loading, dumping, and maintaining data on databases. Designs and performs various tests on all systems.
- Makes recommendations about the methods and ways to obtain and analyze data to improve 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 performance monitoring of database activity. Identifies patterns and trends in data sets.
- Manages database security and control access permissions.
- Manages release life cycles including development and production environments, including database installation, configuration, upgrades and patching 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, makes recommendations on database strategy, and identifies potential solutions.
- Develops and maintains operational documentation for databases including backup and restore procedures.
- Assists operations in defining and maintaining backup and recovery.
- Analyze existing SQL queries for performance improvements.
- Provides technical support to analyze, design, and implement software, systems, and operating system capabilities. Assists in coding and maintaining utilities, job control language, compilers and system software.
- Performs various duties as needed to successfully fulfill the function or the position.
Job Requirements
Required Education: Bachelor's degree, AND:
- 36 months Data Processing, Database 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.
Skills:
- Ability to analyze large datasets
- Ability to problem solve
- Ability to communicate verbally and in writing
- Proficient in Microsoft Office Suite or related software
- Knowledge of computer languages used within databases
- Knowledge and understanding of database design and construction
- Detail oriented for accuracy of data and information
- Highly organized and able to handle multiple projects and deadlines
Advertised Physical Requirements:
- Must be able to engage in repetitive motions. Manual dexterity. Ability to sit for short or extended periods of time. Standard office work environment.
Departmental Preferences:
- Proficiency in Microsoft SQL Server
- Create and manage relational databases to store and organize data efficiently.
- Excellent verbal and written communication skills
- Ability to understand front-end users’ needs and requirements.
- In-depth understanding of data management (e.g., permissions, recovery, security, and monitoring)
- Knowledge of software development and user interface web applications
- Familiarity with .NET, JavaScript, and HTML
- Excellent attention to detail
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.
Diversity Statement: The University of Oklahoma is committed to achieving a diverse, equitable, and inclusive university community by recognizing each person's unique contributions, background, and perspectives. The University of Oklahoma strives to cultivate a sense of belonging and emotional support for all, recognizing that fostering an inclusive environment for all is vital in the pursuit of academic and inclusive excellence in all aspects of our institutional mission.
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.
Hiring contingent upon a Background Check?: Yes
Special Indications: None
Job Posting
: Jan 8, 2024
Read Full Description