Oracle Database Administrator (DBA)

Peraton; Washington (District of Columbia); Hybrid; USD 130,000 - 180,000; Full time

Benefits offered by this job

Remote work

On-site meetings in DMV

Job summary

Peraton is seeking an Oracle Database Administrator (DBA) to join our CAEIO program under the Department of State. The DBA will implement and optimize Oracle databases to support consular operations globally.

The role includes 3rd shift scheduling with a fully remote setup; candidates must reside in the Washington, DC metropolitan area for occasional onsite meetings at the DMV or Sterling, VA offices.

Qualifications

• Bachelor’s degree with 12+ years of experience, or equivalent education/experience combination.
• U.S. citizenship and active SECRET clearance with ability to obtain TOP SECRET.
• Minimum 7 years of experience as an Oracle Database Administrator or related Oracle role, including 5+ years hands-on.
• Hands-on experience with Oracle 19c RDBMS in production environments.
• Experience with upgrades/migrations across 11g, 12c, 19c including RAC, ASM, GoldenGate, Data Guard, RMAN.
• Experience with TDE and Oracle database security.
• Experience conducting pre-upgrade assessments, lifecycle reviews, post-upgrade validation.
• Experience administering Oracle databases in Oracle Linux environments.
• Experience supporting enterprise Oracle migrations using Agile/SAFe.
• Strong communication, organizational, and leadership skills.

Responsibilities

• Implement, administer, and maintain Oracle database environments.
• Manage backups, replication, notifications, and DR activities.
• Lead 24x7 OLTP database operations, health monitoring, DR readiness.
• Execute production-impacting activities per procedures.
• Confirm backup, recovery, and data retention requirements.
• Coordinate operational documentation and turnover communications.

Skills

Strong communication

Leadership

Mentoring

Troubleshooting

Prioritization

Education

Bachelor’s degree

Associate’s degree

Masters degree

High School diploma

Tools

Oracle 19c

GoldenGate

RMAN

Data Guard

Oracle OEM

Job description

Basic Qualifications:

• Bachelor’s degree and 12 years of experience or an Associate’s degree and 14 years of experience or a Masters degree and 10 years of experience or a High School diploma/equivalent and 16 years of experience.
• U.S. citizenship and minimum active SECRET clearance with the ability to obtain a TOP SECRET clearance.

• Minimum of 7 years of experience as an Oracle Database Administrator (DBA) or in an Oracle-related technical role, including at least 5 years of hands‑on Oracle database administration experience.

• Hands‑on experience implementing, administering, upgrading, and migrating Oracle 19c RDBMS in production environments.

• Experience with Oracle database upgrades and migrations involving Oracle 11g, 12c, and 19c, including experience with Oracle RAC, ASM, GoldenGate, Data Guard, RMAN, database patching, and security.

• Experience with Transparent Data Encryption (TDE) and Oracle database security.

• Experience conducting pre‑upgrade assessments, reviewing Oracle Support lifecycles, and performing post‑upgrade validation.

• Experience administering Oracle databases in Oracle Linux environments.

• Experience supporting enterprise Oracle database migration initiatives using Agile or Scaled Agile Framework (SAFe) methodologies.

• Strong communication, organizational, and leadership skills, including the ability to communicate technical recommendations, troubleshoot complex issues, prioritize tasks, and mentor junior team members.

Preferred Qualifications:

• Experience upgrading Oracle databases from 19c to 23ai or 26ai.

• Experience with Oracle GoldenGate replication, including 19c and 21c hub configurations.

• Experience developing custom monitoring reports using Oracle Enterprise Manager (OEM) 12c and deploying OEM 24.1 agents.

• Experience with Oracle RAC upgrades, database containerization using CDB/PDB architecture, and Oracle Exadata Engineering systems.

• Experience managing Oracle Exadata environments, including X6-8 through X11M-2, OCI Cloud, and ZDLRA/RA23 backup engineering systems.

Peraton is seeking an Oracle Database Administrator (DBA) to join our team of qualified and diverse individuals on our Department of State (DOS) Bureau of Diplomatic Technology (DT) Consular Affairs Enterprise Infrastructure Operations (CAEIO) program. CAEIO provides IT Operations and Maintenance to modernize the legacy networks, applications, and databases supporting consular applications and services globally.

The DBA will implement and optimize the computerized database systems that support the CA’s ability to function daily and, therefore, enable its mission.

Core Work Schedule: Saturday through Thursday, 3rd shift, 11:00 PM ET – 7:30 AM ET. (First shift of the week begins on Saturday at 11:00 PM. Last shift of the week ends on Thursday at 7:30 AM.)

Location: This position is fully remote; however, candidates must reside in the Washington, DC, Metropolitan Area (DMV) to accommodate occasional onsite meetings, training, or customer support activities at the Washington, DC, customer location or the Peraton office in Sterling, VA. While undergoing training, the selected individual will be required to work the first shift until management determines they are ready to transition to their regularly assigned shift. The number of days the DBA's works on‑site in Washington, DC, or Sterling, VA, is subject to change based on government/program requirements (for example, surge support might require the individual to be in the office five days per week).

Day to Day Roles and Responsibilities:

Database Operations (DBA Ops)

• Implement, administer, and maintain Oracle database environments, including physical design, system integration, availability management, and backup/recovery operations.
• Manage database and transaction log backups, replication, notifications, and disaster recovery activities across Oracle RDBMS servers and remote sites.
• Lead operational support for a global 24x7 OLTP database environment, including health monitoring, index maintenance, troubleshooting critical incidents, and DR readiness.
• Execute production-impacting activities in accordance with established operational protocols, verification procedures, and documented checklists.
• Confirm backup, recovery, and data retention requirements prior to maintenance, cleanup, archival, or deletion actions.
• Coordinate and maintain accurate operational documentation, scripts, inventories, and turnover communications.

Security, Compliance, and Risk Management

• Maintain database security and integrity controls; support and understand Federal IT ATO processes.
• Manage enterprise security hygiene, performing rapid remediation of high‑severity CVEs and KEVs.
• Ensure scripts, maintenance processes, and operational changes comply with approved configurations and repositories.
• Apply due diligence, risk awareness, and quality‑control practices for all actions affecting production environments and critical services.

Performance, Monitoring, and Optimization

• Conduct performance tuning for SQL queries, PL/SQL packages, and database infrastructures.
• Perform ongoing performance analysis and database health monitoring for mission‑critical systems.
• Apply advanced diagnostic methods and research techniques to resolve complex system issues.
• Support and troubleshoot Oracle RAC and Data Guard performance and availability concerns.

Database Development and Engineering

• Develop stored procedures, triggers, and other PL/SQL components.
• Audit, modify, and amend data using SQL and PL/SQL.
• Assist database designers and information system analysts with SQL and web‑based database development.
• Participate in full life cycle implementations of Oracle 19c RDBMS and GoldenGate data replication.
• Plan and execute in‑place upgrades from Oracle 19c/21c to Oracle Database 26ai using AutoUpgrade.

Governance, Standards, and Documentation

• Formulate, develop, and enforce database management policies, procedures, and standards.
• Document database administration activities, including maintenance, incidents, troubleshooting, scripts, and system changes, within ServiceNow.
• Review and validate operational scripts and ensure alignment with current system updates and approved procedures before execution.
• Participate in periodic reviews and continuous improvement of operational procedures.
• Review technical documentation, designs, reports, and materials produced by staff.
• Create and maintain reporting systems using tools such as Oracle OEM BI; research and implement emerging database technologies.