DBA/Data Architect

• 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

• 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