Sr. Oracle Database Administrator (NIH)

PBG, LLC
Bethesda, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Bethesda, United States of America

Tech stack

Microsoft Windows
Azure
Ubuntu (Operating System)
Databases
Data Manipulation Languages
Data Mart
Oracle Data Guard
Linux
Disaster Recovery
Job Scheduling
MySQL
Oracle
Oracle Applications
Performance Tuning
Power BI
Cadence Virtuoso
Oracle APEX
Standard Sql
Recovery Manager (RMAN)
PL-SQL
SQL Databases
Software Vulnerability Management
Qliksense
Cloud Platform System
Oracle Enterprise Manager
System Availability

Job description

The Sr. Oracle Database Administrator is responsible for the availability, security, performance, and recoverability of NICHD's Oracle database environment, which supports 5 production databases across on-premises and Azure-hosted servers using Data Guard, GoldenGate replication, and multitenant architecture. This role supports the NICHD Data Mart and downstream application teams that depend on it., * Administer Oracle databases in standalone and multitenant architecture, on Windows/Linux/Unix, on-prem and in Azure cloud (Oracle 19c on Linux).

  • Maintain high availability and disaster recovery using Oracle Data Guard, RMAN backups, export/import, and GoldenGate replication and setup.
  • Perform day-to-day maintenance: backups, patching, account/role/privilege maintenance, and technology upgrades.
  • Write and tune SQL and PL/SQL; perform performance tuning and troubleshooting across production and test environments.
  • Support the NICHD Data Mart, including nightly data loads, view creation for Power BI/Qlik Sense reporting, and DDL/DML execution as required.
  • Maintain Oracle Enterprise Manager (OEM) cloud control, Connection Manager, and Oracle Apex environments.
  • Support FISMA security requirements, including patching cadence, vulnerability remediation, and SA&A documentation as needed.
  • Author and maintain Standard Operating Procedures for installation, configuration, upgrade, and troubleshooting, per the HHS Enterprise Performance Life Cycle (EPLC) framework.

Requirements

  • More than 10 years of experience conducting Oracle database administration.
  • Extensive experience administering Oracle databases in standalone and multitenant architecture on Windows/Linux/Unix, on-prem and in cloud environments.
  • Extensive experience with Oracle Data Guard, RMAN backups, export/import, GoldenGate setup and configuration, and job scheduling/monitoring.
  • Strong SQL and PL/SQL, performance tuning, and troubleshooting skills.
  • Experience with Oracle Client.

Preferred Qualifications

  • Experience with Oracle 19c, Oracle on Linux, and MySQL on Ubuntu.

#WHYPBG

Benefits & conditions

Pulled from the full job description

  • AD&D insurance
  • 401(k)
  • Health insurance
  • Paid time off
  • Vision insurance
  • Dental insurance
  • Employee assistance program, * 401K Retirement Plan
  • Medical Plan options with significant financial investments from PBG
  • Prescription benefit plan
  • Dental and Vision coverage
  • Employee Assistance Program
  • Short term / Long-term disability
  • Supplemental group life and AD&D options
  • Yearly Bonuses
  • Generous Paid Time Off / Paid Holidays
  • Career/Professional Development Program
  • Spot Bonus Program

About the company

PBG delivers mission-focused solutions that eliminate inefficiency and power transformation for federal agencies requiring agility, security, and impact.

Apply for this position