PeopleSoft Administrator/SR Data Base Administrator

PeopleSoft Administrator/SR Data Base Administrator

Benedictine University is an inclusive academic community, inspired by the Catholic intellectual tradition and Benedictine values. We seek employees who will contribute to the advancement of our mission by helping students shape lives of meaning and purpose as engaged citizens who care for the Earth, welcome people of diverse faiths and cultures, and promote the common good.

Job Title: PeopleSoft Admin/SR Data Base Administrator

Department: Information Technology

Reports to: Director of Information Technology

Status: Full-Time, Benefit Eligible

Rate: $90,000 - $95,000 annually

Location: Lisle Campus

Position Summary:

Plans, architects, develops, implements, administers, and maintains systems and procedures for ensuring the security, integrity, performance, availability, recoverability, and scalability of databases and applications supporting the University''s business while aligning with industry best practices and organizational strategic goals.

Ensures the implementation of robust system configurations and performs comprehensive maintenance activities, including patching, upgrading, and migrating complex database (MS SQL Server) and ERP (PeopleSoft) systems to enhance security, ensure compliance, and take advantage of the latest software enhancements. Resolves complex technical issues with diligence and develops innovative solutions to improve system performance, reliability, and functionality. This role requires a strong blend of technical expertise and interpersonal skills, working collaboratively with engineers across departments to support the effective administration of enterprise applications, ERP systems, and databases.

Essential Job Responsibilities:

1. Administer Databases -

• Manage the lifecycle of university databases (MS SQL Server), including installation, configuration, maintenance, and backup.
• Resolve database problems, perform root cause analysis, and automate administration tasks.
• Monitor integrity, security, utilization, and performance; maintain accurate documentation.

2. Administer ERP Systems -

• Install, configure, and maintain core business systems (e.g., PeopleSoft).
• Monitor performance, conduct tuning, and resolve system problems, including root cause analysis.
• Maintain system integrity and security, manage access logs, and implement encryption/auditing tools.
• Identify and apply new releases, upgrades, and patches.
• Manage PUM images, apply maintenance packs, PRPs, and Tools patches.
• Administer Application Servers (PSAPPSRV), Process Schedulers, Web Servers, and Integration Broker.

3. Design and Implement Infrastructure Enhancements -

• Lead or participate in projects to implement and test ERP and database infrastructure.
• Develop project plans, coordinate activities, and ensure comprehensive documentation.
• Perform production migrations with minimal disruption, adhering to change control.
• Develop database and application contingency and disaster recovery plans.

4. Provide Expert Technical Support -

• Act as top-tier support for critical escalated security and system issues.
• Process assigned service tickets and perform expert-level troubleshooting and root cause analysis.
• Serve as a technical liaison and participate in security design and third-party integrations

5. Perform Day-to-Day Security Activities -

• Provision and de-provision ERP accounts, managing all aspects of security (roles, row-level access).
• Analyze and resolve security problems and audit security across all environments.
• Maintain security structures, migrate security across databases, and support internal/external IT security auditors.

6. Perform Other Administrative Duties -

• Execute assignments, provide status reports, and create/present briefings.
• Manage staff consisting mainly of business analysts.
• Cross-train staff and participate in relevant group and project meetings.
• Other duties as assigned.

Other Functions:

1.) Analytical skills: ability to integrate differing bodies of knowledge in troubleshooting and solving technical problems, including performing root cause analysis and follow up to ensure the issues are addressed at the root level.

2.) Learning skills: ability to learn and adopt new ideas and technologies.

3.) Organizational skills: ability to organize work, coordinate with other team members to accomplish goals, and ensure progress is made on assigned tasks.

4.) Good oral and written communication skills: ability to express information to individuals or groups effectively, and to make clear, comprehensible oral and written reports.

5.) Technology awareness: knowledge of developments and new applications of computing infrastructure technologies to the university''s technical infrastructure.

