DBA/Data Architect

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

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

DBA/Data Architect

Full Time US

Salary Range: $80,000.00 To $100,000.00 Annually

Currently seeking an experienced Database Administrator/Data Architect to support the design, development, and maintenance of complex database systems. The ideal candidate will have strong PL/SQL development experience, expertise in database schema design, and hands-on experience with Oracle Edition-Based Redefinition (EBR). This position requires strong analytical and troubleshooting skills, attention to detail, and the ability to collaborate within an Agile development environment.

Essential Functions:

• 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

Required Skills:

• 1+ years of experience with Oracle Edition-Based Redefinition (EBR)
  • https://www.oracle.com/database/technologies/ebr/
  • Editions, editioning views, and cross-edition triggers
• 3+ years of experience designing schema and architectural changes
  • Tables, views, and data grants
• 3+ years of experience with PL/SQL skills, including data correction and root-cause analysis
  • Data Correction Skills: data deduplication, backfills, and claim generation
• 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

Desired Skills:

• Data modeling experience with ER/Studio (logical and physical models) ER/Studio Enterprise Data Modeling and Architecture Tools - ER/Studio
• Experience with Liquibase for maintaining consistency across environments
• Familiarity with Kafka or event-driven architectures
• Experience with GitHub (version control, PRs) and GitHub Copilot or similar AI-assisted development tools

DPCG is an Equal Opportunity Employer committed to hiring and developing the most qualified individuals based on merit, experience, and business needs, without regard to any protected status under applicable law.