Database Engineer

RPMGlobal; Reston (VA); On-site; USD 120,000 - 180,000; Full time

Job summary

Base-2 Solutions is seeking an experienced Database Engineer to support modernization of a critical government information system. The role focuses on Oracle 19c administration in on-prem and AWS RDS, with schema design, performance tuning, and robust backup/restore procedures to ensure data integrity and availability.

You will collaborate with Java developers, support SAP BI reporting needs, and ensure seamless integration with Apache Solr indexing.

Qualifications

• Experience administering Oracle 19c databases in production environments.
• Experience with Oracle DBA in on-premises and AWS RDS.
• Designing and implementing enterprise database schemas.
• Performance tuning and optimization techniques.
• Backup and restore procedures for Oracle databases.
• Oracle security hardening measures.
• Patch management and upgrades for Oracle databases.
• Java app integration with databases.
• Experience with Apache Solr integration.
• Experience with government compliance controls (FISMA/FedRAMP).
• Database monitoring tools deployment and use.
• Creating and maintaining technical documentation.

Responsibilities

• Create and manage Oracle 19c databases in on-premises and AWS RDS.
• Design schemas to support application requirements.
• Perform database performance tuning and optimization.
• Execute patch management and upgrades for Oracle databases.
• Establish robust backup and restore procedures.
• Implement Oracle security hardening measures.
• Ensure data integrity and availability across environments.
• Develop and test disaster recovery plans.
• Optimize DB interactions with Java components.
• Support SAP BI reporting and queries.
• Integrate with Apache Solr indexing processes.
• Implement compliance controls (FISMA, FedRAMP).
• Deploy and maintain database monitoring tools.
• Troubleshoot complex production issues.
• Create comprehensive technical documentation.

Skills

Oracle 19c DBA

On-prem & AWS RDS

Schema design

Performance tuning

Backup & recovery

Security hardening

Patch management

Java integration

SAP BI integration

Solr indexing

Compliance controls

Monitoring tools

Technical documentation

Education

Bachelor's degree with 9 years

Master's degree with 7 years

No degree with 13+ years

Tools

Apache Solr

SAP BI

Job description

Position Summary

Base-2 Solutions is 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. The role includes database creation, schema design and implementation, performance tuning, and establishing robust backup and restore procedures to ensure data integrity and availability. The candidate 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.

Essential Duties and Responsibilities

• 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.
• 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.
• Optimize database interactions with Java application components.
• Support SAP Business Intelligence reporting requirements and queries.
• Ensure seamless integration with Apache Solr indexing processes.
• 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.

Required Qualifications

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

Preferred Qualifications

• Plan and execute database migration strategies from on-premises VMware to AWS RDS.
• Experience supporting Business Intelligence reporting requirements (SAP Business Intelligence preferred).

Required Education and Experience Equivalency

• Bachelor's degree with 9 years of experience.
• Master's degree with 7 years of experience.
• No degree with 13+ years of experience.

Required Certifications

• None specified.

Required Security Clearance

• Active Top Secret/SCI with CI Polygraph