Position: Assistant Director

(Assistant Director/Lead Banner Database Administrator) Department: University Technology Services-Integrated ERP Applications

Northeastern Illinois University invites applications for the position of Assistant Director/Lead Banner Database Administrator.

Full Time, Continuing Position

Under supervision of the Director of UTS Integrated ERP Applications, the Assistant Director/Lead Banner Database Administrator will be the Banner ERP application and Oracle database administrator for the Ellucian Banner ERP applications and all related integrated components. The Assistant Director/Lead Banner Database Administrator will be responsible for leading the development and implementation Teams for the Banner database, Operational Data Store and Enterprise Data Warehouse databases; the development and implementation of processes/procedures necessary to maintain the databases and the schemas used by UTS staff; managing configuration and performance tuning of Oracle DBMS; and Oracle database and OFM updates, performance, and backups.

About Northeastern Illinois University

Founded in 1867, NEIU has a rich tradition of educational innovation and prides itself on preparing teachers and administrators who make a difference in Chicago. That tradition continues to this day and has expanded to include an array of academic disciplines, allowing the University to embrace fully the community in which it resides. NEIU is regarded as the most diverse public comprehensive university in the Midwest and is designated by the United States Department of Education as a Hispanic Serving Institution. Diversity is an important factor in the character of this urban institution and in the social fabric of the student body. NEIU has an enrollment of 10,000 students, and ALANA students represent nearly 60% of the student body. Located on 67 acres in an attractive residential area on the northwest side of Chicago, the University offers more than 80 undergraduate and graduate programs in the arts, sciences, education, and business. The University has additional campuses in the metropolitan area: The Carruthers Center for Inner City Studies, El Centro, and the Center for College Access and Success (formerly the Chicago Teachers’ Center). The University is also a founding member of the University Center of Lake County consortium campus in suburban Lake County, north of Chicago. Newsweek magazine named Northeastern Illinois University the sixth “Best Investment” in the United States and number one in Illinois. Northeastern shares the top-ten spot with Harvard, Stanford, Princeton and MIT.

Duties and Responsibilities

The Assistant Director/Lead Banner Database Administrator reports to the Director of UTS Integrated ERP Applications who, in turn, reports to the Vice President for Finance and Administration. The Assistant Director/Lead Banner Database Administrator will be responsible for creating, loading and managing databases and DB objects needed by the implementation, development, testing and training teams; mentoring, providing leadership, and training other DBAs, and application programming staff; planning, monitoring and managing the use of database space for pre and post production environments; managing Banner ERP application update process and overseeing patches and update process; and responding to issues, trouble-shooting, and repairing issues with Oracle databases and associated applications including Banner.

The Assistant Director/Lead Banner Database Administrator will also be responsible for developing and implementing the processes necessary to re-fresh or otherwise maintain sets of data for testing and development purposes and automate processes when possible; creating databases and related database objects/schemas, assisting with the physical and logical design of databases; assisting in the planning and design of database physical structures to accommodate large transaction processing and high availability; performing database and application monitoring and tuning to ensure databases run at peak performance; troubleshooting performance issues; and working with the other DBAs and UTS staff to implement the logical database design in the physical environment.

The Assistant Director/Lead Banner Database Administrator will be responsible for assisting in the analysis for database sizing/capacity, server requirements and space requirements; working with the Infrastructure Team to thoroughly implement and test enterprise backup and recovery solution, including Disaster Recovery initiatives; reviewing new database programs, functions, procedures, and packages before they are loaded into production database; and performing upgrading patching of database and related systems based upon Development and Operations requests.

The Assistant Director/Lead Banner Database Administrator will also be responsible for supporting data loading, conversion and batch job operation and do troubleshooting of development/production systems; assisting in the management of security and roles; building indexes as necessary; and providing user support and deliver user and process documentation.

Minimum Qualifications

Master’s degree in computer science, engineering, or similar degree; possess Oracle Certified Associate (OCA) Certification or better (OCP or OCM) for at least 9i; advanced knowledge (more than 5 years’ experience) of database administration, experience should primarily be with Oracle 9i,10g, and 11g applications deployed in a UNIX or Linux environment; experience in Oracle 9i or 10g database performance tuning, implementation of new databases, maintenance for existing databases, implementation and maintenance of security and database monitoring activities; working knowledge of PL/SQL, SQL, SQL *PLUS, UNIX/Linux shell scripting; experience administering Oracle Application Server (OAS); experience with Oracle job scheduling; knowledge of J2EE applications; willing to work anywhere in the United States; and excellent oral and written communication skills are required.

Experience in a Banner ERP environment, including cloning ERP instances and installing Banner updates; Oracle Certified Professional (OCP) or Oracle Certified Master (OCM) Certifications in 10g or 11g; other expert-level Oracle DBMS certifications (Tuning, RAC, SQL, etc.); experience setting up and using Oracle Data Guard for Disaster Recovery; experience configuring and using Oracle Fusion Middleware; real Application Clusters (RAC) experience; experience with Oracle Warehouse Builder (OWB); experience with major Oracle DBMS upgrades (such as from 10g to 11g); java/J2EE development skills; experience with SSO, Sun Identity Management, Active Directory and LDAP; working knowledge of the Cognos Reporting Suite of Tools and their interconnectivity with Oracle databases; and ability to work with and lead team are preferred.

Salary and Benefits

Salary is commensurate with qualifications and experience. Comprehensive benefits package including health, dental and vision benefits, sick and vacation days, and participation in the State Universities Retirement System. Applicants are expected to respond based on the entire job description.

This position requires a background check.

To Apply:

In order to be considered for employment by Northeastern Illinois University (NEIU) you must submit the following and send all documents within one PDF/Word document to asstdirdba@neiu.edu.

• A letter of interest addressing your qualifications for this position
• Current resume
• Three (3) current professional references
Employment Application
Affirmative Action Form
Statement of Annuitant Status
• Copies of unofficial transcripts are accepted; however, official transcripts will be required of candidates selected for on-campus interviews

In addition to the links provided above for the Employment Application (fillable), Affirmative Action Form and Statement of Annuitant Status, you can also obtain these forms at the NEIU Office of Human Resources, Bernard Office Building (B0B), 5555 N. Bernard Street, Chicago, IL 60625, Monday through Friday, 8:30 a.m. to 4:30 p.m. Review of applications will begin immediately and continue until the position is filled.

Northeastern Illinois University is an Equal Opportunity/Affirmative Action Employer and invites applications from Women, Minorities, Veterans and Persons with Disabilities, as well as Other Qualified Individuals. Northeastern Illinois University's positions are contingent upon the University's receipt of its State of Illinois appropriation.