Senior Oracle Database Administrator

ROI Solutions•Medford, MA

6d•Remote

About The Position

ROI Solutions is seeking a Senior Oracle Database Administrator to lead the strategy and evolution of its Oracle database environment. This high-impact individual contributor will apply deep Oracle expertise to shape architecture and technical standards and advance performance, reliability, security, automation, observability, resiliency, and cloud adoption. The role collaborates with Product Reliability and Security Engineering, Product, Product Engineering, and a managed services partner to keep database platforms secure, scalable, and prepared for the future. The position owns database architecture guidance and a multi-year roadmap for capacity, technical debt, and modernization. It provides senior technical ownership and escalation support for production and non-production Oracle environments; leads performance tuning, capacity planning, and significant incident analysis; and strengthens monitoring, backup, recovery, high availability, and disaster recovery. The administrator also defines practical governance and standards, reviews important database changes and designs, and partners with engineering teams throughout the development lifecycle. The role develops a pragmatic modernization strategy for a mature Oracle environment, evaluates Oracle on AWS, cloud-native services, and alternative platforms, and automates administration and operational processes. It also mentors engineers, creates documentation and reusable practices, clarifies responsibilities and escalation procedures with the managed services provider, and supports data pipelines, client conversions, migrations, and product initiatives. This remote-posted role works in the Eastern Time Zone, with limited travel—generally fewer than five trips per year. It may be hybrid or in-office and is available only to candidates working in the listed states or Washington, DC.

Requirements

At least 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.
Strong communication, collaboration, prioritization, and mentoring skills.

Nice To Haves

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 in a small or mid-sized technology organization where senior technical contributors work across traditional functional boundaries.
Experience automating database administration, monitoring, deployment, or operational processes.

Responsibilities

Set database architecture standards and guide technical decisions across ROI’s products and platforms.
Own the multi-year roadmap for database capacity, technical debt, and modernization.
Evaluate database technologies and cloud services for 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 database 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 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.
Mentor engineers in relational design, SQL performance, and database best practices.
Create documentation, training, reusable patterns, and automation to 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 the database managed services provider; define responsibilities, escalation paths, service expectations, and SLAs, and assess service quality.
Evaluate database-related vendors, technologies, and services as needed.