Senior Oracle DBA (Secret Clearance Required) - DEA

ITC Federal, Inc.•Chantilly, VA

7d•Hybrid

About The Position

ITC Federal is seeking an experienced Senior Oracle 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 administration of Oracle database management systems. You will build efficient, scalable data structures 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 administration standards and contribute to technical strategy through presentations and guidance on advanced DBMS concepts.

Requirements

10+ years of relevant work experience as an Oracle DBA, Engineer, Developer, or Developer DBA.
Deep, hands-on experience with modern Oracle versions, specifically focusing on Oracle 19c or newer architecture and features.
Proven experience designing and managing applications within Oracle Pluggable Databases (PDB).
Extensive experience in conceptual, logical, and physical data modeling using state-of-the-art tools (e.g., ER/Studio, Oracle SQL Developer Data Modeler).
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.

Nice To Haves

Experience with large, complex SQL query development, advanced PL/SQL (stored procedures, packages, triggers), and modern Oracle development IDEs.

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