Remote Oracle DBA with Secret Clearance

Horizon Industries; United States; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Healthcare benefits

401k with employer match

Educational Assistance

Student Loan Repayment Program

Gym Reimbursement

Paid Time Off

Job summary

Horizon Industries Limited in the Washington, DC area is seeking a Database Administrator for a remote, USA-based role requiring an active Secret Clearance. The position focuses on Oracle database administration for IDEAS O&M and NG, including security, migrations, and data design collaboration with Appian.

The role demands extensive Oracle expertise, security compliance, and ability to coordinate with DISA hosting teams.

Qualifications

• 5+ years as a production Oracle Database Administrator on a currently supported Oracle release.
• Advanced SQL and PL/SQL, and working knowledge of MySQL or MariaDB SQL.
• Oracle backup and recovery using RMAN, and performance tuning using AWR and ASH.
• Hands-on data migration experience, including source-to-target mapping, transformation scripting, and reconciliation of migrated records.
• Oracle Database STIG implementation in a DoD Risk Management Framework environment.
• Experience on at least two projects in a large organization administering, operating, maintaining, and securing a large-scale database.

Responsibilities

• Install, maintain, and tune the Oracle database instances supporting IDEAS, in coordination with the hosting provider and DISA database administrators.
• Define and maintain database security standards, and manage database access.
• Lead troubleshooting of database-related outages, and monitor and manage disaster recovery services.
• Analyze 'worst actor' database processes, structures, and configurations, and provide concise, actionable recommendations.
• Test Oracle security patches and version upgrades, and make required configuration updates in coordination with the ISSO.
• Create and deploy database scripts for each IDEAS release, and maintain refresh schedules that identify agency interdependencies.
• Validate database security posture against ACAS and HBSS results, complete Oracle Database STIG checklist reviews, and apply IAVA patches.
• Coordinate through Enterprise Change Requests where DISA or the hosting provider controls database components.
• Support IDEAS NG data design with the Appian development team, including database schemas delivered each sprint and the data models behind Appian record types.
• Analyze, map, script, and validate the migration of legacy contract data from IDEAS O&M into IDEAS NG, including support for the Government’s legacy contract migration strategy and migration utility.
• Support data integration between IDEAS and connected systems, including the Data Integration layer that stores its data schemas in the IDEAS database.

Skills

Advanced SQL & PL/SQL

Data migration experience

Production Oracle DBA

Experience with large organizations

Tools

Oracle

RMAN

AWR/ASH

MySQL/MariaDB

Appian data stores

Appian Cloud

Job description

Horizon Industries Limited in the Washington, DC area is seeking a Database Administrator for a remote, USA-based role requiring an active Secret Clearance. The position focuses on Oracle database administration for IDEAS O&M and NG, including security, migrations, and data design collaboration with Appian.

The role demands extensive Oracle expertise, security compliance, and ability to coordinate with DISA hosting teams.