Job ID: TX-529310139C (911990817)
Hybrid PeopleSoft/Oracle DBA with SQL, People Tool, Image Upgrade, HCM/Finance, CAPPS, EIR, and Agile experience
Location: Austin, TX HHSC
Duration: 12+ months
Candidate will be onsite 2 days in the Austin office; 3 days work from home. Candidates must be in Texas. No out of state will be considered.
Years Required/Preferred Experience :
7 Required Oracle Database Administrator Experience
5 Required SQL Experience (strong)
5 Required System Reporting (Oracle, PeopleSoft, SQL)
5 Required DBA Support for system integration
2 Required PeopleSoft 9.2 and People Tool 8.57 or 8.59
2 Required PeopleSoft Image Upgrade experience
2 Preferred PeopleSoft upgrade experience with HCM or Finance
2 Preferred State of Texas Centralized Accounting and Payroll/Personnel System (CAPPS) experience
2 Preferred Knowledge of Enterprise Resource Planning (ERP) Systems
2 Preferred Working knowledge of EIR Accessibility standards and assistive technologies
2 Preferred Familiarity with governmental human resources (human capital management) systems and processes
2 Preferred Agile Software Development Methodologies Experience
The Worker is part of a new capital department for Consolidated Application Control Environment (CACE) Compliance for the CAPPS Human Capital Management (HCM) department. This position will perform database administrator duties that include implementing and maintaining complex PeopleSoft Oracle databases, supporting system rollouts, informing/advising the project manager about project plans and implementation, conducting technical analysis, and producing technical subject matter expert and strategy recommendations. Assist in preparing implementation plans for PeopleTools and PeopleSoft image upgrades. Will also work with technical teams to coordinate UAT and code releases as necessary. Must have experience working in an Agile environment. Some on-call support may be required depending on project phase.
Will assist in efforts to upgrade PeopleSoft 9.2 to a new image and upgrade PeopleTools to new version. Evaluates, installs, and maintains database software. Will troubleshoot tasks in PIA including Oracle Database, Process Scheduler, Application Server, and Web Server on both Unix and Windows. Will Debug and optimize SQL statements in Oracle Database. Will set up the database, schedule regular backups, monitor the database, and provide database support. Will troubleshoot and tune the database. Will perform database backups and recoveries. Controls and monitors database and application security and integrity. Troubleshoots all database and/or application-related performance issues. May assist developers with performance tuning of SQL, queries, and database objects as well as developing stored procedures and/or triggers.