Work with multiple IT teams and functional departments to develop, maintain, and enhance Enterprise PeopleSoft Applications and Oracle databases.
Manage PeopleSoft environments including installation, upgrades, patches, replication, data refreshes, performance tuning, and monitoring of Web and Application servers. Manage all production and non-production Oracle databases, including installation, upgrades, patches, backups and recovery, replication, archiving, security, tuning, disaster recovery, monitoring, and validation to support departmental and organizational needs. Proactively manage the database environment to identify and recommend alternatives to poorly coded applications, including consulting with end users and developers to recommend the most appropriate database solution. Assist application development with database design considerations. Assist in the designs of data security models to help protect the University's data. Comply with existing standards, document and communicate any system changes. Provide service and support determined by the current Service Level Agreements, including on-call support. Provide 3rd level support for database and systems problems, working with IT personnel to resolve database issues. Perform impact analysis on all PeopleSoft and PeopleTools updates, and provide proposals for applying them effectively.
Other functions as assigned.
Bachelor's Degree with coursework in computing or information systems and eight years of progressively responsible computer systems management and analysis experience; or any equivalent combination of education, training and experience. Applicants must include in their online resume the following information: 1) Employment history: name of company, period employed (from month/year to month/year), job title, summary of job duties and 2) Education: college or college degree, list school name, degree type, major, graduated or not, and hours completed if not graduated. Equivalent combination of relevant education and experience may be substituted as appropriate.
Bachelor's degree in Information Systems or related field. 10+ years experience in systems analysis, design, and software programming including: 5+ years experience as an Oracle DBA (Oracle 10g/11g) which includes Oracle database replication, database migrations, and upgrades and experience with database backup and recovery (including RMAN); 3+ years experience as a PeopleSoft DBA and/or PeopleSoft Administrator (PeopleTools 8.x, Database upgrade/Data Management Tools, PeopleSoft Application/Tools Upgrade); 5+ years experience with UNIX/LINUX Shell scripting. General understanding of all phases of the application development lifecycle and project management disciplines. Strong MS Office skills (Word, Excel). Oracle DBA Certifications and Certifications in supported technologies. Experience with PeopleSoft Campus Solutions, Enterprise Portal, HCM, Financials, EPM, and/or CRM. Experience integrating PeopleSoft with non PeopleSoft Applications. Excellent organization, teamwork, problem-solving, and communication (verbal and written) skills. Ability to work well with people in all levels of the organization and handle fast paced, dynamic, sometimes volatile environment.
May work around standard office conditions Repetitive use of a keyboard at a workstation Criminal background check conducted.