Senior Oracle DB Architect — Remote, Cloud Modernization

ROI Solutions; Annapolis (MD); Remoto; USD 140.000 - 190.000; Tempo pieno

Descrizione del lavoro

ROI Solutions is seeking a Senior Oracle Database Administrator to lead strategy and evolution of our Oracle environment. You will own architecture standards, multi-year modernization, and cloud adoption while ensuring performance, security, and observability across production and non-production systems.

The role emphasizes mentorship, governance, and collaboration with product reliability, security engineering, and engineering teams to deliver scalable, compliant, and resilient database

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, or other mission-critical software platforms.
• Experience automating database administration, monitoring, deployment, or operational processes.

Mansioni

• 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.
• 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.

Conoscenze

Oracle performance tuning

SQL optimization

Query plan analysis

RAC

Data Guard

RMAN

ASM

Exadata

Partitioning

PL/SQL

Data modeling

Backup & recovery

High availability

Security & PCI

Cloud migration

AWS workloads

Datadog

OCP

Data pipelines

Observability

Strumenti

AWS RDS

Aurora

Oracle DB@AWS

Descrizione del lavoro

ROI Solutions is seeking a Senior Oracle Database Administrator to lead strategy and evolution of our Oracle environment. You will own architecture standards, multi-year modernization, and cloud adoption while ensuring performance, security, and observability across production and non-production systems.

The role emphasizes mentorship, governance, and collaboration with product reliability, security engineering, and engineering teams to deliver scalable, compliant, and resilient database