Sr. Oracle Enterprise DBA

Overview

On Site
Hybrid
$65 - $85
Contract - Independent
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

Oracle Enterprise Manager
SQL Tuning
SQL
Oracle Data Guard
Oracle
Optimization
Migration
Database Administration
Data Compression
Computer Hardware
GRID

Job Details

Our team seeks qualified candidates to provide Oracle Enterprise DBA services to our client, in support of diverse development, UAT, and production environments.

Tasks and Duties:

Oracle Enterprise Manager Upgrade & Hardware Refresh

  • Upgrade OEM 13.5 to OEM 24AI
  • Coordinate hardware refresh activities to migrate Oracle/Grid 19c implementation from old hardware to new hardware
  • Implementation of Active DataGuard configuration

Performance Tuning & Optimization

  • Implement table partitioning strategies to improve query performance and manage large datasets efficiently.
  • Capture SQL Tuning Sets for nightly batch cycles and execute SQL Tuning Advisor for optimization.
  • Tune OS parameters (e.g., kernel semaphores, huge pages, transparent pages) for optimal database performance.
  • Optimize SGA/PGA memory management to enhance database efficiency.
  • Review and fine-tune SQLNET.ora configuration for secure and efficient communication.
  • Analyze and adjust UNDO/Flashback settings for effective transaction management.
  • Evaluate and modify non-default database parameters for optimal performance.
  • Conduct AWR workload reviews to identify performance bottlenecks and suggest optimizations.
  • Implementation of Oracle Advanced Compression and Oracle Database In-Memory features
  • Advanced Compression
  • AWR/ADDM analysis

Query & Workload Optimization

  • Optimize long-running queries using indexing, hints, partitioning, and query restructuring techniques.
  • Review optimizer statistics to ensure accurate execution plans.
  • Capture and analyze SQL execution plans to enhance database performance.

Data Management & Migration

  • Perform POC for Migrating Data Warehouse to a 32K block size for improved I/O performance.
  • Active Directory Integration for Database Authentication

Please be sure to fill out provided questionnaire. Applications with incomplete questionnaires will not be considered. Further, when filling out the questionnaire, please refrain from using terms such as negotiable, open, market, etc..., we have limited time to fill this position and may not be able to follow-up/ consider all applications that are not specific.

Please click "Apply Now" button, below, to apply for this job.
We will contact qualified candidates after review.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About DataPlus Technologies, Inc