Senior Oracle Developer/DBA (Secret Clearance Required) - DEA

ITC Federal; Chantilly (VA); Hybrid; USD 120,000 - 150,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

401(k)

Tuition Reimbursement

FSA

11 Paid Federal Holidays

3 Weeks Paid Time Off

Job summary

ITC Federal is looking for a Senior Oracle Developer/DBA to support the Drug Enforcement Administration (DEA) in Chantilly, VA. This hybrid position demands a strong background in Oracle database systems and design. The successful candidate will work closely with application development teams, ensuring that databases are optimized for high performance.

Responsibilities include advanced database design, data modeling, and performance tuning. The ideal applicant will have over 10 years of experience with modern Oracle versions and must hold an active Secret clearance. A generous benefits package is offered, including health and 401(k).

Qualifications

• 10+ years of relevant work experience as an Oracle Database Engineer, Developer, or DBA.
• Deep, hands-on experience with modern Oracle versions, specifically Oracle 23ai / 26ai.
• Proven experience with Oracle Pluggable Databases (PDBs).
• Expert-level knowledge of Oracle Internals and performance optimization.

Responsibilities

• Support Special Operations initiatives through advanced database design.
• Manage isolated data workloads using Oracle Pluggable Databases (PDBs).
• Assist in diagnosing and tuning complex analytical queries.
• Provide technical expertise and mentorship on SQL best practices.

Skills

Oracle Database Engineering

Data Modeling

Performance Tuning

PL/SQL Optimization

Data Integration

Tools

ER/Studio

Oracle SQL Developer Data Modeler

Job description

Overview

Senior Oracle Developer/DBA. Government Agency: Drug Enforcement Administration (DEA). Position: Full time. Location: Chantilly, VA – Hybrid (4 days onsite / 1 day remote after initial 30 days fully onsite). Clearance: Active Secret clearance required; must also obtain and maintain a DEA Public Trust clearance (processing time: 4–6 weeks, must be completed prior to start). Benefits: Health, Dental, Vision, 401(k), Tuition Reimbursement, Flexible Spending Account (FSA), 11 Paid Federal Holidays, 3 weeks Paid Time Off.

ITC Federal is seeking an experienced Database Developer/DBA to support the Drug Enforcement Administration (DEA). In this role, you will serve as a senior technical resource responsible for the design, architecture, and development of Oracle database management systems. Acting as a key bridge between application development and database infrastructure, you will build efficient, scalable data structures and high‑performing code that meet the demanding requirements of a federal law‑enforcement environment. The ideal candidate brings deep expertise in data modeling, multitenant isolation, access‑path optimization, and data security, with the ability to evaluate and recommend both cloud and on‑premise DBMS solutions. You will also define database development standards and contribute to technical strategy through presentations and guidance on advanced DBMS concepts.

Responsibilities

• Application & Initiative Support: Support Special Operations initiatives through advanced database design, relational and dimensional data modeling, and Linux‑based Oracle database development.
• Multitenant Architecture: Architecture and manage isolated data workloads using Oracle Pluggable Databases (PDBs) within Container Databases (CDBs).
• Performance Tuning: Assist in diagnosing and tuning complex data analytical queries, optimizing execution plans, and leveraging Oracle 23ai/26ai modern performance features (such as AI Vector Search and advanced In‑Memory analytics).
• Developer Collaboration: Provide deep technical expertise and mentorship to application development teams on SQL best practices, data types, and PL/SQL optimization.
• Data Architecture: Collaborate with data architects on logical data models and seamlessly translate them into optimal physical database structures designed to perform efficiently under high‑load profiles.
• Data Integration: Assist with metadata management and the resolution of semantic conflicts resulting from the integration of disparate data sources.
• Lifecycle Management: Assist with database decommissioning efforts and the architecture, design, and partitioning of the online archive data store.
• Security & Compliance: Maintain the security posture of the Linux Oracle platform in accordance with federal DEA control sets, access controls, and automated patch management.

Qualifications

• Experience: 10+ years of relevant work experience as an Oracle Database Engineer, Developer, or Developer DBA.
• Oracle Expertise: Deep, hands‑on experience with modern Oracle versions, specifically focusing on Oracle 23ai / 26ai architecture and features.
• Multitenancy: Proven experience designing and managing applications within Oracle Pluggable Databases (PDBs).
• Data Modeling: Extensive experience in conceptual, logical, and physical data modeling using state‑of‑the‑art tools (e.g., ER/Studio, Oracle SQL Developer Data Modeler).
• Development Skills: 7–10 years of expertise in large, complex SQL query development, advanced PL/SQL (stored procedures, packages, triggers), and modern Oracle development IDEs.
• Performance Optimization: Expert‑level knowledge of Oracle Internals, execution plans, indexing strategies, and automated performance tuning via Oracle Enterprise Manager (OEM) Cloud Control.
• Integration: Demonstrated experience in data integration, metadata management, and analytical data stores.
• Minimum of an active Secret security clearance, required.

Working Environment

• Prolonged periods of sitting at a desk and working on a computer.
• Standard office environment; ability to lift 25 pounds.

ITC Federal is an equal opportunity/affirmative action employer and will not discriminate against any application for employment on the basis of age, race, color, gender, national origin, religion, creed, disability, veteran status, marital status, sexual orientation, genetic information, military status, disability, or sex including pregnancy and childbirth or related medical condition or on any other basis prohibited by law.