Database Administrator

Horizon Industries Limited (Horizon) is a dynamic IT and Management Consulting firm based in the Washington, DC area, founded in 1996. They provide full-cycle IT Consulting and Management support in both the private and public sectors, with a culture rooted in diversity, employee-centric values, and a family-friendly approach.

The role involves supporting the Defense Information Systems Agency’s (DISA) Appian-based contract writing system, known as IDEAS. This includes managing both the current production system (IDEAS O&M) and the upcoming IDEAS Next Generation (NG), which is being built in separate Appian Government Cloud environments to modernize DISA’s telecommunications contracting.

The Database Administrator will:

• Own Oracle database administration, security, and outage response for IDEAS O&M.
• Support data design and migration of legacy contract data into IDEAS NG, working with the Appian data layer, including MariaDB data sources.

What Your Day-to-Day Will Look Like / Duties:

• Performs routine project tasks for specialized information assurance problems.
• Integrates electronic processes or methodologies to resolve system or technology problems related to information assurance requirements.
• Analyzes information security requirements.
• Applies analytical and systematic approaches to workflow, organization, and planning.
• Provides security engineering support for planning, design, development, testing, demonstration, and integration of information systems.

Responsibilities:

• Install, maintain, and tune Oracle database instances supporting IDEAS, coordinating 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 disaster recovery services.
• Analyze database processes, structures, and configurations, providing concise, actionable recommendations.
• Test Oracle security patches and version upgrades, making required configuration updates in coordination with the ISSO.
• Create and deploy database scripts for each IDEAS release and maintain refresh schedules.
• 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 and data models behind Appian record types.
• Analyze, map, script, and validate migration of legacy contract data from IDEAS O&M into IDEAS NG.
• Support data integration between IDEAS and connected systems, including the Data Integration layer.

Required 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.

Preferred Qualifications:

• Oracle high availability experience, including RAC and/or Data Guard.
• Experience with Appian data stores, Appian record types and data sync, or connecting external databases to Appian Cloud.
• Experience with databases in managed cloud environments (e.g., Appian Cloud, AWS GovCloud, Amazon RDS).
• Prior DISA or IDEAS experience.
• Oracle Certified Professional (OCP).
• Familiarity with Splunk or comparable log analysis tools.