Sr Oracle Application DBA

Think Tank, Inc.

Washington, DC

JOB DETAILS
JOB TYPE
Contractor
SKILLS
Acceptance Testing, Access Control, Agile Programming Methodologies, Amazon Web Services (AWS), Auditing, Authentication, Business Intelligence, CPU (Central Processing Unit), Capacity and Performance Management, Cloning, Cloud Computing, CompTIA Security+, Computer Science, Computer Security, Concurrency, Configuration Management, Cryptography, Data Recovery, Data Warehousing, Database Administration, Database Backup, Database Extract Transform and Load (ETL), Disaster Recovery, FISMA - Federal Information Security Management Act, Federal Government, File Systems, Financial Reporting, HTTP (HyperText Transport Protocol), High Availability, Identify Issues, Information Technology/Systems Audit, Linux Operating System, Maintain Compliance, Network Configuration Management, Oracle, Oracle Applications, Oracle Certifications, Oracle DBA (Database Administrator), Oracle Discoverer, Oracle Forms, Oracle Fusion Middleware, Oracle PL-SQL, Oracle Reports, Oracle WebLogic Server, Performance Analysis, Performance Tuning/Optimization, Query Optimization, RMAN, Red Hat Linux Operating System, SQL (Structured Query Language), SSL-TLS (Secure Socket Layer - Transport Layer Security), Schedule Development, Scripting (Scripting Languages), Secure/SSH File Transfer Protocol (SFTP), Security Auditing, Security Monitoring, Single Sign-On (SSO), Software Patches, Support Documentation, Tableau, Technical Support, Technical Writing, Test Plan/Schedule, U.S. National Institute of Standards and Technology (NIST), United States Citizen, Unix Shell Programming, Warehousing
LOCATION
Washington, DC
POSTED
30+ days ago

*US Citizenship Required

*Onsite Position in Washington, DC

*Must have Oracle EBS experience

*Position is subject to contract award

 

REQUIREMENTS:

  • 10+ years of experience administering Oracle EBS environments in federal or large-scale enterprise settings.
  • Bachelor's degree in Computer Science, or related field
  • Proficient with Oracle E-Business Suite, Oracle EBS Application Architecture, and SQL
  • Familiarity with federal IT security controls and audit requests, including SSO and MFA
  • Strong experience with Oracle 12c/19c database administration, backup/recovery (RMAN), and high availability using Data Guard.
  • Expertise in Fusion Middleware (WebLogic, OAM, OID), EBS application tiers, and concurrent processing.
  • Familiarity with AWS-hosted environments, Oracle on Linux (RedHat), and cloud-based performance/security monitoring tools.
  • Proficiency in shell scripting, PL/SQL, and managing complex integration interfaces.
  • Understanding of federal security standards and audit protocols including ATO, FISCAM, and FISMA.
  • Expertise in Agile Methodology
  • Prior federal work experience
  • Experience with ETL process

RESPONSIBILITIES:

  • Maintain and administer Oracle 12c/19c databases supporting Oracle EBS R12 (12.2.11), including production, development, test, UAT, and DR environments hosted in AWS.
  • Perform daily database health checks, monitor performance, optimize SQL queries, and manage backup/recovery using RMAN and Data Guard.
  • Implement and maintain Oracle's Advanced Security features (e.g., TDE encryption, fine-grained auditing, wallet authentication).
  • Manage and troubleshoot concurrent processing, workflows, and concurrent managers in the EBS stack.
  • Apply Oracle Critical Patch Updates (CPUs), PSU patches, and perform regular cloning, patching, and upgrades.
  • Manage comprehensive schedule for Oracle quarterly CPU patch, cloning request, monthly database and filesystem space management/cleanup, capacity management, performance tuning and evaluation.
  • Configure, maintain, and secure Oracle WebLogic Server, Oracle Access Manager (OAM), Oracle Internet Directory (OID), Oracle HTTP Server (OHS), and Oracle Forms/Reports 12c.
  • Support Oracle Discoverer (legacy), Oracle Warehouse Builder (OWB), and integration with Amazon Redshift/EDW for financial reporting.
  • Administer and monitor Fusion Middleware components including SSL, SSO, and SFTP channels.
  • Coordinate with Infrastructure team for system patching, storage management, and network configurations.
  • Evaluate critical Oracle EBS security issues (content, internal controls, access levels, etc.) and make recommendations.
  • Ensure compliance with FISMA, NIST, and EXIM IT security controls including audit logging, account reviews, configuration management, and DR/COOP planning.
  • Participate in annual COOP exercises and disaster recovery drills; maintain accurate DR plans and recovery scripts.
  • Provide technical support and documentation for OCFO and IT audit walkthroughs, ATO renewals, and system security plans.

PREFERRED QUALIFICATIONS:

  • Experience supporting Oracle EBS for a federal credit agency or financial institution.
  • Experience with Redshift, Tableau, or other BI/ETL tools in a hybrid data warehouse environment.
  • Certifications: Oracle Certified Professional (OCP), AWS Certified Solutions Architect (Associate), Security+ 

About the Company

T

Think Tank, Inc.