Archived listing. The details below describe a past opening.
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.