Remote Senior Oracle DB Architect: Modernization Automation

ROI Solutions; Virginia; Remote; USD 150,000 - 190,000; Full time

Job summary

ROI Solutions is seeking a Senior Oracle Database Administrator to lead the strategy and evolution of our Oracle database environment. You will shape architecture, standards, and modernization efforts while focusing on performance, reliability, security, automation, observability, and cloud adoption.

You will collaborate with Product Reliability, Security Engineering, Product, and Product Engineering teams, and our managed services partner to ensure secure, scalable databases.

Qualifications

• 8+ years of Oracle database administration experience in complex production environments.
• Advanced Oracle performance tuning, SQL optimization, and query-plan analysis.
• Strong knowledge of RAC, Data Guard, RMAN, ASM, Exadata, and partitioning.
• Familiar with PL/SQL for reviewing and troubleshooting database-resident code.
• Solid relational DB architecture, design, and data modeling skills.
• Experience with backup, recovery, high availability, and disaster recovery planning/testing.
• Experience with database security, auditing, and PCI-compliant environments.
• Ability to diagnose complex performance/reliability issues across apps and DB infra.
• Strong communication, collaboration, prioritization, and mentoring skills.

Responsibilities

• Define database architecture standards and guide technical decisions across ROI's products.
• Own multi-year roadmap for capacity, debt, and modernization.
• Evaluate DB technologies and cloud services for reliability, scalability, security, and cost.
• Provide senior ownership and escalation support for Oracle prod/non-prod environments.
• Lead performance tuning, SQL optimization, capacity planning, and troubleshooting with developers.
• Strengthen monitoring, backup, recovery, HA, and disaster-recovery practices.
• Lead root-cause analysis for significant incidents and participate in on-call rotation.
• Define standards for architecture, design, SQL development, documentation, and operations.
• Partner with engineering to improve DB quality and performance across the lifecycle.
• Develop modernization strategy for mature Oracle environment; evaluate AWS and cloud-native alternatives.
• Automate DB administration, deployment, monitoring, testing, and maintenance.

Skills

Oracle tuning

SQL optimization

RAC/Databases

Data Guard

RMAN

Exadata

Partitioning

PL/SQL

Security/compliance (PCI)

Incident analysis & RCA

Mentoring & collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

Datadog

AWS RDS/Aurora

Job description

ROI Solutions is seeking a Senior Oracle Database Administrator to lead the strategy and evolution of our Oracle database environment. You will shape architecture, standards, and modernization efforts while focusing on performance, reliability, security, automation, observability, and cloud adoption.

You will collaborate with Product Reliability, Security Engineering, Product, and Product Engineering teams, and our managed services partner to ensure secure, scalable databases.