Oracle Database Administrator

Atlas Technologies
Monson, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Monson, United States of America

Tech stack

Microsoft Access
Server Applications
Backup Devices
Bash
Cloud Engineering
Program Optimization
Computer Security
Databases
Database Security
Disaster Recovery
Monitoring of Systems
Python
Oracle
PeopleSoft Customer Relationship Management (CRM)
Peoplesoft People Tools
Performance Tuning
Recovery Manager (RMAN)
Shell Script
PL-SQL
SQL Databases
Systems Integration
Scripting (Bash/Python/Go/Ruby)
System Availability
Database Migration
Amazon Web Services (AWS)
Information Technology
People Soft
Performance Monitor
Cloudwatch
Oracle Cloud Infrastructure
Sql Tuning

Job description

Atlas Technologies is seeking a skilled and motivated Oracle/PeopleSoft Database Administrator to join our dynamic IT team and contribute to the development and maintenance of Direct Access infrastructure contract. As an Oracle PeopleSoft Database administrator, you will play a crucial role in designing, implementing, and optimizing the PeopleSoft database required to support our enterprise-wide human resources system., * 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).
  • Adapt to rapid changes in requirements, tooling, and security mandates while maintaining accuracy in SQL audit reports, compliance artifacts, and operational deliverables.

Requirements

Do you have experience in Computer science?, * 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.

Preferred:

  • PeopleSoft-aware DBA experience, including PeopleTools metadata, PSFT schemas, PUM lifecycle, compare reports, and cross-tier troubleshooting.
  • Understanding of cloud-native automation for tuning, backups, security, and scaling.
  • Experience designing or supporting High Availability and Disaster Recovery architectures for mission-critical systems.
  • SQL audit reporting and handling evolving compliance requirements.
  • Automation and scripting skills for operational efficiency and repeatability.
  • Excellent collaboration and communication skills.
  • Attention to detail and a commitment to delivering high-quality solutions.

Want to hear more? Read on to see what our Team Members say about their experience

Benefits & conditions

Pulled from the full job description

  • Tuition reimbursement, Atlas Tech offers a competitive salary, generous benefits package, and an opportunity to make a positive impact in your own community.

About the company

"To me, the best part about working at Atlas is the level of transparency afforded to everyone in the company. I've had plenty of jobs where I knew what I was doing, but at Atlas there is a concerted effort to make sure we also understand why, and how our role directly impacts the overall mission." - Jess "With LEARNING as a core value, Atlas is constantly promoting ways to increase knowledge and stay at the forefront of the latest technology. Team members are regularly encouraged to continue learning and Atlas provides training resources and skills enhancement opportunities internally as well as education reimbursement if you prefer to obtain skills through outside resources or higher education." - Wendy

Apply for this position