Database Engineer

Red Arch Solutions; Maryland; On-site; USD 150,000 - 205,000; Full time

Job summary

Red Arch Solutions seeks a Database Engineer to modernize a government information system. You will administer Oracle 19c databases on-premises and in AWS RDS, design schemas, tune performance, and implement backup/restore procedures to ensure data integrity.

You will collaborate with Java developers, support SAP BI reporting, and ensure integration with Apache Solr for indexing, while maintaining security controls and documentation to meet FISMA/FedRAMP requirements and TS/SCI eligibility.

Qualifications

• 13+ years of IT or systems experience in related roles.
• Bachelor’s degree may substitute for 4 years of experience; Master’s for 6 years.

Responsibilities

• Create and manage Oracle 19c databases in on-premises and AWS RDS environments.
• Design and implement database schemas to support application requirements.
• Perform database performance tuning and optimization.
• Execute patch management and version upgrades for Oracle databases.
• Establish and maintain robust backup and restore procedures.
• Implement Oracle database security hardening measures.
• Support SAP BI reporting requirements and queries.
• Ensure integration with Apache Solr indexing processes.
• Develop and maintain comprehensive technical documentation.
• Obtain and maintain required security clearance.

Skills

Oracle 19c

Production DB admin

AWS RDS

DB performance tuning

Backup & recovery

Security hardening

Patch management

Java integration

Solr indexing

Compliance & governance

Technical documentation

TS/SCI readiness

Education

Bachelor's degree in IT or related field

Master's degree substitution for experience

Tools

Apache Solr

SAP BI

AWS RDS

Oracle tooling

Job description

Red Arch is hiring a Database Engineerto join our team!

Position Detail:

We are seeking an experienced Database Engineer to support the modernization of a critical government information system. The ideal candidate will have deep expertise in Oracle database administration, specifically Oracle 19c, with proven experience in both on-premises and AWS RDS environments. You will be responsible for database creation, schema design and implementation, performance tuning, and establish robust backup and restore procedures to ensure data integrity and availability. You will work closely with Java developers to optimize database interactions, support SAP Business Intelligence reporting requirements, and ensure seamless integration with Apache Solr indexing processes. This role requires meticulous attention to detail, the ability to troubleshoot complex database issues in production environments, and strong documentation skills.

Position Responsibilities

Database Administration:

• Create and manage Oracle 19c databases in both on-premises and AWS RDS environments
• Design and implement database schemas to support application requirements
• Perform database performance tuning and optimization
• Execute patch management and version upgrades for Oracle databases

Data Protection & Security:

• Establish and maintain robust backup and restore procedures
• Implement Oracle database security hardening measures
• Ensure data integrity and availability across all environments
• Develop and test disaster recovery plans

Migration & Integration:

• Optimize database interactions with Java application components
• Support SAP Business Intelligence reporting requirements and queries
• Ensure seamless integration with Apache Solr indexing processes

Compliance & Monitoring:

• Implement compliance controls for government systems (FISMA, FedRAMP, or similar)
• Deploy and maintain database monitoring tools
• Troubleshoot complex database issues in production environments
• Create and maintain comprehensive technical documentation
• Obtain and maintain required security clearance

Education and Experience:

13+ Years of experience in Systems or IT related roles or a highly related field of work with similar scope and responsibilities.

A Bachelor’s degree may be substituted for 4 years of experience and a Master’s Degree may be substituted for 6 years of experience

Required Quals:

• Experience administering Oracle 19c databases in production environments
• Experience with Oracle database administration in both on-premises and AWS RDS environments
• Experience designing and implementing database schemas for enterprise applications
• Experience with database performance tuning and optimization techniques
• Experience establishing and maintaining backup and restore procedures for Oracle databases
• Experience implementing Oracle database security hardening measures
• Experience with patch management and version upgrades for Oracle databases
• Experience optimizing database interactions with Java applications
• Experience integrating databases with search/indexing platforms (Apache Solr experience preferred)
• Experience troubleshooting complex database issues in production environments
• Experience implementing compliance controls for government systems (FISMA, FedRAMP, or similar frameworks)
• Experience deploying and maintaining database monitoring tools
• Experience in creating and maintaining technical documentation for database systems
• Ability to obtain and/or maintain a TS/SCI government clearance which requires US Citizenship

Desired Quals:

• TS/SCI with an in-scope polygraph
• Plan and execute database migration strategies from on-premises VMware to AWS RDS
• Experience supporting Business Intelligence reporting requirements (SAP BI preferred)

Work locations:

Annapolis Jct. MD, Washington DC, or Reston VA.

Salary range for this position:

$150,000-205,000 #CJ