Senior Oracle DB Architect & Admin (EBR)

RAZOR; McLean (VA); Presencial; USD 120 000 - 180 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Medical, dental, vision insurance

Life and disability insurance

Paid time off and holidays

401(k) plan

Professional development opportunities

Resumo da oferta

Razor is seeking a Senior Oracle Database Administrator / Database Architect to support a federal IT program in McLean, VA. The role focuses on Oracle database architecture, schema design, PL/SQL development, and troubleshooting complex data issues.

Hands-on Oracle Edition-Based Redefinition (EBR) experience is required. You will design, implement, and optimize database structures and processes, collaborating with developers and QA to ensure robust, scalable solutions while maintaining

Qualificações

• 5+ years in database administration, development, or architecture.
• 1+ year hands-on Oracle EBR, editions, editioning views, cross-edition triggers.
• 3+ years designing and modifying Oracle schemas (tables, views, data grants).
• 3+ years PL/SQL development and troubleshooting.
• Experience correcting data issues: deduplication, backfills, and claim generation.
• Experience supporting transactional databases.
• Experience with tickets, peer reviews, and documenting changes.
• Understanding of Agile or SDLC.
• Must be able to obtain a security clearance.

Responsabilidades

• Design, develop, and maintain Oracle database structures and schemas.
• Use Oracle EBR to implement database changes while minimizing application downtime.
• Write and troubleshoot PL/SQL code and resolve data issues.
• Perform database corrections, root-cause analysis, and data integrity checks.
• Support database architecture improvements and evaluate technical solutions.
• Work with developers and technical teams to test, review, and deploy database changes.
• Document changes and follow established development and change management processes.

Conhecimentos

Database administration

PL/SQL

Schema design

Oracle EBR

Data integrity

SDLC/Agile

Security clearance readiness

Ferramentas

ER/Studio

Liquibase

GitHub

GitHub Copilot

Descrição da oferta de emprego

Razor is seeking a Senior Oracle Database Administrator / Database Architect to support a federal IT program in McLean, VA. The role focuses on Oracle database architecture, schema design, PL/SQL development, and troubleshooting complex data issues.

Hands-on Oracle Edition-Based Redefinition (EBR) experience is required. You will design, implement, and optimize database structures and processes, collaborating with developers and QA to ensure robust, scalable solutions while maintaining