Applications Database Administrator II (EXTENDED POSTING DATE)

Primary Function

The Applications Database Administrator II contributes a high degree of technical and professional judgment in planning and executing ERP software upgrades and supporting system architectures.

Duties and Responsibilities (generally)

This position is responsible for system upgrades, patches, conversions, migrations, application system performance and monitoring, troubleshooting, quality control, security, backup and recovery systems. This position interacts and provides technical support to ERP developers in development and production environments, and provides ongoing support and maintenance to mission critical ERP applications to ensure maximum performance and high availability. This position keeps abreast of current trends and emerging technologies especially in PeopleSoft/Oracle technology, adopts best practices, and documents user procedures. Must provide off-hour support when required. The Applications Database Administrator II reports to the Manager of Database Administration.

Minimum Required Qualifications for this position

1. Bachelor’s Degree in Information Technology (IT) or a closely related discipline.

2. Five (5) years of progressively more responsible work experience in design, development, implementation and testing of technical solutions in ERP systems or web, application and systems administration.

Specialty Factors (Additional Required Qualifications)

Education and Experience Preferred

1. Master’s degree in Information Technology (IT) or a closely related discipline

2. 7 years of experience in database administration and PeopleSoft systems administration

List the knowledge, skills, and abilities critical to the performance of this position.

1. Intermediate Proficiency in Customer and Team Focus: Relates well to people both inside and outside the organization and is dedicated to meeting the expectations and requirements of internal and external customers. Can quickly find common ground and solve problems for the good of all. He/she is team-oriented, cooperative, trustworthy, respectful, supportive, diplomatic, tactful and collaborative, and works to build and maintain effective relationships with both customers and peers. Gets first-hand customer information and uses it for improvements in products and services.
2. Intermediate Proficiency in Driving for Results: Can be counted on to exceed goals successfully and is constantly and consistently one of the top performers. Enjoys working hard and pursues challenging tasks with energy, drive and a need to finish even in the face of setbacks or resistance. Is very bottom-line and action oriented to steadfastly push self and others.
3. Advanced / High Level of Ethics and Values: Adheres to an appropriate (for the setting) and effective set of core values and beliefs during both good and bad times. Acts in line with those values to reward the right values and disapprove of others. Practices what he/she preaches. Complies with State of Illinois ethics laws and completes annual NIU Ethics training.
4. Intermediate /Moderate Level of Proficiency for Learning on the Fly: Is a bright, intelligent, agile, capable, and versatile learner and problem solver who uses rigorous logic and methods to solve difficult problems with effective solutions. Experiments, analyzes and creates new and unique ideas to find fruitful answers to complex problems and quickly grasps the essence and underlying structure of anything. Analyzes both successes and failures for clues to improvement and enjoys the challenges of unfamiliar tasks.
5. Intermediate / Moderate Level of Proficiency in Time Management: Uses his/her time effectively and efficiently. Values time and concentrates his/her efforts on the more important priorities. Performs tasks in a timely manner and can attend to a broader range of activities.
6. Intermediate / Moderate Level of Self-Knowledge: Notices the need to change personal, interpersonal and managerial behavior quickly based on knowing one’s strengths, weaknesses, opportunities and limits. Is personally committed to and actively works to continuously improve, adjust and compensate for mistakes and seeks criticism and feedback.
7. Intermediate / Moderate Level of Proficiency in Communicating Effectively and Professionally: Presents ideas clearly in both verbal and written formats. Listens attentively and tailors communication based on the audience. Presents a professional image in all communications.
8. Intermediate / Moderate Level of Demonstrated Decision Quality: Makes good decisions based upon a mixture of analysis, judgment, experience and useful results. Provides recommendations to others that produce consistent and effective business outcomes. Consulted by others for advice and problem-solving.
9. Intermediate Proficiency in Troubleshooting and Resolving Technical / Functional Issues: Applies fundamental problem-solving and analytical thinking techniques to functional and technical issue resolution including but not limited to service requests, service interruptions, data requests, network issues, job interruptions, and system outages.
10. Intermediate Proficiency in Applying Computer Software Knowledge: Applies understanding of the software development life cycle, training software tools, ERP software tools, and office software tools.
11. Intermediate Proficiency in Applying Operating System Tools, Databases, and Applications Knowledge: Applies knowledge of tools, techniques and practices for the development, maintenance and operations of systems. Uses and understands the interactions and interoperability of different operating system applications for various tasks including but not limited to systems monitoring, customer support, administration, databases, web interfacing, systems management, printing, and network management.
12. Intermediate Proficiency in Applying Knowledge of NIU & DoIT (Division of Information Technology) Policies and Procedures: Understands NIU & DoIT policy and procedural impacts to business results. Recommends the development of new policies or modifications to existing policies where appropriate.
13. Intermediate Functional / Technical Skills: Has the functional and technical knowledge and skills to do the job at a high level of accomplishment, and can also learn new skills and knowledge when appropriate. These skills include:
• Knowledge of PeopleSoft Campus Solutions, HCM, and FSCM
• Knowledge of Oracle Cloud Infrastructure, including management of VMs, LBAAS, and cloud-based automation tools.
• Knowledge of PeopleSoft application technologies e.g. PIA architecture, PeopleTools, Tuxedo, WebLogic, Integration Broker, Process Scheduler, Application Designer, environment migrations, and comparison reports
• Knowledge of Data Mover, COBOL, SQR, SQL, nVision, Change Assistant, and SQL Developer.
• Knowledge of PeopleSoft Update Manager ( PUM ) and Oracle DBMS
• Knowledge of network architecture and management
• Knowledge of security and firewall protocols
• Knowledge of disaster recovery and moving application to production procedures
• Knowledge of PowerShell, Batch, and Unix shell scripting skills
• Excellent written and verbal communication skills