6.) Teamwork skills: ability to work effectively in teams, both as a member and leader. Provide direct leadership to enterprise applications team.

Required Qualifications:

Education: Bachelor''s Degree Required

Experience:

• At least 4 years'' experience as PeopleSoft applications administrator.
• At least 2 years'' experience administering databases (MS SQL Server) in support of a multi-tiered ERP environment.
• Experience writing SQL queries, generating reports and writing scripts to automate processes.
• Experience handling annual IT security audits.

Specific Skills:

• IT concepts, principles, methods, and practices. Information security principles and methods.
• Performance monitoring principles and methods.
• Relational database principles, methods, and practices.
• Database backup, recovery and high availability principles, methods, and practices.
• ERP principles, methods, and practices.
• Software development lifecycle (SDLC) principles, methods, and practices.
• Operational task automation through programming and scripting principles and methods.
• Principles, methods, and tools for developing, scheduling, coordinating, and managing projects and resources.
• Knowledge of, and materially demonstrable experience implementing and configuring, the following technologies: Oracle Fusion Middleware, Microsoft SQL Server 2019 and later.
• PeopleSoft Internet Architecture and People Tools.
• Database and ERP monitoring/management tools.
• Strong Understanding of WebLogic, Tuxedo, PSADMIN, PeopleSoft Security & Integration Broker, Elasticsearch / OpenSearch, Change Assistant, DPK, and PeopleSoft Update Manager.

Specific Knowledge, Licenses, Certifications: Yes

Microsoft Solutions Expert (MCSE): Data Platform SQL Server PeopleSoft System Administrator

Physical Requirements: While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to stand; walk; use hands to touch, handle or feel; and reach with hands and arms. The employee is occasionally required to sit; climb or balance; and stoop, kneel, crawl or crouch. The employee must frequently lift and move up to 25 pounds and occasionally lift and move up to 50 pounds. Use of computer screen. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.

The following of campus specific guidelines for pandemic protocols are required.

Travel (If applicable): No

Supervisory Responsibility (if applicable): Yes

Working Conditions: This position is expected to be performed on-site, in the office, Monday through Friday during normal business hours with occasional evening or weekend hours for critical events, system updates, or incident response. Occasional remote work may be permitted with prior approval and based on business needs.

Training: As a University employee you are required to complete all University-specific and/or OSHA related training to fulfill your job duties. Specific training will be conducted online or in person. Employees must complete all trainings required by Benedictine University.

Employee Benefits Package:

We are pleased to offer the following benefits to support your health, well-being, and professional growth. Please note that benefits are subject to change and eligibility requirements may apply:

• Health Insurance: Comprehensive medical, dental and vision coverage to support your health needs.
• Disability Insurance: Protection for both short-term and long-term disability.
• Life Insurance: Financial security for your loved ones in case of the unexpected.
• Paid Time Off (PTO): Generous paid vacation, sick leave, and mental health days.
• Retirement Plans: Save for your future with our retirement savings options.
• Mental Health Support: Access to counseling and resources for mental well-being.
• Tuition Reimbursement: Financial support for your education and professional development.
• Financial Wellness Advisors: Personalized advice to help manage and plan your finances.
• Employee Assistance Programs (EAP): Confidential support for personal or work-related challenges.

Benedictine University does not discriminate in its admissions or educational policies, programs or activities; scholarship and loan programs; athletic and other University administered programs or employment practices on the basis of race, creed, color, national origin, sex, sexual orientation, age, disability, military or veteran status, marital status, citizenship, or any other characteristic protected by applicable law. The laws applicable to Benedictine University include constitutional and statutory protections of the University''s rights as a religiously sponsored institution. This policy of equal employment opportunity applies to all employment and personnel practices including, but not limited to, recruiting, hiring, promotion, training and compensation.

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. The following of campus specific guidelines for pandemic protocols are required.

Benedictine University is an Equal Opportunity Employer.