Secret-Cleared Oracle DBA for DoD Data & Appian

Horizon Industries, Limited; United States; Híbrido; USD 110.000 - 150.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Healthcare package including medical,

401k with employer match

Educational Assistance

Student Loan Repayment

Paid Time Off

Descripción de la vacante

Horizon Industries Limited is seeking an experienced Oracle Database Administrator to own Oracle DB administration, security, and outage response for IDEAS O&M and to support IDEAS NG data design and migration with Appian data layer.

You will work with Appian Cloud, MariaDB data sources, and coordinate with hosting providers and DISA, ensuring security posture and STIG reviews.

Formación

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

Responsabilidades

• 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 that consider the simplest solutions first.
• 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

Conocimientos

Oracle DBA

SQL/PLSQL

RMAN backup

AWR/ASH tuning

Data migration

Herramientas

MariaDB

Appian Data Stores

AWS GovCloud

Oracle Cloud

Descripción del empleo

Security Clearance: Must possess an active Secret Clearance.

_______________________________________________________________

Who we are:

Horizon Industries Limited (Horizon) is a dynamic IT and Management Consulting firm based in the Washington, DC area. Founded in 1996, Horizon Industries Limited (Horizon) has evolved into a company of highly qualified professionals that provides full-cycle IT Consultant and Management support in both the private and public sectors.

Horizon’s culture is based on our core values, and we PRIDE ourselves on a diverse, employee, and family-centric approach.

Who we are looking for:

IDEAS is the Defense Information Systems Agency’s Appian-based contract writing system, hosted in the Impact Level 5 Appian Government Cloud. The current production system (IDEAS O&M) connects to an Oracle database, and IDEAS Next Generation (NG) is being built in separate Appian Government Cloud environments to modernize DISA’s telecommunications contracting.

The Database Administrator supports both. For IDEAS O&M, this role owns Oracle database administration, security, and outage response. For IDEAS NG, this role supports data design and the migration of legacy contract data into the new system, working with the Appian data layer, which may include Appian Cloud’s native MariaDB data source.

What your day-to-day will look like / Duties:

• Performs a variety of routine project tasks applied to specialized information assurance problems.
• Tasks involve integration of electronic processes or methodologies to resolve total system problems, or technology problems as they relate to IA requirements.
• Analyzes information security requirements.
• Applies analytical and systematic approaches in the resolution of problems of workflow, organization, and planning.
• Provides security engineering support for planning, design, development, testing,
  demonstration, and integration of information systems.

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 that consider the simplest solutions first
• 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

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)

Splunk or comparable log analysis tools

Why you will succeed at Horizon:

Horizon works at the forefront of new features and development practices and supports its employees in being trained and certified in the latest and greatest. As we continue to expand and grow the Horizon brand around the globe, we want to ensure that our team members are growing with us as you are a vital part of our success story. This is a great opportunity for us to invest in our employees by supporting you with the right skills and tools to be successful in your careers..

Why you will love working with us/ Perks:

• A comprehensive benefits package including healthcare (medical, dental, vision, and disability)
• a 401k program where you are 100% vested from day one with an employer match after 90 days.
• an Educational Assistance program.
• a Student Loan Repayment Program
• Paid Time off
• Dynamics, passionate, multi-disciplinary team of creative minds to work with, and many more.

Horizon is an Equal Employment Opportunity employer, and it is our policy to consider all applicants for employment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.

EOE/Vet/Disabled

Create a Job Alert

Interested in building your career at Horizon Industries? Get future opportunities sent straight to your email.

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

LinkedIn Profile *

Website

Do you have an active Secret Clearance or above? * Select...

Experience with DoD or DLA contracting systems * Select...

I have read and understood Horizon’s AI Policy for Hiring and Recruitment. I agree to follow the guidelines outlined and understand that failure to do so may result in disqualification from the interview process * Select...

At Horizon, we believe in a fair, transparent hiring process built on trust, integrity, and meaningful human connection. We invite you to review our AI Policy for Hiring and Recruitment to understand how we thoughtfully and responsibly use AI, while maintaining clear expectations for candidates on the appropriate use of AI throughout the recruitment journey.

How did you hear about us? * Select...

Are you 18 years of age or older? * Select...

If you have been convicted of a crime, please explain: *

Salary Expectation *

5+yrs experience in Oracle Database Administration * Select...