Job ID :
Company :
DC Government
Location :
Type :
Duration :
Salary :
Status :
Openings :
Posted :
22 Sep 2017
Job Seekers, Please send resumes to
Required Skills: PeopleSoft 9.2 HCM Apps Admin/DBA,  People Tools 8.50 +, People Tools 8.54 (HCM), PUM.  

Interviews: Either WebCam or in-person.

Job Description:

The Government of the District of Columbia, Office of the Chief Technology Officer is seeking PeopleSoft 9.2 HCM Application Administrator/Oracle DBA to be working for District's PeopleSoft system administrator role.


Detailed Job Description:


  • Design and development activities for implementation of Oracle Enterprise Manager 12 including installation of new monitoring database modules for enterprise applications such as PeopleSoft 9.2. Provides guidance and expertise to PeopleSoft technical developers working on Time and Labor modules.
  • Database administration and management covering creation of data dictionaries, data and performance models. The position will support to PeopleSoft HCM 9.2 including new development for maximum availability solution.
  • Develops, implements, maintains and enforces documented standards and procedures for the design, development, installation, modification, and documentation of assigned PeopleSoft application administration and upgrade tasks.
  • Candidate must have 10+ years of experience implementing and supporting PeopleSoft HCM v9 modules. PeopleSoft Administration for HCM 9.2 is preferred.  Candidate must possess strong background in Oracle 11g and 12c database administration specifically RAC and Oracle Enterprise Manager (OEM), performance tuning and backup and recovery using RMAN.6. Ensures project life-cycle is in compliance with District standards and procedures.
  • Troubleshoots operational issues.
  • Provides support for any PeopleSoft application administration/upgrade projects.
  • Prior knowledge of Government systems is desirable.
  • Excellent interpersonal skills and prior experience with troubleshooting problems; documenting and reporting back after corrective measures have been taken.
  • Build, configure, debug and support PeopleSoft applications in a multi-instance hosting environment.
  • Provide expert troubleshooting for isolating technical problems in the PeopleSoft Internet Architecture (PIA) including Oracle databases, Tuxedo application servers on Unix / Linux, Process schedulers on both Unix and NT and Weblogic configuration.
  • Analyze issues with Process Schedulers, Application Servers, Application Messaging and Web Servers and Debug.
  • Optimize SQL statements within PeopleSoft HCM 9.2.



  • Coordinates IT project management, engineering, maintenance, QA, and risk management.
  • Plans, coordinates, and monitors project activities.
  • Develops technical applications to support users.
  • Develops, implements, maintains and enforces documented standards and procedures for the design, development, installation, modification, and documentation of assigned systems.
  • Provides training for system products and procedures.
  • Performs application upgrades.
  • Performs, monitoring, maintenance, or reporting on real- time databases, real-time network and serial data communications, and real-time graphics and logic applications.
  • Troubleshoots problems.
  • Ensures project life-cycle is in compliance with District standards and procedures.

Minimum Education/Certification Requirements:

  • Bachelor’s degree in Information Technology or related field or equivalent experience.

Please use this table to list the skills noted in the Required/Desired section of the requirement.  In addition, please respond with the years of experience for each skill and the last time each skill was used.  Add or delete rows as necessary.





Overall IT Exp. (16 + yrs.)   









Prior work experience as a People Tools 8.50 or higher. Experience with People Tools 8.54 preferred in  PeopleSoft HCM. Required. 2 Years.



PeopleSoft HCM 9.0 or higher for Public Sector. Required. 4 Years.



Requirements Analysis and generation of detailed design  specifications. Required. 16 Years.



Experience with PeopleSoft Upgrade Manager (PUM). Highly desired. 3 Years,



PeopleSoft 9.2 Upgrade Experience with execution and  Management of Upgrade Data Conversion Scripts.  Required. 8 Years.



Experience with MS Office (Word, Excel, Powerpoint, Visio).  Required.  16 Years.



16+ yrs. planning, coordinating, and monitoring project  activities. Required. 16 Years.



16+ yrs. leading projects, ensuring they are in compliance with established standards/procedures. Required. 16 Years.



Bachelor’s degree in IT or related field or equivalent experience. Required.



Peoplecode, Application Engine, Integration Broker, BI  Publisher, HTML, XML, SOA / WS. Highly desired.  5 Years.



Familiarity with state, local or federal government HR practices. Highly desired. 5 Years.



Experience with Oracle 11g or higher, Oracle SQL. Highly desired. 6 Years.



Creation of People Tools compare reports. Required. 12 Years.



Analysis and tuning of SQL, database systems, middleware  and application servers. Required. 12 Years.



PeopleSoft Upgrade Technical SME / Project Management Experience (including HCM 9.2). Required. 12 Years.



Excellent oral and written communication skills. Required.