Database Administrator (DISA)

The role

The Database Administrator supports IDEAS O&M and IDEAS NG systems. This role involves Oracle database administration, security, outage response, data design, and legacy data migration.

What you will do

• Install, maintain, and tune Oracle database instances.
• Define and maintain database security standards and manage access.
• Lead troubleshooting of database-related outages and manage disaster recovery services.
• Analyze database processes, structures, and configurations.
• Test Oracle security patches and version upgrades.
• Create and deploy database scripts and maintain refresh schedules.
• Validate database security posture and complete Oracle Database STIG checklist reviews.
• Coordinate through Enterprise Change Requests.
• Support IDEAS NG data design with the Appian development team.
• Analyze, map, script, and validate the migration of legacy contract data.

Required qualifications

• 5+ years as a production Oracle Database Administrator on a currently supported Oracle release
• Advanced SQL and PL/SQL
• Working knowledge of MySQL or MariaDB SQL
• Oracle backup and recovery using RMAN
• 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
• Must possess an active Secret Clearance

Nice to have

• 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

Benefits

• Healthcare (medical, dental, vision, and disability)
• 401k program with 100% vesting from day one and employer match after 90 days
• Educational Assistance program
• Student Loan Repayment Program
• Gym Reimbursement Program
• Paid Time off

About the company

Horizon Industries Limited (Horizon) is a dynamic IT and Management Consulting firm based in the Washington, DC area. Founded in 1996, it provides full-cycle IT Consultant and Management support in both the private and public sectors.