Data Systems Manager

Overview

This position is responsible for the development and administration of University application services across five functional areas (i.e., Financial Aid, Finance, Human Resources, Student Services, and Accounts Receivable) at each of MSU’s four campuses.

The full‑time Data Systems Manager I reports to the Lead Database Administrator. The position plans and implements application system administration and development activities according to changing University needs and system requirements. This individual uses innovative approaches and advanced technologies to ensure the performance, security, cost‑effectiveness, and accessibility of administrative system functions and related operations. This position will serve as the lead application administrator for the Banner ERP software.

• Implements and maintains application architecture for Ellucian Banner enterprise framework and other applications as time permits.
• Administer application security including using supported tools to monitor and tune the environments.
• Obtain patches and upgrades for existing application server management systems.
• Maintain currency with application‑specific knowledge.
• Stage, test, and install patches and upgrades.
• Investigate, troubleshoot, diagnose, and report application problems/defects utilizing product‑specific technical support as needed.
• Coordinate closely with Business Analysts and other key stakeholders.

• Define goals and objectives for database or web server administration requirements.
• Gather technical requirements to meet business needs.
• Formulate system concepts to fulfill requirements.
• Plan technical tasks associated with the administration and maintenance of systems and services.
• Develop and maintain status of task lists.
• Monitor, analyze, and evaluate work progress and report status to management or project owners.

• Provide support for web applications system administration.
• Install, upgrade, and patch systems including managing security and assuring adequate capacity.
• Monitor performance for Administrative Systems Web Application servers and enterprise ancillary systems (e.g., Banner, Banner self‑service, Degree Works, Tomcat, etc.).
• Maintain and apply local modifications for web applications and underlying database packages.
• Troubleshoot problems and seek appropriate support to assist in problem resolution.

• Follow information security best practices and abide by University security policies and the guidance of the Enterprise Security Group.
• Assist DBA team in managing database risk by preserving enterprise data and protecting the operational integrity and security of these high‑value database systems.
• Positively communicate and encourage security best practices throughout campus.

• A bachelor’s degree in computer science, business administration, or a related field plus progressively responsible experience in information systems management, or an equivalent combination of education and experience.
• Experience with operating systems and scripting languages (e.g., Linux, Windows, Shells and scripting, SQL, PL/SQL, etc.).
• Knowledge of web application server architectures and components such as Oracle Web Logic, Tomcat, JBoss, Apache, and IIS.
• Knowledge of appropriate procedures, protocols, and tools for staging, testing, and maintaining production environments.
• Skilled in writing, executing, and managing scripting commonly used to install, configure, and diagnose web application and application server environments.

• Experience applying upgrades and patches to Ellucian’s Banner administrative system.
• Experience administering Tomcat Application Server and Ellucian software tools.
• Knowledge of Banner and Degree Works infrastructure and business processes.
• Experience working with Windows, Linux, C, Oracle, SQL, PL/SQL, Oracle Server Management tools, Oracle SQL
  * Net.

• Anticipate and resolve technical problems.
• Troubleshoot…