Install, configure, patch, and upgrade Oracle database software across AWS RDS environments
Perform proactive performance monitoring, SQL tuning, and resource optimization, including PeopleSoft-aware diagnostics (PeopleTools metadata, PSFT schemas, App Server/PIA/Process Scheduler impacts)
Ensure database availability, integrity, and reliability through automated monitoring and alerting using CloudWatch, RDS metrics, and custom PeopleSoft health checks
Develop and implement robust backup strategies, including RMAN, PITR, cross-region backups, and restore validation
Enforce database security policies, including user access, encryption, auditing, ATO compliance, CAT I/II remediation, and SQL inactivity/audit reporting
Troubleshoot database issues, including slow queries, locks, PeopleSoft metadata inconsistencies, and cross-tier performance bottlenecks
Create and maintain documentation for processes, architecture, configurations, and operational runbooks
Automate routine tasks using shell scripting, Python, SQL automation, Lambda workflows, and Step Functions
Support database migrations and upgrades across environments (on-premises/cloud), including PeopleTools upgrades, PUM lifecycle activities, and environment refreshes (masking, scrambling, schema sync)
Participate in disaster recovery planning and testing exercises, including High Availability architecture implementation for PeopleSoft (Multi-AZ, failover testing, DB redundancy, autoscaling alignment)

U.S. Citizenship
Possession of a Department of Defense (DoD) Secret Level Security Clearance
Bachelor's degree in computer science, Information Technology, or relevant experience
Security+ CE Certification, or equivalent
Minimum 5 years of experience as an Oracle DBA with in-depth knowledge of Oracle database architecture
Strong expertise in performance tuning, capacity planning, and system optimization
Proficiency in SQL, PL/SQL, and scripting languages such as Bash or Python
Familiarity with database automation and monitoring tools, including AWS RDS, CloudWatch, and PeopleSoft monitoring integrations
Experience working with cloud-based databases (AWS RDS, OCI, etc.) is a plus

Oracle Database Administrator

Key skills