Senior Lead Systems and Database Administrator

The Senior Lead Systems and Database Administrator collaborates with the Chief Systems Administrator in the architectural development of the PeopleSoft application. They maintain and troubleshoot the multi-tier architecture of the PeopleSoft application as well as Oracle database systems. Additionally, they provide essential support for the University's mission-critical applications.

Duties

• DATABASE, SYSTEMS, AND APPLICATION ADMINISTRATION: Administer, maintain, and troubleshoot the PeopleSoft and Oracle database environments, including production and development. Oversee security, availability, performance and tuning. Perform database deployments in the OCI cloud. Configure backup, recovery procedure, and data growth planning. Configure and administer Oracle DataGuard for disaster recovery and failover incidents. Perform full environment or database-only refreshes. Perform project migrations from development to production environments. Collaborate with the chief system administrator to configure systems infrastructure, security, and access controls. Apply configuration changes and enhancements to the PeopleSoft system and database. Administer PeopleSoft components such as WebLogic, Tuxedo, Cobol, PeopleTools, Change Assistant, and PeopleSoft Update Manager (PUM). Administer systems in the OCI cloud using the OCI console. Ensure adherence to systems and environment standards.
• INNOVATION AND SOLUTIONS: Reviews, audits, develops, and deploys processes for the automation of routine system and database tasks through scripting, Oracle Enterprise Manager (OEM), and other tools. Monitors storage utilization to identify thresholds for capacity planning. Oversees the implementation and maintenance of Oracle Automatic Storage Management (ASM). Collaborates in creating processes and procedures to assess performance and availability, assure uptime, and quickly identify and resolve issues through SQL queries, OEM console, system logs, and other tools. Conducts continual service improvement and quality assurance efforts to verify the integrity and effectiveness of backup and recovery strategies. Researches and maintains an advanced knowledge of the OCI Cloud Infrastructure, disaster recovery, incident response, database architecture, security, and other relevant technologies, services, or desired outcomes. 
• SPECIAL PROJECTS: Collaborates on the planning, design, and implementation of the PeopleSoft and database architecture. This includes major upgrades, routine patching, sub-releases of products, and security updates. Partners with the Application, Network, Information Security, Server Engineering, and other teams to deliver and maintain the systems. 
• SECURITY AND MONITORING: Responsible for the administration of database and Peoplesoft architecture security. Coordinates, and facilitates the routine security assessment of assigned systems, applications, or services with the Information Security Office (ISO) and/or other IT colleagues. Participates in rotational on-call duties to monitor and respond to any after-hours alerts or issues.
• TRAINING AND SUPPORT: Provides Tier-3 technical support and troubleshooting of assigned systems, applications, or services. Performs duties in a customer service environment and collaborates with other IT colleagues to identify and resolve technical problems. Reviews, assigns, and/or resolves trouble tickets and service requests. Creates new documentation and updates existing documentation for procedures in a clear and concise manner. Provides internal guidance and training for junior team members. Leads and promotes knowledge-transfer and cross-training efforts. 
• LEADERSHIP AND ADMINISTRATION: Provides mentorship and guidance to junior team members; serves as a subject matter expert for team and IT colleagues. Works with the Manager of Database and Systems Engineering to prioritize work and delegate tasks to other team members. Instills camaraderie within the team, assist in the gathering and analysis of metrics for team and project success. Reviews and submits regular, timely, and complete paperwork and processes, such as status reports, bi-weekly or monthly timesheets, financial activities, assessments for mid-year and annual reviews, and other routine IT and University practices. Keeps personal and shared workspaces clean and organized. May participates in specialty councils such as "OCI Deciders" group meetings or may rotate as a representative of Systems & Networking in the "IT Leadership Council."
• COMMUNICATION AND RELATIONSHIPS: Promotes professionalism across the division to ensure that each staff member represents Pepperdine and IT in a professional manner when collaborating with internal and external stakeholders. Conducts outreach to University or IT stakeholders t