App Security Adminstr, Sr
Serves as a member of the Enterprise Application Services team (EAS) collectively responsible for the development, maintenance, and ongoing support of the College's core enterprise application systems and other custom and third-party applications. This position will maintain application and user security for college enterprise systems. This position also oversees security related to programming code and modules for college production-level systems.
1. Creates procedures for security access reviews and manages security user system, access rights, account creations and modifications for all levels of Ellucian Banner, Oracle and related system.
2. Creates and manages programming specifications for Security Auditing Reports that can be run by OIT and end user staff.
3. Writes and utilizes advanced database queries to monitor system access and data changes for Oracle and related systems.
4. Designs security audits to discover system risks/vulnerabilities, documents audit results and makes recommendations for security improvements in the areas of application development and deployment. Assists with implementing the security improvements as required.
5. Reviews practices and procedures of database and applications administrators related to upgrades and program modifications and recommends changes to improve security.
6. Develops, implements and maintains Distributed Security for Ellucian Banner ERP, including fine grain access (FGAC) and for additional enterprise applications such as Oracle, Ellucian Banner document management system (BDMS).
7. Serves as the advanced knowledge repository and subject matter expert of the Ellucian Banner security modules and features. Ensures the college systems stay current with enhancements and changes in Ellucian Banner security.
8. Collaborates with cross-functional teams of college software developers, application administrators, database administrators, functional end users and vendor customer support to develop, analyze, review and maintain security policies and standards for individual programs and entire applications.
9. Researches and evaluates new security technology, techniques and industry best practices to identify and make recommendations on security concerns and vulnerabilities.
10. Develops, maintains and updates documentation of all security tools, procedures and policies. Prepares and presents training sessions on application systems, security features and procedures as required.
11. Available after College’s business hours to support critical business use of assigned applications.
12. Performs other departmental duties, as required.
1. Bachelor's degree from a regionally accredited institution or 6 years of direct industry experience.
2. Experience as a software developer or administrator with Ellucian Banner or other ERP applications.
3. Experience with database administration and security with Oracle or similar database systems.
4. A demonstrated commitment to equity and inclusion.
5. Must be able to perform all of the essential functions of the job with or without reasonable accommodation.
1. Experience with SQL scripting and Oracle PL/SQL code.
2. Experience with creating and implementing information security principles and best practices related to risk management, compliance, threat and vulnerability assessments, information protection and access control, security processes, policy and standards.
3. Experience with change management including creating procedures and guidelines.
4. Experience developing technical documentation including process flow documents and flowcharting.
5. Experience providing data protection in a distributed data ownership/stewardship model.
1. Advanced knowledge of software development and database administration and security tools.
2. Strong troubleshooting skills and ability to effectively resolve or escalate issues to management or vendor support areas as necessary.
3. Ability to effectively present information and respond to questions from managers, clients and the College community.
4. Ability to write reports, documentation, business correspondence, and procedure manuals.
5. Ability to learn new technologies, systems, and software, and adapt to change on an ongoing basis.
6. Ability to handle multiple assignments through prioritization and time management, and effectively document and communicate status of projects and issues to management and other Information Technology personnel.
7. Ability to work with minimal supervision, both independently and as a member of a team.
8. Ability to meet deadlines and to achieve and maintain expected productivity levels in a fast paced environment.
9. Ability to travel between campuses may be required on an occasional basis.
10. Ability to work irregular hours, afterhours, and on weekends may be a regular requirement for this position in order to provide 24 hour on-call support for mission critical systems.
11. Ability to work effectively in a diverse community and meet the needs of diverse student populations.
This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. While performing the duties of this job, the noise level in the work environment is usually quiet to moderate.
While performing the duties of this job, the employee is frequently required to sit and reach with hands and arms. The employee is regularly required to use hands to finger, handle, or feel objects, tools, or controls; type/keyboard; and talk or hear. The employee is occasionally required to stand and walk. Employee must on occasion lift/move up to 10 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception, and the ability to adjust focus.