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.
YearsRequired/PreferredExperience :
7RequiredOracle Database Administrator Experience
5RequiredSQL Experience (strong)
5RequiredSystem Reporting (Oracle, PeopleSoft, SQL)
5RequiredDBA Support for system integration
2RequiredPeopleSoft 9.2 and People Tool 8.57 or 8.59
2RequiredPeopleSoft Image Upgrade experience
2PreferredPeopleSoft upgrade experience with HCM or Finance
2PreferredState of Texas Centralized Accounting and Payroll/Personnel System (CAPPS) experience
2PreferredKnowledge of Enterprise Resource Planning (ERP) Systems
2PreferredWorking knowledge of EIR Accessibility standards and assistive technologies
2PreferredFamiliarity with governmental human resources (human capital management) systems and processes
2PreferredAgile 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.