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
Originally posted on Himalayas
Who can apply
Eligible countries: United States. Accepted UTC offsets: UTC-10, UTC-9, UTC-8, UTC-7, UTC-6, UTC-5, UTC+14. Review the full description for employer-specific work authorization, residency and schedule requirements.