Oracle Exadata Applications DBA (15+)
About The Position
The Department of Health and Human Services (DHHS) seeks a Senior Exadata Applications DBA to support migration and development for applications used by North Carolina Families Accessing Services through Technology (NC FAST). The role leads migration of large Oracle 19c databases (100+ TB) from standard AWS environments to Oracle Exadata in AWS. It administers, optimizes, and supports Exadata platforms across development, test, and production environments, with a focus on performance, scalability, and reliability. The DBA works with engineering and application teams to modernize database architecture, streamline data models, and apply best practices for mission-critical systems on Exadata within AWS. The position is hybrid/local in Raleigh, North Carolina, and has a stated duration of seven months. The role requires participation in an on-call rotation and weekend work.
Requirements
- Deep understanding of Oracle Exadata architecture, including storage cells, InfiniBand networking, Smart Scan, and Hybrid Columnar Compression (HCC); 7 years required.
- Experience managing storage with Oracle Automatic Storage Management (ASM) and monitoring ASM disk groups; 7 years required.
- Experience applying Exadata storage cell, compute node, and firmware patches, as well as database-level PSU/DBRU/Release Updates; 3 years required.
- Experience tuning performance at both the database and Exadata storage layers; 3 years required.
- Ability to troubleshoot complex issues across database, operating system, and Exadata storage components; 5 years required.
- Expertise in database schema design, access patterns, indexing, locking strategies, and Oracle database tuning; 2 years required.
- Experience with OEM (Oracle Enterprise Manager) or Cloud Control for monitoring and diagnostics; 2 years required.
- Experience installing, configuring, troubleshooting, and maintaining GoldenGate; 2 years required.
- Strong SQL writing skills; 5 years required.
- Experience participating in an on-call rotation and working weekends; 5 years required.
- Experience with advanced security and Oracle Data Guard replication; 2 years required.
Responsibilities
- Lead end-to-end migration of large Oracle 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 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.
- Manage storage using Oracle Automatic Storage Management (ASM) and monitor ASM disk groups.
- Apply Exadata storage cell, compute node, firmware, and database-level PSU/DBRU/Release Update patches.
- Participate in an on-call rotation and perform weekend work.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
Education Level
No Education Listed
