Senior Oracle Database Administrator

JRH Consultants
Bethesda, United States of America
7 days ago

Role details

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

Job location

Remote
Bethesda, United States of America

Tech stack

Microsoft Windows
Application Integration Architecture
User Authentication
Backup Devices
Unix
Ubuntu (Operating System)
Configuration Management
Databases
System Configuration
Data Integration
Data Manipulation Languages
Data Mart
Data Synchronization
Database Connection
Oracle Data Guard
Linux
Disaster Recovery
Monitoring of Systems
Job Scheduling
MySQL
Oracle
Oracle Applications
Oracle Warehouse Builder
Performance Tuning
Power BI
Recovery Manager (RMAN)
Runbook
SQL Stored Procedures
PL-SQL
SQL Databases
Web Services
Cloud Platform System
Sql Optimization
Indexer
Information Technology
QlikView
Tools for Reporting
Application Client

Job description

JRH is seeking a Senior Oracle Database Administrator to administer, secure, optimize, monitor, and support enterprise Oracle database environments for a federal health research customer. The role supports development, test, and production databases across on-premises and cloud environments and requires advanced expertise in standalone and multitenant architecture, Data Guard, RMAN, Data Pump, GoldenGate, SQL and PL/SQL, performance tuning, troubleshooting, security, backup, recovery, and data integration., · Administer Oracle databases in development, test, staging, disaster-recovery, and production environments.

· Support standalone and multitenant Oracle architectures across Windows, Linux, Unix, on-premises, and cloud environments.

· Install, configure, patch, upgrade, secure, monitor, and troubleshoot Oracle database software, clients, listeners, and supporting components.

· Design, implement, maintain, monitor, and troubleshoot Oracle Data Guard configurations and high-availability capabilities.

· Configure and administer Oracle GoldenGate replication, data synchronization, and related monitoring.

· Plan, execute, validate, and document RMAN backups, restores, point-in-time recovery, disaster-recovery testing, and recovery procedures.

· Perform Oracle Data Pump export/import, schema migration, data refresh, DDL/DML deployment, and environment synchronization activities.

· Write, review, optimize, and troubleshoot SQL, PL/SQL, stored procedures, packages, functions, triggers, views, and database jobs.

· Perform performance analysis and tuning using execution plans, indexing, statistics, memory configuration, wait events, workload data, and monitoring tools.

· Configure and monitor job scheduling, database health, replication status, storage, capacity, resource use, availability, and daily operational processes.

· Manage database users, roles, privileges, service accounts, authentication, auditing, encryption, and security configuration.

· Support application integrations, web services, external federal systems, data marts, reporting platforms, and business-intelligence tools such as Power BI or Qlik.

· Troubleshoot complex database, connectivity, client, performance, replication, backup, recovery, and production incidents.

· Develop and maintain database architecture documentation, standard operating procedures, runbooks, backup/recovery plans, and operational records.

· Support federal security, privacy, vulnerability-remediation, configuration-management, change-control, and audit requirements.

· Provide capacity planning, architecture recommendations, technical leadership, mentoring, and knowledge transfer.

Requirements

· More than 10 years of Oracle database-administration experience.

· Extensive experience administering Oracle databases in standalone and multitenant architectures.

· Extensive experience administering Oracle databases on Windows, Linux, or Unix in both on-premises and cloud environments.

· Extensive experience implementing and maintaining Oracle Data Guard.

· Extensive experience with RMAN backup and recovery, Oracle export/import or Data Pump, Oracle GoldenGate, and database job scheduling and monitoring.

· Advanced SQL and PL/SQL skills.

· Strong database-performance tuning and troubleshooting skills.

· Experience installing, configuring, or troubleshooting Oracle client software and database connectivity.

· Strong security, documentation, incident-response, communication, and customer-support skills.

Preferred Qualifications:

· Bachelor's degree in computer science, information technology, engineering, or a related field; equivalent relevant experience may be considered.

· Experience with Oracle Database 19c.

· Experience administering Oracle on Linux.

· Experience administering MySQL on Ubuntu.

· Experience supporting federal systems, data marts, reporting platforms, or cloud-hosted databases.

Work Requirements:

· Ability to satisfy federal background, suitability, identity-credentialing, and system-access requirements.

· Ability to work remotely within the United States and attend occasional onsite meetings in Bethesda, Maryland.

· Ability to protect sensitive government information and comply with applicable federal security, privacy, records-management, and acceptable-use requirements.

· Availability during regular business hours and, when needed, for scheduled releases, maintenance activities, or urgent production support.

Benefits & conditions

$125,000 - $150,000 a year - Full-time, Contract, Pulled from the full job description

  • Health insurance
  • Retirement plan
  • Paid time off
  • Vision insurance
  • Dental insurance, * Dental insurance
  • Health insurance
  • Paid time off
  • Retirement plan
  • Vision insurance

Apply for this position