Base Jobs in Chicago, IL (NOW HIRING)

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 thesecurity, integrity, performance, availability, recoverability, and scalabilityof databases and applications supporting the University's business whilealigning with industry best practices and organizational strategic goals.
Ensures the implementation of robust system configurations and performscomprehensive maintenance activities, including patching, upgrading, andmigrating complex database (MS SQL Server) and ERP (PeopleSoft) systems toenhance security, ensure compliance, and take advantage of the latest softwareenhancements. Resolves complex technical issues with diligence and developsinnovative solutions to improve system performance, reliability, andfunctionality. This role requires a strong blend of technical expertise andinterpersonal skills, working collaboratively with engineers across departmentsto support the effective administration of enterprise applications, ERPsystems, and databases.
Essential JobResponsibilities:      
1.  AdministerDatabases -

• 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.  AdministerERP 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 andImplement 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.  ProvideExpert Technical Support - 

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

5.  PerformDay-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.  PerformOther 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.

OtherFunctions:

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.