Oracle Database Administrator (DBA)

Description

The role supports mission-critical medical readiness systems in a Department of Defense environment, with the company's Oracle database work covering administration, engineering, security and performance tuning for enterprise applications.

The work centres on integrating, validating, exchanging and reporting medical readiness data across several DoD and Navy systems.

The team relies on you to keep Oracle RDBMS environments reliable, available, accurate, scalable and secure.

You will work with application developers, cybersecurity staff and technical stakeholders on database modernization and day-to-day operational needs.

Responsibilities

• Administer, configure, maintain, upgrade and tune Oracle Database and Oracle RDBMS environments.
• Support data integration and reporting for medical readiness across TMIP, EHR, DEERS, CDS, LIMDU, MRRS, NSIPS and PDHRA.
• Set up and maintain database security policies, audit controls, roles, user permissions and access privileges.
• Design and keep up to date conceptual, logical and physical Oracle data models for operational and business needs.
• Improve database performance through SQL tuning, indexing, partitioning, materialized views and tablespace management.
• Install, configure, upgrade and patch Oracle Database software and its supporting components.
• Run backup, restore, archival and recovery work with Oracle Recovery Manager (RMAN) and archived redo logs.
• Plan capacity, manage storage, monitor databases and analyse performance trends.
• Handle database cloning, refreshes and migrations between development, testing, staging and production.
• Work with application, infrastructure, cybersecurity and operations teams to keep databases interoperable and available.
• Review, troubleshoot and maintain SQL, PL/SQL packages, stored procedures, functions, triggers, database jobs, batch scripts and PowerShell scripts.
• Support application releases, schema changes, code migrations, patches and break/fix work.
• Write and maintain technical documentation such as architecture diagrams, data dictionaries, configuration standards and procedures.
• Find and deliver changes that improve database performance, scalability, security and reliability.
• Keep up with Oracle database technology, security practices and industry standards.

Requirements

• You must be a U.S. Citizen.
• You must hold an active Department of Defense (DoD) Top Secret/Sensitive Compartmented Information (TS/SCI) security clearance.
• You have proven experience administering, maintaining, securing and tuning Oracle Database and Oracle RDBMS environments.
• You have a strong grasp of Oracle architecture, installation, configuration, patching, upgrades and performance tuning.
• You have built, debugged and maintained SQL, PL/SQL, stored procedures, functions, triggers and database jobs.
• You have worked on Oracle backup, recovery, archival and restore procedures, including RMAN.
• You understand medical readiness data flows and source systems such as TMIP, EHR, DEERS, CDS, LIMDU, MRRS, NSIPS and PDHRA.
• You have supported database integration, data exchange, validation, reporting and interoperability with enterprise applications.
• You have designed and tuned Oracle structures such as indexes, partitions, materialized views and tablespaces.
• You know database security, auditing, access control, high availability and disaster recovery practices.
• You have supported development, testing, staging and production database environments.
• You communicate clearly, troubleshoot methodically and write good technical documentation.
• Desired: You have supported DoD, Navy Medicine, military healthcare or federal medical readiness information systems.
• Desired: You have worked on Oracle performance monitoring, capacity planning, storage optimization and modernization initiatives.
• Desired: You are familiar with PowerShell, batch scripting, middleware, web services and enterprise job scheduling tools.
• Desired: You know DoD cybersecurity requirements, federal information security standards and database audit controls.
• Desired: You hold Oracle Database administration certifications or other relevant technical certifications.

Conditions

This is a full-time, regular position.

Minimum clearance to start is Top Secret.

Travel is up to 10% within the continental US.

Salary depends on factors such as location, federal contract labor categories and wage rates, prior experience, skills, education and certifications.

Because the role can be based in more than one location, the advertised range is the national average.

The proposed salary range is $105,100-$231,100.

Benefits

• Competitive pay, plus learning and development opportunities.
• Flexible time off that lets you take the time you need.
• Access to broad learning resources for career growth.
• Comprehensive benefits covering healthcare, wellness, financial, retirement, family support, continuing education and time off.