ROLE We are seeking an experienced Database Administration & ETL (Extract, Transform, Load) Subject Matter Expert to support the Office of Inspector General (OIG) at the U.S. Department of Education headquarters in Washington, D.C. You will provide technical leadership in managing Oracle database environments, automating ETL processes, and maintaining the OIG’s Data Analytical System (ODAS). Your responsibilities will include designing and optimizing database architecture, executing secure and efficient data transfers, and supporting real-time operations that empower OIG audits and investigations. This is a full-time opportunity in which we'll provide competitive pay, comprehensive benefits, and job stability and security. TECHNICAL STACK This role requires demonstrated experience with the following tools, platforms, and technologies: Databases: Oracle (including RAC, ASM), Microsoft SQL Server Languages & Query Tools: SQL, PL/SQL, SQL • Plus, TOAD, Shell scripting, Perl ETL Tools: Oracle SQL • Loader, Data Pump Middleware & Reporting: Oracle Fusion Middleware, Oracle Access Manager (OAM), Oracle Unified Directory (OUD), BI Publisher Security: Oracle Transparent Data Encryption (TDE), Oracle Wallet, Database Vault, PKI/GPG File Transfer & Networking: SFTP, SAIG/TDClient, VPN, NetScaler Other Tools: Oracle WebLogic Server, Microsoft SharePoint, Microsoft Office Suite Methodologies: SDLC, Capacity Planning, Data Reconciliation, Automation RESPONSIBILITIES I. Database Operations & Maintenance Operate and maintain Oracle database systems supporting the Office of Inspector General (OIG)'s Data Analytical System (ODAS) Perform Oracle performance tuning, statistics generation, and database optimization Participate in Oracle software upgrades and patch deployments, including silent-mode installations Monitor and report on database performance and user activity to support auditing needs Develop and follow Standard Operating Procedures (SOPs) to ensure high system availability II. ETL & Data Management Manage daily Extract, Transform, Load (ETL) operations across Department of Education systems and ODAS Automate recurring data loads and refreshes using scripted, hands-free processes Integrate new data models and adjust existing workflows to meet evolving program needs Ensure accuracy and completeness of loaded data through reconciliation processes III. System Integration & Support Configure and deploy Oracle Data Warehouse components, including Oracle Fusion Middleware and BI Publisher Coordinate with OIG system administrators to support application deployments Conduct Software Development Lifecycle (SDLC) tasks, such as business process analysis, documentation, and testing Troubleshoot ODAS system issues in real time and support end-user inquiries IV. Security & Compliance Implement secure data transmission using Public Key Infrastructure (PKI), GNU Privacy Guard (GPG), Secure File Transfer Protocol (SFTP), and Virtual Private Network (VPN) Configure Oracle security features including Transparent Data Encryption (TDE), Oracle Wallet, and Database Vault Manage two-factor authentication using Oracle Access Manager (OAM) and Oracle Unified Directory (OUD) Apply federal cybersecurity and information assurance best practices V. Collaboration & Communication Work closely with the Data and Analytics Service (DAS) team to align technical efforts with investigative goals Provide guidance and technical support to junior staff members Engage regularly with end users to support database access, reporting tools, and data availability Participate in project planning meetings and contribute to documentation of technical deliverables Draft technical content for monthly status reports submitted to OIG leadership Contribute to documentation across all Software Development Lifecycle (SDLC) stages, including Functional Requirements Documents (FRDs) REQUIRED KNOWLEDGE, SKILLS, & ABILITIES Expertise in Oracle data loading tools, including SQL • Loader and Data Pump Ability to automate data loading using scripts on Windows and Linux platforms Proficiency in Structured Query Language (SQL) for data querying and manipulation Strong skills in Procedural Language/SQL (PL/SQL) for Oracle-based development Experience using SQL • Plus, TOAD, and Oracle Scripts for data and system management Knowledge of relational database design principles and best practices Ability to configure and administer Oracle and Microsoft SQL Server (MS SQL Server) environments Advanced capability in Oracle performance tuning and SQL optimization Skill in generating Oracle statistics to improve query execution and database performance Ability to analyze system documentation such as Entity-Relationship (ER) diagrams and data dictionaries Familiarity with record layouts, logic flow diagrams, and system modeling concepts Proficiency in configuring Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM) Working knowledge of Oracle Fusion Middleware components, including Oracle Access Manager (OAM), Oracle Unified Directory (OUD), and BI Publisher Ability to securely transmit data using Public Key Infrastructure (PKI), GNU Privacy Guard (GPG), Secure File Transfer Protocol (SFTP), and Virtual Private Network (VPN) tools Understanding of Oracle security tools including Transparent Data Encryption (TDE), Oracle Wallet, and Database Vault Competency in Shell scripting for task automation and system operations Familiarity with Microsoft SharePoint and Microsoft Office products for collaboration and documentation Ability to troubleshoot real-time issues across web and database systems Strong technical writing and documentation skills Ability to collaborate with cross-functional teams and end users Skill in providing technical guidance to junior team members REQUIRED EXPERIENCE 6 to 10 years of experience as a Subject Matter Expert in Database Administration and ETL with experience in Oracle data loading tools, including, but not limited to, SQL • Loader and Data Pump, as well as Windows and Linux scripts for loading automation Extensive knowledge and experience in SQL programming using query tools such as SQL Plus/Scripts, PL/SQL, and Toad Experience supporting the Software Development Lifecycle (SDLC), including business process analysis, documentation, testing, and deployment Experience performing version upgrades, patching, and silent-mode installations across Oracle platforms and middleware stacks Experience with unstructured data systems and conducting feasibility studies involving big data or social media platforms REQUIRED EDUCATION Bachelor’s degree in computer science, Information Technology, or equivalent LOCATION Washington, DC 20202 TELEWORK Not eligible for telework CLEARANCE U.S. citizenship is required as it supports the U.S. federal government Must currently hold or be eligible to obtain a T4 High Risk Public Trust background clearance CLIENT U.S. Department of Education TRAVEL Travel is not required WORK HOURS 40 hours, 8 hours a day, 5 days a week EMPLOYMENT CLASSIFICATION Employment Classification Eligibility — Exempt RELOCATION Not eligible for relocation benefits Job Types: Full-time, Contract Pay: $85,000.00 - $115,000.00 per year Benefits: 401(k) 401(k) matching Dental insurance Health insurance Life insurance Paid time off Professional development assistance Referral program Retirement plan Vision insurance Work Location: In person