Database Architect III (Oracle DBA)

Position Overview We are seeking an experienced Database Architect / Oracle DBA with strong expertise in Oracle database administration, PeopleSoft infrastructure, performance optimization, and enterprise application environments . The candidate will be responsible for designing, implementing, optimizing, and maintaining Oracle databases supporting large-scale enterprise and financial systems . Key Responsibilities Design, develop, implement, and administer Oracle databases supporting enterprise applications Perform installation, configuration, upgrades, patching, tuning, troubleshooting, and issue resolution Develop and optimize complex SQL queries, stored procedures, views, triggers, reports, and shell scripts Support and maintain PeopleSoft infrastructure including: WebLogic Tuxedo Application Server Process Scheduler PIA Monitor database performance and recommend optimization strategies and infrastructure improvements Collaborate with technical and business teams to analyze workflows and system requirements Provide expertise on database architecture, security, scalability, and reliability Participate in SDLC activities , project planning, coordination, and scheduling Track Oracle patches, fixes, upgrades, and emerging technologies Required Skills & Experience 8+ years of Oracle DBA experience (Oracle 12c or higher) 7+ years of experience in: Database design and development SQL tuning and performance optimization Stored procedures, views, triggers 5+ years of experience with: SQL and UNIX shell scripting TOAD and Oracle database tools Strong understanding of: Relational database architecture and design principles Database security and data protection standards Hands‑on experience with PeopleSoft infrastructure setup and configuration Experience as DBA on at least one full lifecycle PeopleSoft implementation Strong analytical, troubleshooting, and communication skills Preferred Qualifications Experience with PeopleSoft Treasury 9.2 and PeopleTools 8.55+ Experience in PeopleSoft database administration , including: PeopleCode Data Mover Scripts Knowledge of: Oracle RAC Oracle Enterprise Manager (OEM) Oracle Cloud Exadata Experience with Oracle Forms, Perl, HTML, CSS, JavaScript, jQuery, UNIX scripting Oracle OCP/OCM certification preferred Experience creating: Complex SQL reports Data extracts Data models and data dictionaries Mandatory Requirements Must be local to Texas Must have prior State/Government project experience Strong experience with PeopleSoft environments #J-18808-Ljbffr