Senior Oracle Database Administrator

ROI Solutions•Medford, MA

1d•Remote

About The Position

ROI Solutions is seeking a Senior Oracle Database Administrator to lead the strategy and evolution of our Oracle database environment. In this high-impact individual contributor role, you’ll combine deep Oracle expertise with a pragmatic approach to modernization, shaping architecture and technical standards while advancing performance, reliability, security, automation, observability, resiliency, and cloud adoption. You will collaborate with our Product Reliability and Security Engineering, Product, and Product Engineering teams, along with our managed services partner, to ensure ROI’s database platforms remain secure, scalable, and prepared for the future.

Requirements

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, 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 working 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 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.