Role: PeopleSoft Oracle DBA ( This is An Incumbent Role) Location: 2 Broadway, New York, NY (Hybrid with 2 days remote and 3 days on site) Duration: Long TermJob Description: The Unified Timekeeping System (UTS) remains one of the MTA's most critical operational platforms, supporting more than 28,000 employees, 40+ unions, and hundreds of contractual and labor rules across Buses, Subways, SIRTOA, and MTA Bus. Over the past year alone, UTS has handled a significant volume of incidents, service requests, and JIRA deliveries, demonstrating its operational complexity and the ongoing demand for expert support.
At the same time, the organization is undertaking major modernization initiatives-including the transformation of the UTS modernization into Apex, full architectural redesign, regulatory compliance updates, Sick Cash out contractual changes, and the high risk migration of ATS users from a 45 year old mainframe into UTS.
Given the system's scale, criticality, and the simultaneous delivery of multiple modernization and integration programs, extending the three long tenured consultants is essential to maintain business continuity, protect payroll integrity, ensure modernization success, and support major upcoming union and contractual changes.
Proven Operational Need - Over the last 12 months, UTS supported heavy operational workload:
- 75 incidents per quarter
- 200+ service requests per quarter
- 250 JIRA deliveries per quarter
- These totals confirm ongoing, high velocity demand requiring stable, experienced technical support.
- Each consultant currently handles business critical troubleshooting and problem resolution that directly impacts scheduling, timekeeping, and weekly payroll cycles where "every minute counts."
Critical Business Continuity - UTS processes 171 payroll transmissions and 1,000+ files weekly, supporting 28,000+ employees.
- Any interruption directly impacts bus and subway service levels, overtime calculations, leave balances, and union compliance.
- The consultants possess historical system knowledge that is not replaceable in the short term, ensuring continuity in a highly customized environment with 40+ unions and hundreds of contractual rules.
- Contractual and Regulatory Changes
Following are the current examples - Multiple active contract updates-Sick Cashouts, Annual Sick Cashouts, and different union sidebar agreements-require ongoing system redesign, testing, and deployment.
- Working with Pension department on Tier 6 Pension issues
- Sick Time (GOOD/BAD) category changes to the process
- These changes must be executed without jeopardizing payroll accuracy, leave management, or union compliance.
- The current consultants already support these modules; replacing them introduces unacceptable risk during active contract implementations.
UTS Modernization Effort - Modernization Phase 1 requires detailed knowledge of:
- UTS Pick / Crew and Timekeeping Process - 525+ screens; 470+ reports
- Integrations with HASTUS, Insight, Kronos, BSC payroll, TLCS, CIS/BO, and Data Lake
- Exact replication of PICK screens, logic, LOVs, triggers, and reports in APEX/BI Publisher depends on consultants with deep system history and design knowledge.
- Their continued presence is critical for:
- Requirements validation
- Architecture review
- Performance baselining
- QA/UAT cycles
- Vendor oversight and defect remediation
- Without these consultants, modernization timelines, quality gates, and production readiness would be at risk.
- ATS Migration (20,000+ Employees Moving into UTS)
- ATS is a 45 year old mainframe system with no modifiability and limited expertise remaining.
- Transitioning ATS functions into UTS requires detailed understanding of UTS current workflows, timekeeping rules, crew management, and attendance processes.
- The consultants already support these integrations and are essential to prevent data migration issues, reporting gaps, and payroll inconsistencies during transition.
- High Risk of not having consultant
- UTS is highly customized, union driven, and deeply integrated across multiple agencies.
- Losing consultants during modernization and integration phases would:
- Slow down delivery
- Introduce critical defects
- Increase operational outages
- Delay ATS onboarding
Additional Skills and Information:
- Proficient in PL/SQL, Oracle, Oracle Forms, Oracle Apex, and Oracle Reports.
- In-depth understanding of Workforce Management and Timekeeping systems.
- Experienced in providing 24/7 support for mission-critical applications, ensuring high availability and business continuity.
- Strong background in production support, incident management, and system maintenance.
