Senior Oracle Developer, DBA – Secret Clearance Required

IT Coalition

Senior Oracle Developer/DBA supporting the DEA with advanced database design and Oracle expertise. Ensuring robust database solutions and performance optimization in federal law enforcement environments.

Posted 6/2/2026full-timeChantilly • Virginia • 🇺🇸 United StatesSeniorWebsite

Tech Stack

Tools & technologies

CloudLinuxOracleSQL

About the role

Key responsibilities & impact

Support Special Operations initiatives through advanced database design, relational and dimensional data modeling, and Linux-based Oracle database development.
Architecture and manage isolated data workloads using Oracle Pluggable Databases (PDBs) within Container Databases (CDBs).
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).
Provide deep technical expertise and mentorship to application development teams on SQL best practices, data types, and PL/SQL optimization.
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.
Assist with metadata management and the resolution of semantic conflicts resulting from the integration of disparate data sources.
Assist with database decommissioning efforts and the architecture, design, and partitioning of the online archive data store.
Maintain the security posture of the Linux Oracle platform in accordance with federal DEA control sets, access controls, and automated patch management.

Requirements

What you’ll need

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

Benefits

Comp & perks

Health, Dental and Vision
401(k)
Tuition Reimbursement
Flexible Spending Account (FSA)
11 Paid Federal Holidays
3 weeks' Paid Time Off

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Oracle DatabasePL/SQLSQLdata modelingperformance tuningAI Vector SearchIn-Memory analyticsmetadata managementdata integrationOracle Internals

Soft Skills

mentorshipcollaborationdiagnosingoptimizingproblem-solving

Certifications

Secret security clearance