Title: Database Administrator

Location: Austin,TX

Duration: Long Term

You may either create a user id and sign up under the arytic link or go in without signing up to access the job/open roles on our Arytic platform.

https://candidate.arytic.com/Ijobdetail/100253

Job Description:

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.

Required Skills:

• 7 years of experience in Oracle Database Administrator Experience
• 5 years of experience in SQL Experience (strong)
• 5 years of experience in System Reporting (Oracle, PeopleSoft, SQL)
• 5 years of experience in DBA Support for system integration
• 2 years of experience in PeopleSoft 9.2 and People Tool 8.57 or 8.59
• 2 years of experience in PeopleSoft Image Upgrade experience

Preferred Skills:

• 2 years of experience in PeopleSoft upgrade experience with HCM or Finance
• 2 years of experience in State of Texas Centralized Accounting and Payroll/Personnel System (CAPPS) experience
• 2 years of experience in Knowledge of Enterprise Resource Planning (ERP) Systems
• 2 years of experience in Working knowledge of EIR Accessibility standards and assistive technologies
• 2 years of experience in Familiarity with governmental human resources (human capital management) systems and processes
• 2 years of experience in Agile Software Development Methodologies Experienc