Senior Oracle Exadata DBA

VIVA USA Inc; Durham (NC); Hybrid; USD 160,000 - 230,000; Full time

Benefits offered by this job

Hybrid work arrangement

Equal opportunity employer

Job summary

VIVA USA Inc. is seeking a Senior Exadata Applications DBA to lead the migration of large Oracle 19c databases to Oracle Exadata in AWS.

You will optimize, administer, and support Exadata platforms across development, test, and production environments to ensure high performance and reliability for a broad portfolio of applications. The role requires deep Oracle Exadata knowledge, strong performance tuning, and experience with Data Guard and GoldenGate.

Qualifications

• Deep understanding of Oracle Exadata architecture, including storage cells, InfiniBand networking, Smart Scan and Hybrid Columnar Compression (HCC).
• Experience with ASM storage management and monitoring of ASM disk groups.
• Proficiency in applying Exadata storage cell, compute node, and firmware patches, along with PSU/DBRU/Release Updates.
• Experience with performance tuning at both database and Exadata storage layer.
• Ability to troubleshoot complex issues across database, OS, and Exadata storage components.
• Expertise in designing database schemas, access patterns, indexing, locking strategies, and tuning Oracle databases.
• Experience with OEM (Oracle Enterprise Manager) or Cloud Control for monitoring and diagnostics.
• Experience in Install, configure, and troubleshoot/maintain Golden Gate.
• Strong experience in SQL writing skills.
• Participate in on-call rotation and weekend work.
• Experience with advanced security and Oracle DataGuard replication.

Responsibilities

• Lead end-to-end migration of large 19c databases to Oracle Exadata in AWS, including planning, execution, cutover, and validation.
• Design and implement Exadata-optimized database configurations, storage features, and performance strategies.
• Manage Oracle Exadata environments (dev/test/prod), including schema design, data modeling, and SQL optimization.
• Perform advanced performance tuning using AWR/ASH analysis, indexing, partitioning, and resource management.
• Administer high-availability and DR configurations using Oracle Data Guard.
• Implement and manage replication solutions such as Oracle GoldenGate.
• Troubleshoot performance, configuration, and availability issues across Exadata and Linux platforms.
• Execute backups, restores, patching, and upgrades for Exadata environments.

Skills

Oracle Exadata architecture

AWR/ASH performance tuning

SQL performance tuning

Oracle Data Guard HA/DR

GoldenGate replication

ASM storage management

Patching and upgrades (PSU/DBRU)

Linux administration

Capacity planning

AWS Exadata migration planning

Tools

Oracle Enterprise Manager (OEM)

GoldenGate

RMAN / Data Guard tooling

Job description

The client requires a Senior Exadata Applications DBA to support the migration and development support of various applications for the client.

The client is seeking an experienced Oracle Exadata DBA to lead the migration of large Oracle 19c databases (100+?TB) from standard AWS environments to Oracle Exadata in AWS. This role is responsible for optimizing, administering, and supporting Exadata platforms across development, test, and production environments, ensuring high performance, scalability, and reliability for a large portfolio of applications.

The DBA will work closely with engineering and application teams to modernize database architecture, streamline data models, and implement best practices for operating mission-critical systems on Exadata within AWS.

Key responsibilities:

• Lead end-to-end migration of large 19c databases to Oracle Exadata in AWS, including planning, execution, cutover, and validation.
• Design and implement Exadata-optimized database configurations, storage features, and performance strategies.
• Manage Oracle Exadata environments (dev/test/prod), including schema design, data modeling, and SQL optimization.
• Perform advanced performance tuning using AWR/ASH analysis, indexing, partitioning, and resource management.
• Administer high-availability and DR configurations using Oracle Data Guard.
• Implement and manage replication solutions such as Oracle GoldenGate.
• Troubleshoot performance, configuration, and availability issues across Exadata and Linux platforms.
• Execute backups, restores, patching, and upgrades for Exadata environments.

Skill - Required / Desired - Amount of Experience

• Deep understanding of Oracle Exadata architecture, including storage cells, InfiniBand networking, Smart Scan and Hybrid Columnar Compression (HCC) - Required - 7 Years
• Experience managing storage using Oracle Automatic Storage Management (ASM) and monitoring ASM disk groups - Required - 7 Years
• Proficiency in applying Exadata storage cell, compute node, and firmware patches, along with database-level PSU/DBRU/Release Updates - Required - 3 Years
• Experience with performance tuning at both database and Exadata storage layer - Required - 3 Years
• Ability to troubleshoot complex issues across database, OS, and Exadata storage components - Required - 5 Years
• Demonstrable expertise in designing database schemas, access patterns, indexing, locking strategies, and tuning Oracle databases - Required - 2 Years
• Experience with OEM (Oracle Enterprise Manager) or Cloud Control for monitoring and diagnostics - Required - 2 Years
• Experience in Install, configure, and troubleshoot/maintain Golden Gate - Required - 2 Years
• Strong experience in SQL writing skills - Required - 5 Years
• Participate in on-call rotation and weekend work - Required - 5 Years
• Experience with advanced security and Oracle DataGuard replication - Required - 2 Years

Notes:

Hybrid

VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status