Database Solutions Analyst

University of Missouri-Columbia; Columbia Township (MO); On-site; USD 54,000 - 85,000; Full time

Job summary

The University of Missouri-Columbia, Division of Information Technology, Extension Technology & Computer Services (ETCS) invites applications for a Database Programmer/Analyst. You will analyze database needs across Extension and design appropriate solutions that support statewide programs and data-driven decisions.

Responsibilities include constructing database models, writing and debugging SQL stored procedures, documenting solutions for developers, and ensuring data security and integrity

Qualifications

• Knowledge of programming languages, operating systems, a text editor, report generators, database management, and remote processing concepts.
• Understanding of data modeling concepts, design techniques, DB design, testing and debugging, data integrity, and security.
• Experience with multi-use/multi-tasking programming languages (4GLs) is a plus.
• Strong communication and interpersonal skills to elicit IT information, train users, and document procedures.
• Ability to work with cross-department teams and manage projects with deadlines.

Responsibilities

• Analyze database needs across Extension groups and design data structures.
• Design database solutions using appropriate database software.
• Document database solutions for developers and end users.
• Enforce Extension data use and storage policies and standards.
• Support end users with database-related questions and needs.
• Write and debug SQL stored procedures.
• Keep supervisors informed of duties and issues.
• Support ETCS team with other duties as needed.

Skills

Programming languages

Data modeling

SQL

Communication

Team collaboration

Time management

Under pressure

Education

Bachelor's degree preferred

Job description

The University of Missouri-Columbia, Division of Information Technology, Extension Technology & Computer Services (ETCS) invites applications for a Database Programmer/Analyst. You will analyze database needs across Extension and design appropriate solutions that support statewide programs and data-driven decisions.

Responsibilities include constructing database models, writing and debugging SQL stored procedures, documenting solutions for developers, and ensuring data security and integrity