Application Database Administrator

Think Tank, Inc.

  • Silver Spring, MD
  • Permanent
  • Full-time
  • 1 month ago
  • Apply easily
*US Citizenship Required*Position is Subject to Contract AwardREQUIREMENTS:
  • Expertise in Agile Methodology
  • Prior federal work experience
  • Experience with ETL process
  • 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
  • Great communication skills
  • 8+ years of experience administering Oracle EBS environments in federal or large-scale enterprise settings.
  • 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.
RESPONSIBILITIES:
  • 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.
  • 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

Think Tank, Inc.