PeopleSoft Administrator/DBA

Posting Title PeopleSoft Administrator/DBA Overview 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 (Oracle and 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. The projected salary or hourly pay range for this position which represents the full range of anticipated compensation is: $100,000-110,000 Responsibilities Administer Databases Manage the lifecycle of university databases (e.g., Oracle, 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. Administer ERP Systems Install, configure, and maintain core business systems (e.g., PeopleSoft, Raiser’s Edge). 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. 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. 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. Design and Develop the Security Model Design and develop a streamlined, Role-Based security framework for the ERP system. Review and improve the security request, provisioning, and de-provisioning processes. Work with stakeholders to design new models and develop security audit reports and performance metrics. 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. Perform Other Administrative Duties Execute assignments, provide status reports, and create/present briefings. Cross-train staff and participate in relevant group and project meetings. Qualifications Formal Education: Bachelor’s Degree in Information Technology, Computer Science or a related field. Master’s Degree preferred Practical Experience: At least 6 years’ experience as PeopleSoft applications administrator. At least 4 years’ experience with PeopleSoft security administrator. At least 4 years’ experience administering databases (Oracle and/or 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 and managing or leading technical team of IT auditors preferred. Two years’ experience can be substituted by a Master’s degree. Technical Qualifications or Specialized Certification: 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 Database, 19c and later. Microsoft SQL Server, 2019 and later. PeopleSoft Internet Architecture and People Tools. Database and ERP monitoring/management tools. Experience implementing and configuring the following technologies is a plus: Windows Server 2016 or later in an Active Directory environment. Linux server, especially Red Hat Enterprise. Infrastructure as a Service (IaaS) services, especially Amazon Web Services or Microsoft Azure. NoSQL databases. Current, professional-level certification in database administration is highly desirable, e.g., Oracle Database Administrator Certified Professional Microsoft Solutions Expert (MCSE): Data Platform [SQL Server] One or more of the following certifications is desirable: Information security certification, e.g., CompTIA Security+, CompTIA CASP, CISSP. Project management certification, e.g., PMP Other Knowledge, Skills and Abilities Needed: 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. Learning skills: ability to learn and adopt new ideas and technologies. Organizational skills: ability to organize work, coordinate with other team members to accomplish goals, and ensure progress is made on assigned tasks. Good oral and written communication skills: ability to express information to individuals or groups effectively, and to make clear, comprehensible oral and written reports. Technology awareness: knowledge of developments and new applications of computing infrastructure technologies to the university’s technical infrastructure. Teamwork skills: ability to work effectively in teams, both as a member and leader. #J-18808-Ljbffr The Catholic University Of America