Decisive Point Consulting Group, LLC logo

DBA/Data Architect

Decisive Point Consulting Group, LLC

United StatesJobSeen 1w agoSeen in employer's feed 1 day ago

Evaluate my fit

Most applications go out cold — see where you stand first. No sign-up to start.

Watch jobs like this.

Don't just apply. Show up ready.

Olive works from this exact posting.

At a glance

Compensation
No compensation found
Location
United States
Work Authorization
Not specified

Olive lists jobs from US employers, including remote roles you can work from the United States.

Requirements

Credentials this posting asks for.

Public Trust clearance

Job overview

Decisive Point Consulting Group is seeking an experienced Database Administrator/Data Architect to design, develop, and maintain complex database systems. The role focuses on Oracle schema design, PL/SQL development, and Oracle Edition-Based Redefinition, while supporting transactional systems and collaborating in an Agile development environment. The candidate must be able to obtain and maintain a public trust clearance; experience with ER/Studio, Liquibase, Kafka, GitHub, and AI-assisted development tools is desired.

Skills & qualifications

RequiredNice to have

Skills

Oracle Edition-Based RedefinitionSchema DesignDatabase ArchitectureOracle DatabasePL/SQLData CorrectionRoot-Cause AnalysisData DeduplicationData BackfillsClaim GenerationTransactional SystemsTicket ManagementPeer ReviewsTechnical DocumentationAgile MethodologiesSoftware Development Life CycleData ModelingER/StudioLiquibaseKafkaEvent-Driven ArchitecturesGitHubAI-Assisted Development ToolsAnalytical SkillsTroubleshootingAttention to DetailCollaboration

Qualifications

1+ Year Oracle EBR Experience3+ Years Schema Design Experience3+ Years PL/SQL ExperiencePublic Trust Clearance Eligibility

Full job description

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.

Similar jobs, posted recently

Open roles like this one, listed in the last 30 days.

You've read the whole posting — now see how you match it.

Evaluate my fit