Occupational Category (Staff Positions Only): Professional
Hiring Salary: Monthly-Staff
Department: Enterprise Services
Bachelor's degree with a major in computer science or related field from an accredited institution. Ten (10) years experience in a directly related field is required. Master's degree, Banner customer support experience, and a Project Manager Professional (PMP) would be preferred.
Nature & Purpose of Position/Usual Duties:
Performs highly advanced database administration and managerial work as related to Banner Enterprise Resource Planning (ERP) applications and enterprise database administration.
Primary Responsibilities (Staff Positions Only):
Responsible for developing and implementing processes/procedures necessary to maintain the databases and related systems used within the ERP system. Manages installation, configuration, patching/updating, performance tuning, and backups of ERP databases and application servers such as Oracle DBMS and OAS. Responsible for security of the databases and related applications. Develops and documents standards and procedures for database administration staff. Work involves planning, scheduling, and assigning database projects. Mentors and trains database administrators and application programming staff. Writes and maintains specifications and security policies. Performs database and application monitoring and tuning to ensure databases run at peak performance; troubleshoots performance issues. Designs and implements procedures necessary to save and recover databases from hardware and software failures. Performs analysis for database sizing/capacity, server requirements, and space requirements. Works with the Infrastructure Services team to thoroughly implement and test enterprise backup and recovery solution including disaster recovery initiatives. Designs database physical structures to accommodate large transaction processing and high availability. Manages and oversees Banner ERP application and patch update processes. Works with latest heterogeneous server operating systems (e.g. Linux, Windows Server), server/database monitoring, enterprise relational database systems (e.g. Oracle RAC), and application servers (e.g. Oracle Application Server). Assists with SQL programming using SQL and stored procedure languages such as PL/SQL. Creates, loads, and manages databases and database objects needed by the implementation, development, testing, and training teams. Performs upgrading/patching of database and related systems. Responds to, troubleshoots, and repairs issues with databases and associated applications including Banner. Develops and implements the processes necessary to refresh or otherwise maintain sets of data for testing and development purposes and automates processes when possible. Supports data loading, migration, conversion, and scheduled job operations. Manages database-level and application-level security and roles. Provides advanced troubleshooting of development/production systems. Reviews new database programs, functions, procedures, and packages before they are loaded into production database. Performs other related duties as assigned.
Internal Number: 21072
About Sam Houston State University
For more than 130 years, Sam Houston State University has been preparing students for meaningful lives of achievement. Its motto, "The Measure of a Life is its Service", echoes across SHSU's six colleges and beyond its Texas campus through student research, creative endeavors, service learning, volunteering and more. Named for Sam Houston, Texas' greatest hero, SHSU continually strives to honor its historical roots through academic excellence that includes exceptional teaching from faculty members who care as much about their students' success as they do about furthering the knowledge of their fields. While embracing its legacy, SHSU also strives to meet the needs of contemporary students, both traditional and online. With over 20 bachelor's and graduate degrees available entirely online, and more in development each semester, SHSU Online is quickly becoming one of the best online universities in Texas.