Working Hours
M-F 8am-4:30pm, weekends as needed
Minimum Pay Rate (Hourly or Monthly)
$5416.67 per month
Hiring Rate Information

Actual hiring rate is commensurate with experience, education, and internal equity; position includes a robust benefits package to eligible applicants.

Posting Date
03/25/2021
Closing Date
04/22/2021
Priority Review Date

Special Instructions to Applicants

• Fully complete the Education and Work History sections of the application. Be specific on your entire work history, including employment dates and duties for all positions held. Applicable part-time work experience will be considered toward qualifying for this position, however, it will be converted to a full-time equivalency to determine combined length of experience.
• If you have education and/or training in excess of what is required, we encourage you to upload your unofficial transcripts.
• After the posting has closed, your submission will be reviewed to determine if you meet the minimum qualifications for the classification, including any specialty factors associated with this particular position.
• Please monitor your e-mail for further information regarding your application. Emails will be generated from jobs@niu.edu and CivilServiceTesting@niu.edu . Please add these emails to your address book to ensure timely delivery of any future communication.
• We STRONGLY recommend that contact information used in your online profile be personal use, not professional/work information: personal email address, home address, and phone numbers. The information you provide is used to make contact on search updates, department referrals and interviews, etc. We must be able to relay sensitive and important information in a way that protects your privacy concerning job search activity, now and in the future.
• The Civil Service examination for this classification is a Credentials Assessment, and is based on your application materials as submitted for this posting. If you meet the minimum required qualifications for this position, you will receive a score based on your education and experience, and your name will be placed on the active employment register. After the application deadline, the names within the top three scores will be referred to the hiring department for interview.
• Once this position has been filled, all names will be removed from the employment register in accordance with State Universities Civil Service System rule 250.60(h)(10) .
• If eligible for Veteran’s Preference Points, DD214/DD215/NGB22/DD256 paperwork reflecting an Honorable Discharge MUST be uploaded to this application in order to receive the maximum eligible points on the Civil Service examination.
• Click on Information Technology Technical Associate for more information including typical duties, minimum acceptable qualifications, and testing requirements.
• Please click Human Resource Services – Benefits for detailed information about Northern Illinois University’s benefits package.
• Employment is contingent upon your passing a criminal background investigation. You may not begin work until the criminal background investigation results have been received and cleared by Human Resources.

