DATABASE PROGRAMMER ANALYST - HYBRID

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

Hiring Department

Division of Information Technology

Job Description

MU Extension is an academic division consisting of approximately 1500 faculty and staff throughout the state within 22+ organizational departments throughout Cooperative Extension and Continuing Education.

Our programs bring the latest research and information to Missourians and provide unique partnerships with federal, state, and local governments.

This position is with Extension Technology & Computer Services (ETCS), a department dedicated to providing leadership in the application of information technology for Extension faculty and staff throughout the state.

The Database Programmer/Analyst is responsible for analyzing the database needs of Extension and designing the appropriate solutions.

Characteristic Duties

• Work with all groups of Extension to analyze their needs as it relates to categorizing and structuring data.
• Design database solutions for analyzed needs using the appropriate database software.
• Document database solutions to provide programmers with needed materials to implement the solutions.
• Help enforce and maintain Extension polices as they relate to appropriate use and storage of data.
• Support end users with their questions and needs as it relates to databases.
• Write/debug SQL stored procedures.
• Keep supervisors informed of duties performed and report any problems or needs.
• Other duties in support of the ETCS team.

Shift

Monday - Friday, 8am - 5pm

Minimum Qualifications

• Must live within an hour of Columbia campus.
• Working knowledge of or proven capability to quickly learn programming language(s), operating systems, a text editor, report generators, database management, direct access techniques, remote processing and virtual systems to be utilized/supported within the hiring unit.
• Knowledge of data modeling concepts and design techniques, database definitions, testing and debugging databases, generating and maintaining database management systems, and applying security concepts while designing and maintaining database structure's data integrity.
• Practical experience writing in one or more programming languages or 4th generation languages for multi-use/multi-tasking environments.
• Effective communication and interpersonal skills - sufficient to effectively elicit IT information from users, train users in technical procedures/design, and document IT related procedures.
• Ability to establish and maintain cooperative working relationships with those contacted in the course of a work assignment and to participate as a member of a cross departmental project team.
• Time management skills and organizational ability for project management.
• Ability to work under pressure; meet inflexible deadlines; deal with difficult individuals while maintaining composure.

Preferred Qualifications

Bachelor's degree is preferred

Anticipated Hiring Range

Salary Range: $53,976-$85,121 per year Commensurate with experience

Grade: GGS 011

University Title: Database Programmer Analyst.

Internal applicants can determine their University title by accessing the Talent Profile tile in myHR.

Sponsorship Information

Employment visa sponsorship is not available for this position.

Benefit Eligibility

This position is eligible for University benefits. As part of your total compensation, the University offers a comprehensive benefits package, including medical, dental and vision plans, retirement, paid time off, short- and long-term disability, paid parental leave, paid caregiver leave, and educational fee discounts for all four UM System campuses. For additional information on University benefits, please visit the Faculty & Staff Benefits website at https://www.umsystem.edu/departments-staff/human-resources/benefits-retirement

Equal Employment Opportunity

The University of Missouri is an Equal Opportunity Employer.

To request ADA accommodations, please call the Director of Accessibility and ADA at 573-884-7278.