Database Administrator

Company: AgreeYa Solutions
Location: Austin
Posted on: March 20, 2023

Job Description:

Job Description

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.II. CANDIDATE SKILLS AND QUALIFICATIONSMinimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
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

About AgreeYa:

AgreeYa is a global systems integrator delivering a competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 1,800+ professionals across offices. AgreeYa works with 550+ organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public Sector, Pharma & Biotech, Retail, Client, and others. Please visit us at www.agreeya.com for more information.

Equal Opportunity:

AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics. Visit our website at www.agreeya.com/career-culture to learn about our Career & Culture.

Keywords: AgreeYa Solutions, Austin , Database Administrator, IT / Software / Systems , Austin, Texas