Job Description
ROLE We are seeking an experienced Oracle Database Administrator 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.
Apply today!
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 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 WORK HOURS - 40 hours
- 8 hours a day
- 5 days a week
EMPLOYMENT CLASSIFICATION - Employment Classification Eligibility — Exempt
RELOCATION - Not eligible for relocation benefits
****************** KMRG, LLC is an Equal Opportunity/Affirmative Action (EEO/AA) employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, gender identity, sexual orientation, ancestry, national origin, age, marital or civil partnership status, mental disability, physical disability, medical condition, pregnancy, maternity status, political affiliation, military or veteran status, genetic information, traits historically associated with race, or any other basis prohibited by federal, state, and/or local law.
Other Considerations. Applicants will be subject to a background investigation. Individual’s primary workstation is located in an office area. The noise level in this environment is low to moderate. Regularly required to sit for extended periods up to 100% of the time; frequently required to move about to access file cabinets and use office equipment such as PC, copier, fax, telephone, cell phone, etc. Occasionally required to reach overhead, bend, and lift objects of up to 10 lbs. Specific vision abilities required by this job include the use of computer monitor screens up to 100% of the time.
Job Tags
Full time, Work at office, Local area, Remote work, Relocation, Relocation package,