Senior Oracle DB Architect for Cloud Modernization (Remote)

ROI Solutions; Springfield (IL); Remoto; USD 120.000 - 170.000; Tempo pieno

Descrizione del lavoro

ROI Solutions seeks a Senior Oracle Database Administrator to lead architecture, standards, and modernization of our Oracle environment. You will own performance, reliability, security, automation, observability, and cloud adoption, collaborating with Product Reliability, Security Engineering, Product, and MSP partners.

You will advance capacity planning, root-cause analysis, and on-call readiness while mentoring engineers and delivering scalable, compliant data platforms for mission-critical

Competenze

• 8+ years of Oracle database administration experience supporting complex 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 sufficient 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 compliance-oriented environments such as PCI.
• Ability to diagnose complex performance and reliability issues across applications and database infrastructure.
• Experience developing or executing Oracle modernization and cloud migration strategies.
• Experience with Oracle workloads in AWS (Oracle DB@AWS).
• Familiarity with AWS RDS, Aurora, or other cloud-native database technologies.
• Experience evaluating when workloads should remain on Oracle versus transition to alternative database platforms.
• Experience with data pipeline and transformation technologies.
• Experience with Datadog or comparable database monitoring and observability platforms.
• Oracle Certified Professional (OCP) or comparable Oracle certification.
• Experience with SaaS, transaction-intensive, fundraising, payment, financial, or other mission-critical software platforms.
• Experience automating database administration, monitoring, deployment, or operational processes.

Mansioni

• Lead database strategy and architecture across ROI's products and platforms.
• Own the multi-year roadmap for capacity planning and modernization.
• Evaluate technologies and cloud services for reliability, security, and cost.
• Provide senior ownership and escalation for Oracle environments.
• Lead performance tuning, SQL optimization, and troubleshooting with developers.
• Strengthen monitoring, backup, recovery, high availability, and DR practices.
• Lead root-cause analysis for significant incidents and participate in a shared on-call rotation.
• Define standards for database architecture, design, and operations.
• Review significant schema changes, migrations, and database designs.
• Partner with engineering teams to improve database quality throughout the development lifecycle.
• Develop a pragmatic modernization strategy for the Oracle environment and cloud migration.
• Automate administration, deployment, monitoring, testing, and maintenance to reduce debt and complexity.
• Mentor engineers in relational design, SQL performance, and best practices.
• Provide database expertise for data pipelines, migrations, and product initiatives.

Conoscenze

Oracle DBA

SQL tuning

PL/SQL

RAC

Data Guard

RMAN

Exadata

Partitioning

Security/compliance

SaaS/financial apps

Strumenti

Datadog

AWS

RDS/Aurora

Automation scripting

Descrizione del lavoro

ROI Solutions seeks a Senior Oracle Database Administrator to lead architecture, standards, and modernization of our Oracle environment. You will own performance, reliability, security, automation, observability, and cloud adoption, collaborating with Product Reliability, Security Engineering, Product, and MSP partners.

You will advance capacity planning, root-cause analysis, and on-call readiness while mentoring engineers and delivering scalable, compliant data platforms for mission-critical