Senior Oracle DB Architect: Modernization & Cloud

ROI Solutions; Yorktown (VA); Remote; USD 120,000 - 180,000; Full time

Job summary

ROI Solutions is seeking a Senior Oracle Database Administrator to lead strategy and modernization of our Oracle environment. You will drive architecture, standards, and security while improving performance, observability, and resilience in collaboration with Product Reliability, Security Engineering, Product, and our services partner.

You will own the multi-year roadmap for capacity, modernization, and cloud adoption, oversee high availability, DR planning, and SQL optimization, and mentor

Qualifications

• 8+ years of Oracle database administration experience in production environments.
• Advanced experience with Oracle performance tuning, SQL optimization, and query-plan analysis.
• Strong knowledge of Oracle technologies including RAC, Data Guard, RMAN, ASM, Exadata, and partitioning.
• Working familiarity with PL/SQL to review, troubleshoot, and advise on database-resident code.
• Strong relational database architecture, design, and data-modeling skills.
• Experience with backup, recovery, high availability, and disaster-recovery planning and testing.
• Experience with database security, auditing, access management, and PCI-compliant environments.
• Ability to diagnose complex performance and reliability issues across applications and database infrastructure.
• Strong communication, collaboration, prioritization, and mentoring skills.

Responsibilities

• Set database architecture standards across ROI’s products and platforms.
• Own the multi-year roadmap for capacity, technical debt, and database modernization.
• Evaluate database technologies and cloud services based on reliability, scalability, security, and cost.
• Provide senior technical ownership for Oracle production and non-production environments.
• Lead performance tuning, SQL optimization, capacity planning, and troubleshooting with developers.
• Strengthen monitoring, backup, recovery, high availability, and disaster-recovery practices.
• Lead root-cause analysis for significant incidents and participate in a shared on-call rotation.
• Define practical standards for database architecture, design, SQL development, documentation, and operations.
• Review significant schema changes, migrations, procedural objects, and database designs.
• Partner with engineering teams to improve database quality and performance throughout the development lifecycle.

Skills

Oracle DBA

Performance tuning

RAC

Data Guard

RMAN

ASM

Exadata

SQL optimization

PL/SQL

Security & PCI

Tools

Datadog

Job description

ROI Solutions is seeking a Senior Oracle Database Administrator to lead strategy and modernization of our Oracle environment. You will drive architecture, standards, and security while improving performance, observability, and resilience in collaboration with Product Reliability, Security Engineering, Product, and our services partner.

You will own the multi-year roadmap for capacity, modernization, and cloud adoption, oversee high availability, DR planning, and SQL optimization, and mentor