Senior Oracle DB Architect & Modernization Lead

ROI Solutions; Montpelier (VT); A distancia; USD 140.000 - 180.000; Jornada completa

Descripción de la vacante

ROI Solutions seeks a Senior Oracle Database Administrator to lead the strategy and modernization of our Oracle environment. You will shape architecture, standards, and cloud adoption while driving performance, security, automation, observability, resiliency, and upgrades across prod and non-prod environments.

The role emphasizes ownership, proactive governance, mentoring, and collaboration with Product Reliability, Security, Engineering, and our managed services partner to secure scalable data

Formación

• 8+ years of Oracle database administration experience in complex production environments.
• Advanced 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.
• Strong communication, collaboration, prioritization, and mentoring skills.

Responsabilidades

• Set database strategy and guide technical decisions 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 and escalation support 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.
• Develop a pragmatic modernization strategy for ROI's mature Oracle environment and evolving product architecture.
• Evaluate Oracle on AWS, cloud-native services, and alternative database platforms for appropriate workloads.
• Automate database administration, deployment, monitoring, testing, and maintenance to reduce technical debt and complexity.
• Serve as a senior database resource and mentor engineers in relational design, SQL performance, and database best practices.
• Create documentation, training, reusable patterns, and automation that strengthen shared database knowledge.
• Clarify responsibilities, knowledge, and escalation procedures with the managed services provider.
• Provide database expertise for data pipelines, client conversions, migrations, and significant product initiatives.
• Partner with data and engineering teams on scalable, secure, and efficient data movement across platforms and external systems.
• Serve as the senior technical partner to ROI's database managed services provider.
• Define responsibilities, escalation paths, service expectations, and SLAs, and regularly assess service quality.
• Evaluate database-related vendors, technologies, and services as needed.

Conocimientos

Oracle performance tuning

SQL optimization

RAC

Data Guard

RMAN

ASM

Partitioning

PL/SQL familiarity

Relational DB architecture

Data-modeling

Backup & DR

Security & compliance

Troubleshooting

Communication & mentoring

Herramientas

Datadog

Oracle on AWS

Descripción del empleo

ROI Solutions seeks a Senior Oracle Database Administrator to lead the strategy and modernization of our Oracle environment. You will shape architecture, standards, and cloud adoption while driving performance, security, automation, observability, resiliency, and upgrades across prod and non-prod environments.

The role emphasizes ownership, proactive governance, mentoring, and collaboration with Product Reliability, Security, Engineering, and our managed services partner to secure scalable data