Senior Oracle DBA & Data Architect | EBR & PL/SQL Focus

Decisive Point Consulting Group; Idaho; On-site; USD 80,000 - 100,000; Full time

Job summary

Decisive Point Consulting Group in Idaho seeks an experienced DBA/Data Architect to design, develop, and maintain complex Oracle database systems. The role emphasizes PL/SQL development, schema design, and hands-on EBR implementation in an Agile environment.

Key duties include building schemas, implementing EBR editions and related triggers, troubleshooting data corrections and deduplication, and collaborating with cross-functional teams to ensure reliable systems.

Qualifications

• 1+ years of experience with Oracle Edition-Based Redefinition (EBR)
• 3+ years of experience designing schema and architectural changes
• 3+ years of experience with PL/SQL skills, including data correction and root-cause analysis
• Experience with transactional systems
• Comfortable working from tickets, performing peer reviews, and documenting changes
• Knowledge of Agile methodologies or the software development life cycle (SDLC)
• Ability to obtain and maintain a public trust clearance

Responsibilities

• Design, develop, and maintain Oracle database schemas, tables, views, and data grants.
• Implement database changes using Oracle Edition-Based Redefinition (EBR), including editions, editioning views, and cross-edition triggers.
• Develop and troubleshoot PL/SQL solutions, including data corrections, deduplication, backfills, and claim generation.
• Perform root-cause analysis and resolve complex database issues within transactional systems.
• Participate in peer reviews, document technical changes, and manage assigned development tickets.
• Collaborate with development teams to support database enhancements and system reliability

Skills

EBR Knowledge

PL/SQL

Schema Design

Agile SDLC

Public Trust Clearance

Transactional Systems

Peer Reviews

GitHub

Kafka

ER/Studio

Liquibase

Copilot

Tools

Liquibase

GitHub

GitHub Copilot

ER/Studio

Kafka

Job description

Decisive Point Consulting Group in Idaho seeks an experienced DBA/Data Architect to design, develop, and maintain complex Oracle database systems. The role emphasizes PL/SQL development, schema design, and hands-on EBR implementation in an Agile environment.

Key duties include building schemas, implementing EBR editions and related triggers, troubleshooting data corrections and deduplication, and collaborating with cross-functional teams to ensure reliable systems.