Oracle DBA – EDW & Cloud Migration

9th Way Insignia; Washington (District of Columbia); On-site; USD 76,000 - 90,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401(k)

Paid holidays

PTO

Telehealth

FSA/HSA

Job summary

9th Way Insignia in Washington, DC is seeking a Database Administrator to sustain and optimize the EDW environment. You will monitor, tune, and secure Oracle databases, implement maintenance plans, and support cloud migrations for BI tools like OBIEE.

Collaboration with developers and data analysts is essential in this role. The position requires a technical degree or equivalent experience, plus data warehousing exposure and the ability to obtain security clearance.

Qualifications

• Bachelor's degree in a technical discipline; an additional 8 years of experience can substitute for the degree.
• 1+ years of experience in Data Warehousing.
• Authorized to work in the U.S. for any employer.
• Ability to obtain and maintain required security clearance.
• Currently cleared for Public Trust at tier 2 moderate level or higher.
• Experience with Oracle GoldenGate replication issues and data sync (preferred).
• Experience with Oracle Enterprise Manager (OEM) and RMAN.
• Experience migrating Oracle DB and BI tools to Cloud environments.
• Experience implementing Oracle DB performance tuning and improvement processes.
• Experience supporting OBIEE applications.

Responsibilities

• Monitor EDW database environment; manage disk space, capacity trends, and performance.
• Support DRR activities and production implementations; manage code in Production; document changes.
• Develop, test, and implement database maintenance plans; apply patches while minimizing disruption.
• Troubleshoot slow-running SQL queries; analyze plans and tuning opportunities.
• Process database access requests; enforce security controls and encryption.
• Perform schema and table refreshes between EDW environments.
• Design and implement database schemas and models for EDW data storage and governance.
• Develop backup and recovery plans; conduct disaster recovery testing.
• Ensure data accuracy, consistency, and integrity in EDW; address data quality issues.
• Serve as primary technical resource for database issues; collaborate with dev teams on production challenges.
• Maintain comprehensive documentation of the database environment and changes.
• Collaborate with developers, data analysts, and project teams to ensure DB services support EDW goals.

Skills

Data Warehousing

Database troubleshooting

Performance tuning

Security compliance

Collaboration

Education

Bachelor's Degree in a technical Discipline

8 years of equivalent experience in lieu of degree

Tools

Oracle Enterprise Manager (OEM)

RMAN

Oracle GoldenGate

Job description

9th Way Insignia in Washington, DC is seeking a Database Administrator to sustain and optimize the EDW environment. You will monitor, tune, and secure Oracle databases, implement maintenance plans, and support cloud migrations for BI tools like OBIEE.

Collaboration with developers and data analysts is essential in this role. The position requires a technical degree or equivalent experience, plus data warehousing exposure and the ability to obtain security clearance.