DBA/Data Architect

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

Job summary

Decisive Point Consulting Group is seeking an experienced DBA/Data Architect in the United States to design, develop, and maintain complex Oracle database schemas and data governance within an Agile team.

The role requires hands-on PL/SQL, EBR implementations, and strong debugging skills; you will collaborate across teams to ensure reliability, perform root-cause analysis, and support effective data management.

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 including data correction and root-cause analysis.
• Experience with transactional systems.
• Comfortable working from tickets, peer reviews, and documenting changes.
• Knowledge of Agile methodologies or the 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 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 development tickets.
• Collaborate with development teams to support database enhancements and system reliability.

Skills

EBR

PL/SQL

Schema design

Transactional systems

Agile SDLC

Public trust

Tools

ER/Studio

Liquibase

Kafka

GitHub

GitHub Copilot

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

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