Database Engineer

RPMGlobal; Washington (District of Columbia); Hybrid; USD 120.000 - 150.000; Vollzeit

Zusammenfassung

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 19c, with strong on‑premises and AWS RDS experience, and will implement robust backup/restore, security hardening, and disaster recovery procedures.

You will collaborate with Java developers to optimize DB interactions, support SAP BI reporting, and ensure seamless integration with Apache Solr indexing

Qualifikationen

• Experience administering Oracle 19c databases in production environments.
• Experience with on-premises and AWS RDS Oracle deployments.
• Ability to design and implement enterprise database schemas.
• Proven skills in performance tuning and optimization.
• Experience backing up and restoring Oracle databases.
• Knowledge of Oracle security hardening measures.
• Experience with patch management and upgrades for Oracle databases.
• Ability to optimize DB interactions with Java applications and integrate with Solr.

Aufgaben

• Create and manage Oracle 19c databases in on-premises and AWS RDS.
• Design and implement schemas to support application needs.
• Tune database performance and optimize queries.
• Execute patching and upgrade tasks for Oracle DBs.
• Establish robust backup and restore procedures.
• Apply Oracle security hardening measures.
• Ensure data integrity and availability across environments.
• Develop disaster recovery plans and test them.
• Optimize Java application interactions with the database.
• Support SAP BI reporting and queries.
• Ensure integration with Apache Solr indexing processes.
• Implement government-compliance controls (FISMA, FedRAMP).
• Deploy and maintain database monitoring tools.
• Troubleshoot complex production issues and document solutions.

Kenntnisse

Oracle 19c DBA

On-premises & AWS RDS

Database schema design

Java DB integration

Backup & restore procedures

Oracle security hardening

Patching & upgrades

FISMA/FedRAMP compliance knowledge

Tools

Oracle Enterprise Manager

Apache Solr integration

SAP BI

Jobbeschreibung

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.