Career Opportunity

PeopleSoft System Administrator (Hybrid Workplace) - Controller's Office (1043) - 0112973

Recruitment: RTF0138171-01129734

Published: October 26, 2023

Apply using SmartRecruiters, the City and County of San Francisco's application portal Learn More

About:

Hybrid Workplace:

Our workplace has a hybrid/flexible weekly schedule, where colleagues work 1 day onsite (in the San Francisco office) and 4 days from home, subject to periodic review and approval.

Specific information regarding this recruitment process are listed below:

• Application Opening: July 26, 2023
• Application Deadline: Continuous
• Annual Salary: $143,026 - $179,946

The Controller is the City’s Chief Financial Officer. Our team includes financial, technology, analytical and other professionals who work hard to secure the City’s financial integrity and promote efficient, effective and accountable government. We hold ourselves to high standards and strive to be a model for good government. We value the diverse backgrounds, perspectives and lived experiences of our teams and clients in everything we do. We work in a collaborative and inclusive environment, promote equal opportunity, and invest in the professional development and wellbeing of our team members. You can expect to work alongside colleagues who are committed to serving the public with integrity and want to see positive impacts from their work. We are looking for smart, motivated individuals who want to make a difference and use government to play a role in solving our City’s problems, including addressing long-standing and harmful disparities in our communities. For a career with purpose and professional growth, join us in the Controller’s Office.

Systems Division:

The Systems Division of the Controller’s Office manages the City and County of San Francisco’s Enterprise Oracle and PeopleSoft Applications, which include Oracle Interaction Hub, PeopleSoft Human Capital Management (HCM), PeopleSoft Financials and Supply Chain Management (FSCM), PeopleSoft Enterprise Learning Management (ELM), and Oracle Business Intelligence.  These applications are branded locally as our SF Employee Portal, SF People & Pay, SF Financials, SF Procurement, SF Learning, and SF Reports and Analytics systems. Collectively, these applications provide a robust, integrated platform that delivers mission-critical services to 55 City Departments, eliminating the need for hundreds of independent legacy systems and customized applications. The division serves over 35,000 active City employees, 75,000 retirees and 25,000 City vendors (bidders and suppliers).  Peripheral and legacy applications also leveraged by the division include Oracle Identify & Access Management, Sherpa Budget Formulation & Management, Phire Architect, Control-M, and FreshWorks.  The technology implemented and maintained by the Systems Division provides standardization, transparency, and efficiency for the City’s crucial business processes. Users are fully supported to ensure adoption of these interconnected functionalities. 

Role description

The PeopleSoft System Administrator is responsible for the administration, maintenance, patching and troubleshooting of the application of both PeopleSoft Enterprise applications and Oracle Business Intelligence applications. Under the PeopleSoft administrator side, it does include the maintenance and synchronization of the PeopleSoft Human Capital Management, PeopleSoft Financials and Supply Chain Management, PeopleSoft Enterprise Learning Management, and PeopleSoft Interaction Hub applications running under Linux and Windows OS.  The designated PeopleSoft Administrator will work closely with the Database Administrator (DBA) to ensure the availability of both PeopleSoft and OBIEE databases and application processes. Works in close collaboration with the PeopleSoft and OBI development teams and as well as Infrastructure and network teams as required.    

Essential duties for this job include but are not limited to: production support and management of the PeopleSoft/OBIEE production and non-production environments from the web server/middleware perspective; researches, analyzes, evaluates, and stays current on industry best practice standards for these technologies; maintaining and installing PeopleSoft infrastructure supporting tools: WebLogic, Tuxedo, Java, and MicroFocus COBOL; troubleshooting WebLogic server, PeopleSoft application domains and Process Scheduler domains; perform periodic PeopleSoft application environment refreshes; creating and executing work plans for applying PeopleSoft updates and patches;  performing integration of third-party software: Oracle Identity and Access Management, Microsoft Active Directory, TimeLink, and Phire Architect; administering PeopleSoft security;  performing bundled project migrations using PeopleSoft Change Assistant, PeopleSoft Application Designer, or Phire Architect; ability to participate in rotational on-call support; and performing other related duties as assigned; experience writing shell scripts for automation; tuning performance, allocating storage space, and implementing critical system patches.

How to qualify

MINIMUM QUALIFICATIONS:

Education:

An associate degree in computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field].

Experience:

Three (3) years of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of an enterprise network.

Substitution: 

Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units/ forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

DESIRABLE QUALIFICATIONS: 

The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring

• Five (5) years of technical experience with PeopleSoft Architecture and PeopleSoft HCM and/or PeopleSoft FSCM Application administration, 9.2; PeopleTools 8.5x, PeopleSoft Infrastructure, Integration Broker configuration and monitoring, Process Scheduler maintenance, PeopleSoft Query security, and executing work plans for applying PeopleSoft updated and patches.
• Three (3) years of PeopleSoft PeopleTools Update and Upgrade Tools 8.5x; including, performing bundled project migrations using PeopleSoft Change Assistant tool and  Application Designer;
• Four (3) years’ experience in PeopleSoft PeopleTools Server Administration; including, installing and maintaining PeopleSoft infrastructure for web, application, batch and file servers, and related third-party supporting tools (WebLogic, Tuxedo, Elastic Search, and MicroFocus Cobol);
• Three (3) years of PeopleSoft PeopleTools Update and Upgrade Tools 8.5x; including, performing bundled project migrations using PeopleSoft Application Designer;
• Four (4) years of Oracle RDBMS SQL experience. 
• Four (4)  years’ experience with Oracle BI maintenance and support;
• Three (3) years of PeopleSoft PeopleTools Security;
• Five (5) years of Oracle RDBMS SQL experience. 
• Four (4) years’ experience with Oracle BI maintenance and support;
• Three (3) years of PeopleSoft PeopleTools Security

VERIFICATION:

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at https://sfdhr.org/how-verify-education-requirements

Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Resumes will not be accepted in lieu of a completed City and County of San Francisco application.

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

What else should I know?

SELECTION PLAN:

Interviews:  Selected candidates will be invited to participate in one or more interviews at the Controller’s Office.

Additional Information Regarding Employment with the City and County of San Francisco:

• Information About The Hiring Process
• Conviction History
• Employee Benefits Overview  
• Equal Employment Opportunity 
• Disaster Service Worker
• ADA Accommodation
• Veterans Preference
• Right to Work
• Copies of Application Documents
• Diversity Statement

Exam Analyst Information: If you have any questions regarding this recruitment or application process, please contact the exam analyst at nancy.giang@sfgov.org.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.