DBA/Data Architect
About The Position
DPCG is seeking an experienced Database Administrator/Data Architect to support the design, development, and maintenance of complex database systems. The role focuses on Oracle database schema design and development, PL/SQL solutions, and Oracle Edition-Based Redefinition (EBR). The successful candidate will bring strong analytical and troubleshooting skills, attention to detail, and the ability to collaborate in an Agile development environment. The position involves designing and maintaining database structures, implementing changes with EBR, resolving complex issues in transactional systems, and collaborating with development teams on enhancements and system reliability. It also includes working from development tickets, participating in peer reviews, and documenting technical changes. The candidate must be able to obtain and maintain a public trust clearance.
Requirements
- At least 1 year of experience with Oracle Edition-Based Redefinition (EBR), including editions, editioning views, and cross-edition triggers.
- At least 3 years of experience designing schema and architectural changes, including tables, views, and data grants.
- At least 3 years of PL/SQL experience, including data correction and root-cause analysis.
- Experience with transactional systems.
- Comfort 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.
Nice To Haves
- Data modeling experience with ER/Studio, including logical and physical models.
- Experience with Liquibase for maintaining consistency across environments.
- Familiarity with Kafka or event-driven architectures.
- Experience with GitHub, including version control and pull requests, and GitHub Copilot or similar AI-assisted development tools.
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Education Level
No Education Listed
