IT Programmer

Arkansas State University-Mountain Home is seeking a knowledgeable and service-oriented SQL Programmer with Server Administration experience to support the institution's enterprise information systems, data reporting, and technology infrastructure. This position is responsible for developing and maintaining SQL queries, stored procedures, and reports that support institutional operations, regulatory reporting, and strategic decision-making.

In addition to database programming responsibilities, this position assists with the administration, maintenance, security, and performance of Microsoft server environments to ensure the reliability and availability of institutional applications.

Duties & Responsibilities:

1. Develop and maintain SQL queries, stored procedures, and scripts for data extraction and reporting.

2. Collaborate with functional teams to understand business requirements and translate them into technical specifications.

3. Monitor and troubleshoot data-related issues, ensuring timely resolution.

4. Design Argos processes for state and federal reports to allow the individual departments to maintain for the future.

5. Create and maintain comprehensive documentation of SQL code, processes, and procedures.

6. Provide training and support to end-users and staff on Banner database functionalities and tools.

7. Conduct data analysis and provide insights to support decision-making across the organization.

8. Support Microsoft Servers to ensure performance and security of the institution's applications.

9. Monitor the server health and performance and ensure uptime and availability.

10. Apply security patches and updates to the Microsoft servers.

11. Assist faculty, staff, and students with help-desk items as needed to support the Computer Services Department.

Proven experience as an SQL programmer with a preferred focus on Banner ERP. Proficiency in SQL and PL/SQL Programming and database management systems. Strong analytical and problem-solving skills with attention to details. Basic knowledge of server administration, including experience with Windows as well as understanding of cloud database solutions such as AWS and Azure. Excellent communications skills, with the ability to work collaboratively in a team environment. Preferred skills: experience with data visualization tools is a plus. Understanding of higher education business processes and data governance., Bachelor's degree in Computer Science, Information Technology, or a related field preferred/ or equivalent experience in SQL programming.

Preferred qualifications include the basic minimum qualification plus experience in Banner Student Information Systems and Argos reporting. Familiar with other database systems (e.g., Oracle, MySQL)