Oracle Database Administrator (DBA)

Peraton•,

1d•$112,000 - $179,000•Remote

About The Position

Peraton is seeking an Oracle Database Administrator to support its Department of State Bureau of Diplomatic Technology Consular Affairs Enterprise Infrastructure Operations (CAEIO) program. CAEIO provides IT operations and maintenance to modernize legacy networks, applications, and databases supporting consular applications and services globally. The DBA will implement and optimize computerized database systems that support Consular Affairs’ daily operations and mission. This fully remote position requires residence in the Washington, DC metropolitan area to accommodate occasional onsite meetings, training, or customer support in Washington, DC, or Sterling, VA. During training, the selected candidate will work first shift until management determines readiness to transition to the regular schedule. Onsite frequency may change based on government or program requirements. The core schedule is Saturday through Thursday, third shift, 11:00 PM ET to 7:30 AM ET. The role supports a global 24x7 online transaction processing database environment and includes Oracle database operations, security and compliance, performance optimization, development and engineering, and operational governance. The salary range is $112,000–$179,000, with potential eligibility for overtime, shift differential, and a discretionary bonus.

Requirements

Bachelor’s degree and 12 years of experience, Associate’s degree and 14 years of experience, Master’s degree and 10 years of experience, or high school diploma/equivalent and 16 years of experience.
U.S. citizenship and a minimum active SECRET clearance, with the ability to obtain a TOP SECRET clearance.
At least 7 years of experience as an Oracle Database Administrator or in an Oracle-related technical role, including at least 5 years of hands-on Oracle database administration.
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 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 communicating technical recommendations, troubleshooting complex issues, prioritizing tasks, and mentoring junior team members.
Must reside in the Washington, DC metropolitan area to accommodate occasional onsite activities.

Nice To Haves

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.

Responsibilities

Implement, administer, and maintain Oracle database environments, including physical design, system integration, availability management, and backup and recovery operations.
Manage database and transaction log backups, replication, notifications, and disaster recovery across Oracle RDBMS servers and remote sites.
Provide operational support for a global 24x7 OLTP database environment, including health monitoring, index maintenance, critical incident troubleshooting, and disaster recovery readiness.
Execute production-impacting activities according to operational protocols, verification procedures, and documented checklists.
Confirm backup, recovery, and data retention requirements before maintenance, cleanup, archival, or deletion actions.
Maintain operational documentation, scripts, inventories, and turnover communications.
Maintain database security and integrity controls and support Federal IT ATO processes.
Remediate high-severity CVEs and KEVs and ensure scripts, maintenance processes, and operational changes comply with approved configurations and repositories.
Apply risk awareness and quality-control practices to actions affecting production environments and critical services.
Tune SQL queries, PL/SQL packages, and database infrastructures; analyze performance and monitor database health.
Use advanced diagnostic and research methods to resolve complex issues and support Oracle RAC and Data Guard performance and availability.
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.
Develop and enforce database management policies, procedures, and standards.
Document database administration activities, incidents, troubleshooting, scripts, maintenance, and system changes in ServiceNow.
Review and validate operational scripts before execution and ensure they align with current system updates and approved procedures.
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, and research and implement emerging database technologies.

Benefits

Medical benefits
Dental insurance
Vision insurance
Life insurance
Health savings account
Short- and long-term disability
Employee assistance program (EAP)
Parental leave
401(k)
Paid time off (PTO) for vacation
Company-paid holidays
Potential eligibility for overtime, shift differential, and a discretionary bonus