PeopleSoft Oracle DBA (6158-1)

Tri-Force Consulting Services, Inc. • New York, NY

2d • Hybrid

About The Position

The PeopleSoft Oracle DBA will support mission-critical, highly customized, union-driven systems and integrations during active contract updates, modernization, and migration initiatives. Work includes supporting changes involving Sick Cashouts, Annual Sick Cashouts, union sidebar agreements, Tier 6 pension issues, and Sick Time (GOOD/BAD) process categories while protecting payroll accuracy, leave management, and union compliance.

The role supports the UTS Modernization Effort, including modernization of the UTS Pick / Crew and Timekeeping Process, which includes more than 525 screens and 470 reports. The position contributes detailed system knowledge to requirements validation, architecture review, performance baselining, QA/UAT cycles, vendor oversight, and defect remediation. Modernization includes replicating PICK screens, logic, LOVs, triggers, and reports in APEX/BI Publisher, and involves integrations with HASTUS, Insight, Kronos, BSC payroll, TLCS, CIS/BO, and the Data Lake.

The role also supports the transition of functions from the 45-year-old ATS mainframe system into UTS for more than 20,000 employees. Knowledge of UTS workflows, timekeeping rules, crew management, and attendance processes is needed to help prevent migration issues, reporting gaps, and payroll inconsistencies. The assigned staff are expected to provide production support, incident management, system maintenance, and 24/7 support for mission-critical applications, ensuring high availability and business continuity.

Requirements

• In-depth understanding of Workforce Management and Timekeeping systems.
• Experience providing 24/7 support for mission-critical applications and ensuring high availability and business continuity.
• Strong background in production support, incident management, and system maintenance.

Responsibilities

• Support system redesign, testing, and deployment for Sick Cashouts, Annual Sick Cashouts, union sidebar agreements, pension issues, and Sick Time category changes.
• Maintain payroll accuracy, leave management, and union compliance while implementing system changes.
• Support the UTS Modernization Effort, including requirements validation, architecture review, performance baselining, QA/UAT, vendor oversight, and defect remediation.
• Support replication of PICK screens, logic, LOVs, triggers, and reports in APEX/BI Publisher.
• Support integrations with HASTUS, Insight, Kronos, BSC payroll, TLCS, CIS/BO, and the Data Lake.
• Support migration of ATS functions and more than 20,000 employees into UTS, helping prevent data migration issues, reporting gaps, and payroll inconsistencies.
• Provide production support, incident management, and system maintenance for mission-critical applications.
• Provide 24/7 support to ensure high availability and business continuity.

What This Job Offers

• Education Level: No Education Listed