Link to Department Homepage
Division of Information Technology
Physical Demands

EEO Statement

In accordance with applicable statutes and regulations, NIU is an equal opportunity employer and does not discriminate on the basis of race, color, national origin, ancestry, sex, religion, age, physical and mental disability, marital status, veteran status, sexual orientation, gender identity, gender expression, political affiliation, or any other factor unrelated to professional qualifications, and will comply with all applicable federal and state statutes, regulations and orders pertaining to nondiscrimination, equal opportunity and affirmative action.

The following person has been designated to handle inquiries regarding the non-discrimination policies:

Ethics and Compliance Officer, Title IX Coordinator
Health Services 230
TitleIXCoordinator@niu.edu
815-753-5560

Is Background Check Required
Yes
Visa Policy

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.

ADA Accommodation

NIU remains committed to ensuring that its recruitment and application procedures include full opportunities for applicants with disabilities. Employment opportunities will not be denied to anyone because of the need to make accommodations for a person’s disability during either the application or interview process. An applicant who believes they require an accommodation to participate in the employment process due to a disability may request that accommodation through the Accommodation Request Form . For further assistance, please contact the office of Affirmative Action, Equal Opportunity and Education ( AAEOE ) at ada@niu.edu .

Clery Act Information

NIU provides information regarding campus security, personal and fire safety, including topics such as: crime prevention, emergency response procedures and crime reporting policies, in addition to crime and fire statistics for the most recent three calendar years. The Annual Security Report containing security and safety information is available at www.safety.niu.edu/clery or by contacting the University Police Department and Public Safety Department at 815-753-9628 to receive a hard copy. The Annual Fire Safety Report is available at www.niu.edu/clery/fire_report.pdf or by contacting the Environmental Health and Safety Department at 815-753-0404 to receive a hard copy.

Quick Link
https://employment.niu.edu/postings/55650
Supplemental Questions

Required fields are indicated with an asterisk (*).

1. * Do you posses a Bachelor's degree in Information Technology (IT) or a closely related discipline? (Please upload your unofficial transcript if you are able.)
   • Yes
   • No
2. * How many years of progressively more responsible work experience in design, development, implementation and testing of technical solutions in ERP systems or web, application and systems administration do you possess?
   • Less than 1 year
   • 1-2 years
   • 2-3 years
   • 3-4 years
   • 4-5 years
   • More than 5 years
3. * Please provide the name of the employer and the dates of employment where you gained this experience. Please note that this information must be verified on an NIU application and/or resume.
   
   (Open Ended Question)
   
   
4. * Do you possess a Master's, or higher, degree in Information Technology (IT), IT Management, or a closely related discipline? (Please remember to upload your unofficial transcripts.)
   • Yes
   • No
5. * How many additional years of professional-level work experience in Information Technology (IT) experience do you possess?
   • Less than 2 years
   • 2-5 years
   • More than 5 years
6. * Please provide the name of the employer and the dates of employment where you gained this experience. Please note that this information must be verified on an NIU application and/or resume.
   
   (Open Ended Question)
   
   
7. Have you attached a copy of your DD214, DD215, NGB22, or DD256 for consideration of Veteran's Preference Points? The copy submitted should reflect the status of discharge in order to be considered.
   • Yes
   • No
   • Not Applicable

Applicant Documents
Required Documents

1. Resume/Curriculum Vitae
2. List of at least 3 References

Optional Documents

1. Transcripts (unofficial with official required at hire)
2. Transcripts #2 (unofficial with official required at hire)
3. Certifications/Licensure #1
4. Certifications/Licensure #2
5. Military Discharge Documents ONLY (DD214/DD215/NGB22/DD256)