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

Responsibilities

• 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.
• Aid in 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.

Qualifications

• 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.