Oracle Database Administrator

This is a fully remote position, open to applicants in Texas.

📋 Description

• Install, configure, patch, and upgrade Oracle database software in AWS RDS environments.

• Conduct proactive performance monitoring, SQL tuning, and resource optimization, incorporating PeopleSoft-aware diagnostics (PeopleTools metadata, PSFT schemas, App Server/PIA/Process Scheduler impacts).

• Ensure the availability, integrity, and reliability of databases through automated monitoring and alerting utilizing CloudWatch, RDS metrics, and custom PeopleSoft health checks.

• Develop and execute comprehensive backup strategies, including RMAN, PITR, cross-region backups, and validation of restore processes.

• Implement database security protocols, covering user access, encryption, auditing, ATO compliance, CAT I/II remediation, and SQL inactivity/audit reporting.

• Diagnose database issues, such as slow queries, locks, inconsistencies in PeopleSoft metadata, and performance bottlenecks across tiers.

• Create and sustain documentation for processes, architecture, configurations, and operational runbooks.

• Automate routine tasks utilizing shell scripting, Python, SQL automation, Lambda workflows, and Step Functions.

• Assist with database migrations and upgrades across various environments (on-prem/cloud), including PeopleTools upgrades, PUM lifecycle activities, and environment refreshes (masking, scrambling, schema synchronization).

• Engage in disaster recovery planning and testing, including implementing High Availability architecture for PeopleSoft (Multi-AZ, failover testing, DB redundancy, autoscaling alignment).

• Adjust to rapid changes in requirements, tooling, and security mandates while ensuring precision in SQL audit reports, compliance artifacts, and operational deliverables.

⛳️ Requirements

• U.S. Citizenship.

• Hold a Department of Defense (DoD) Secret Level Security Clearance.

• Bachelor’s degree in Computer Science, Information Technology, or equivalent experience.

• Security+ CE Certification, or an equivalent qualification.

• At least 5 years of experience as an Oracle DBA with extensive knowledge of Oracle database architecture.

• Strong skills in performance tuning, capacity planning, and system optimization.

• Proficient in SQL, PL/SQL, and scripting languages such as Bash or Python.

• Familiar with database automation and monitoring tools, including AWS RDS, CloudWatch, and PeopleSoft monitoring integrations.

🏝️ Benefits

• Competitive salary.

• Health insurance.

• Professional development opportunities.

• Education reimbursement.