Senior Oracle with Exadata DBA

Location: Raleigh, NC (Hybrid)

Duration: 12 months | Visa: H1B, H4EAD, USC, GC, GCEAD | Healthcare domain required | 12 years of experience required

Responsibilities

• Manage and maintain Oracle database environments (development, test, production) running on Exadata and Linux in AWS.
• Collaborate with application developers to define data requirements, design tables and schemas, and assist with SQL development and optimization.
• Support application modernization efforts by providing robust, scalable database solutions.
• Lead the design, implementation, and management of application schemas, database structures, and extensions.
• Provide technical support for Oracle databases, including diagnosis and resolution of performance, configuration, and availability issues.
• Develop and maintain procedures, standards, and best practices for database operations in cloud environments.
• Administer high availability and disaster recovery configurations using Oracle Data Guard.
• Implement and manage replication solutions such as Oracle GoldenGate.
• Perform database performance tuning, query optimization, and resource management for high-volume workloads.
• Conduct regular database backups, restores, patching, and upgrades.

Skills

• Deep understanding of Oracle Exadata architecture.
• Experience managing storage using Oracle Automatic Storage Management (ASM) and monitoring ASM disk groups.
• Hands-on experience installing, patching, and upgrading Oracle Database software and related components (Exadata patches, PSU/DBRU/Release Updates).
• Experience with performance tuning at both database and Exadata storage layer.
• Demonstrable expertise in designing database schemas, access patterns, indexing, locking strategies, and tuning Oracle databases.
• Ability to troubleshoot complex issues across database, OS, and Exadata storage components.
• Experience with OEM (Oracle Enterprise Manager) or Cloud Control for monitoring and diagnostics.
• Strong SQL writing skills.