Database Admin / Architect

Database Admin / Database Architect

Razor is seeking an experienced Database Admin / Database Architect to support database architecture, development, and maintenance for a federal program. This position requires strong expertise in Oracle database technologies, schema design, PL/SQL development, and transactional systems.

The ideal candidate will have experience implementing database architectural changes, troubleshooting complex data issues, and maintaining reliable database environments. Experience with Oracle Edition-Based Redefinition (EBR) is particularly important, including editioning views and cross-edition triggers.

Clearance Requirements

- Must be able to obtain a security clearance.

Key Responsibilities

• Design, develop, and implement database schema and architectural changes, including tables, views, and data grants.

• Utilize Oracle Edition-Based Redefinition (EBR) capabilities, including editions, editioning views, and cross-edition triggers.

• Develop, maintain, and troubleshoot PL/SQL code to support database operations and application functionality.

• Perform data correction activities, including deduplication, backfills, and claim generation.

• Conduct root-cause analysis to identify and resolve database issues.

• Support transactional database systems and ensure data integrity.

• Assess alternative database products, tools, and architectural approaches, evaluating associated risks and benefits.

• Develop database design strategies aligned with technical and business requirements.

• Work from assigned tickets, participate in peer reviews, and document database changes.

• Collaborate with development and technical teams throughout the software development life cycle.

• Support database changes and improvements within an Agile development environment.

Required Qualifications

• 5+ years of relevant database architecture experience, consistent with the Senior Database Architect labor category.

• 1+ years of experience with Oracle Edition-Based Redefinition (EBR), including editions, editioning views, and cross-edition triggers.

• 3+ years of experience designing database schema and architectural changes, including tables, views, and data grants.

• 3+ years of PL/SQL experience, including data correction and root-cause analysis.

• Experience performing data deduplication, backfills, and claim generation.

• Experience working with transactional systems.

• Demonstrated ability to evaluate database technologies, tools, and architectural approaches and identify associated risks and benefits.

• Experience working from tickets, conducting peer reviews, and documenting technical changes.

• Knowledge of Agile methodologies or the Software Development Life Cycle (SDLC).

• Strong analytical, troubleshooting, documentation, and collaboration skills.

Preferred Qualifications

• Experience with ER/Studio for logical and physical data modeling.

• Experience using Liquibase to manage database changes and maintain consistency across environments.

• Familiarity with Kafka or event-driven architectures.

• Experience with GitHub, including version control and pull requests.

• Familiarity with GitHub Copilot or comparable AI-assisted development tools.

Employer Information

Razor is an Equal Opportunity Employer and considers all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other protected characteristic.

Benefits Overview

Razor offers a comprehensive benefits package that may include medical, dental, and vision insurance; life and disability insurance; paid time off and holidays; a 401(k) plan; and professional development opportunities. Benefits offerings may vary based on position and employment status.