Oracle ADW Developer

Position: Oracle Autonomous Data Warehouse (ADW) Developer Location: Remote/WFH Duration: long term contract Clearance: Active DoD Secret Citizenship: U.S. Citizenship Required Certification: IAT Level II mandatory Summary • We are looking for an experienced Oracle ADW Developer to join our defense program team. The ideal candidate will have strong expertise in Oracle Autonomous Data Warehouse (ADW) on OCI, including SQL/PLSQL development, data modeling, performance tuning, and secure pipeline integration. The role requires deep knowledge of DoD security and compliance frameworks (DoD SRG, FedRAMP, NIST, CMMC), with proven ability to implement database security, encryption, auditing, and RMF/ATO support. Secondary experience with Oracle Analytics Cloud (OAC) for dashboards and reporting is preferred. An active DoD Secret clearance (Top Secret/SCI preferred) is required. Key Responsibilities • Design, develop, and optimize ADW schemas, PL/SQL packages, and ELT/ETL pipelines. • Implement and manage ADW features: partitioning, compression, auto-scaling, materialized views, and Autonomous Data Guard. • Secure ADW deployments with private endpoints, IAM policies, CMK/KMS encryption, Database Vault, Unified Auditing, and Data Safe. • Build and maintain data ingestion pipelines (GoldenGate, ODI, Data Integration, Object Storage, ORDS/REST). • Support RMF/ATO processes with compliance documentation and control mapping. • Deliver OAC dashboards and reports integrated with ADW data models. • Enforce row-level and role-based security for both ADW and OAC analytics. • Perform performance tuning, backup/DR management, and incident response. Qualifications • 5–8+ years of Oracle data warehousing experience, including 2–3+ years on Oracle ADW/OCI. • Strong SQL/PLSQL development skills with expertise in data modeling and performance tuning. • Hands-on experience with OCI networking, IAM, Vault/KMS, Cloud Guard, and security best practices. • Familiarity with DoD SRG IL5/IL6, FedRAMP High, NIST 800-53/171, and CMMC 2.0. • Experience securing enterprise databases with audit, encryption, and access controls. • Active DoD Secret clearance (minimum) • Supporting experience with Oracle Analytics Cloud (OAC) for dashboards, KPIs, and reporting. • Knowledge of APEX, ORDS, and BI tool integration (preferred). • Certifications such as OCI Architect, OCI Data Management, Security+ or CISSP (preferred). • Experience with Terraform, CI/CD pipelines, and DevSecOps practices (a plus). Best Regards, ------- David Roy | Accounts Manager – US Staffing | Charter Global Inc. | https://www.charterglobal.com LinkedIn