Job description

Database Administrator Location: Remote, USA Type --- Future Opportunities -- Proposal 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 Gym Reimbursement 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

Requirements

Must-haves

Database Administrator
Location: Remote, USA
Type --- Future Opportunities -- Proposal
Security Clearance: Must possess an active Secret Clearance.
_______________________________________________________________
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.
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

Nice-to-haves

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

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlaws

Platform: greenhouse
Effort: quick

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Paid Time Off