Senior Oracle Exadata DBA

vTech Solution; Washington (District of Columbia); In loco; USD 140.000 - 190.000; Tempo pieno

Descrizione del lavoro

vTech Solution in Washington DC seeks a Senior Oracle Exadata DBA to lead migration and ongoing administration of large Oracle 19c databases to Exadata platforms in AWS. This role supports NC FAST initiatives by optimizing Exadata for high availability, performance, and scalability.

You will plan and execute migrations, design Exadata configurations, perform tuning with AWR/ASH, manage Data Guard and GoldenGate, and collaborate with engineering teams to modernize data models for cloud-ready

Competenze

• 7+ years of experience with Oracle Exadata architecture, storage cells, InfiniBand, and HCC.
• Proven track record migrating 100+ TB Oracle databases to Exadata in cloud environments.
• Experience with ASM storage management and patching/updates.
• Strong SQL and performance tuning across DB and Exadata storage.
• Familiarity with Oracle GoldenGate and Data Guard.

Mansioni

• Lead end-to-end migration of large Oracle 19c databases to Exadata in AWS, including planning, execution, cutover, and validation.
• Design and implement Exadata-optimized configurations, storage features, and performance strategies.
• Manage Exadata environments across development, test, and production, 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 disaster recovery 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.
• Collaborate with engineering and application teams to modernize database architecture and streamline data models.

Conoscenze

Exadata architecture

SQL performance tuning

AWR/ASH analysis

AWS experience

GoldenGate replication

Data Guard HA/DR

On-call readiness

Large-scale migration

Strumenti

Oracle GoldenGate

Oracle Enterprise Manager (OEM)

Oracle Data Guard

Descrizione del lavoro

Job Summary:

The Senior Oracle Exadata DBA will lead the migration and ongoing administration of large Oracle 19c databases to Oracle Exadata platforms within AWS environments. This role supports the North Carolina Families Accessing Services through Technology (NC FAST) initiative by optimizing, tuning, and managing Exadata systems to ensure high availability, performance, and scalability for critical applications.

Responsibilities:

• Lead end-to-end migration of large Oracle 19c databases (100+ TB) 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 across development, test, and production, 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 disaster recovery 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.


• Collaborate with engineering and application teams to modernize database architecture and streamline data models.

Required Skills & Certifications:

• 7+ years of experience with Oracle Exadata architecture, including storage cells, InfiniBand networking, Smart Scan, and Hybrid Columnar Compression (HCC).


• 7+ years managing storage using Oracle Automatic Storage Management (ASM) and monitoring ASM disk groups.


• 3+ years applying Exadata storage cell, compute node, and firmware patches, as well as PSU/DBRU/Release Updates.


• 3+ years of performance tuning at both database and Exadata storage layers.


• 5+ years troubleshooting complex issues across database, OS, and Exadata storage components.


• 2+ years designing database schemas, access patterns, indexing, locking strategies, and tuning Oracle databases.


• 2+ years experience with Oracle Enterprise Manager (OEM) or Cloud Control for monitoring and diagnostics.


• 2+ years experience installing, configuring, troubleshooting, and maintaining Oracle GoldenGate replication.


• 5+ years strong SQL writing skills.


• 5+ years participation in on-call rotation and weekend work.


• 2+ years experience with advanced security and Oracle Data Guard replication.

Preferred Skills & Certifications:

• Experience working in cloud environments, specifically AWS.


• Familiarity with modernizing database architecture and streamlining data models for mission-critical systems.


• Knowledge of best practices for operating Oracle Exadata within AWS.

Special Considerations:

• Must participate in on-call rotation and be available for weekend work.


• All work must be completed on-site once COVID restrictions are lifted.


• Absences greater than two weeks require prior approval and must provide contact information for reachability.


• Strict compliance with client requirements regarding subcontracting and outsourcing disclosures.

Scheduling:

• Work schedule includes standard business hours with required availability for on-call support and weekend work.


• Assignment duration from October 26, 2026, through May 12, 2027.