Database Architect – Oracle/ peoplesoft

at RedSalsa Technologies, Inc.
Published June 15, 2022
Location Austin, TX
Category Default  
Job Type Full-time  


Title: Database Architect- 3049022169
Location: Austin, TX
Duration: 12+ Months

The Candidate will work with application developers as part of the CPA IT Treasury & Education team, creating, tuning, and maintaining Oracle databases for public and internal PeopleSoft PeopleTools applications. The Candidate will perform highly-advanced analytical work in the support of Treasury applications, as well as provide technical expertise to the team. The Candidate will provide feedback and contribute expertise to improve applications and development processes.

Candidate will perform these tasks:
• Design, develop, implement, and administer Oracle databases for the PeopleSoft Enterprise application information systems.
• Ensure operating success and performance, as well as provide technical expertise and support to the PS/Oracle Treasury infrastructure and application databases.
• Manage and monitor databases and associated technologies; provide input into the evaluation and recommendation of strategies, technologies, and standards for all related infrastructures.
• Perform database tuning and database problem resolution as necessary.
• Work with a team to evaluate business needs, analyze processes, and ensure system documentation reflects current state.
• Provide system expertise and functional/technical support to other team members by identifying problems and propose innovative solutions.
• Work with Treasury technical and functional resources effectively by communicating complex concepts clearly, accurately, and effectively both verbally and in writing.
• Proactively monitor Oracle database patches, fixes, and other relative Oracle applicable research.
• Participate in project management, coordination, planning, and scheduling.

Minimum 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 Experience in providing Oracle database administration to include Oracle 12c or higher including installation, upgrading, and patching.
7 Required Experience in designing, creating, and maintaining Oracle databases, creating and tuning complex SQL, stored procedures, views, triggers, and monitoring and analyzing database performance
7 Required Experience in data integration, data quality, multi-dimensional design and database processes and methodology.
5 Required Experience in designer SQL and shell script development
5 Required Experience using database tools such as TOAD
5 Required Solid knowledge of relational database architecture and concepts
5 Required Experience in development of highly complex application security requirements
5 Required Experience in designing and supporting systems adhering to information protection and security standards.
5 Required Experience with installing and configuring PeopleSoft infrastructure components that includes but are not limited to: Weblogic, Tuxedo, Application Server, Process Scheduler, and PIA.
3 Required Experience with Texas CPA Treasury systems (Treasury Application, WWIC Portal, Texnet, FIS, IPPS).
3 Required Experience with serving in as a database administrator position on at least one full lifecycle implementation of PeopleSoft.
2 Required Experience in MS Office products, including TEAMs Visio, Word, Excel, and PowerPoint
7 Preferred Experience working with combinations HTML, CSS, C, JavaScript, Perl, JQuery, Exadata, and UNIX shell scripting.
7 Preferred Experience with using Oracle Forms.
7 Preferred Experience creating complex SQL queries, reports, and data extracts from Oracle DBMS
7 Preferred Experience with PeopleSoft database administration, including PeopleCode, Data Mover Scripts, and Application
7 Preferred Experience with PeopleSoft implementations, installations, and/or upgrades.
7 Preferred Experience working effectively across multiple groups and functional areas (including leveraging resources by working w/subject-matter-experts) where security processes are concerned.
7 Preferred Experience establishing, documenting, and communicating standards, best practices, fixes, and providing direction/recommendations
4 Preferred Experience with Oracle Real Application Cluster environments, Oracle Enterprise Manager and Oracle Cloud.
4 Preferred Strong database architecture, engineering, and design skills
4 Preferred Experience with installing and configuring PeopleSoft infrastructure components.
4 Preferred Experience working with PeopleSoft Treasury 9.2 and PeopleTools 8.55 or above
4 Preferred Experience working with PeopleSoft Treasury 9.2 and PeopleTools 8.55 or above
1 Preferred Oracle OCP/OCM certification

- provided by Dice

Drop files here browse files ...