PeopleSoft Administrator/SR Data Base Administrator

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.