Think Tank Inc
Application Database Administrator
Think Tank Inc, Silver Spring, Maryland, United States, 20900
*US Citizenship Required
*Position is Subject to Contract Award REQUIREMENTS:
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
*Position is Subject to Contract Award REQUIREMENTS:
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