Database Architect/Oracle DBASeeking an experienced Database Architect/Oracle DBA with strong expertise in Oracle database administration, PeopleSoft infrastructure support, database performance optimization, and enterprise application environments.
The role involves designing, implementing, optimizing, and maintaining Oracle databases supporting large-scale enterprise and financial systems.Key ResponsibilitiesDesign, develop, implement, and administer Oracle databases supporting enterprise applicationsPerform Oracle database installation, configuration, upgrades, patching, tuning, troubleshooting, and issue resolutionDevelop and optimize complex SQL queries, stored procedures, views, triggers, reports, and shell scriptsSupport and maintain PeopleSoft infrastructure components including WebLogic, Tuxedo, Application Server, Process Scheduler, and PIAMonitor database performance and recommend optimization strategies and infrastructure improvementsCollaborate with technical and business teams to analyze workflows, system requirements, and maintain documentationProvide technical expertise related to database architecture, security, scalability, and reliabilityParticipate in project planning, coordination, scheduling, and SDLC activitiesTrack Oracle patches, fixes, upgrades, and emerging technologies relevant to enterprise database environmentsRequired Skills & Experience8+ years of Oracle Database Administration experience with Oracle 12c or higher including installation, upgrades, and patching7+ years of experience designing, creating, and maintaining Oracle databases including complex SQL tuning, stored procedures, views, triggers, and performance analysis5+ years of SQL and UNIX shell scripting experience5+ years of experience using TOAD and related Oracle database toolsStrong knowledge of relational database architecture, engineering, and design principlesExperience implementing database security and information protection standardsExperience installing and configuring PeopleSoft infrastructure components including WebLogic, Tuxedo, Application Server, Process Scheduler, and PIAExperience serving as DBA on at least one full lifecycle PeopleSoft implementationStrong analytical, troubleshooting, communication, and documentation skillsPreferred QualificationsExperience with PeopleSoft Treasury 9.2 and PeopleTools 8.