Overview
On Site
Depends on Experience
Contract - W2
Contract - Independent
Skills
Application Service Management
Authentication
Capacity Management
Data Loading
Data Warehouse
Database
Database Administration
Database Design
Encryption
Evaluation
Extract
Transform
Load
Linux
Microsoft SQL Server
Microsoft Windows
NetScaler
Network
OAM
OUD
Oracle
Oracle ASM
Oracle BI Publisher
Oracle Cloud
Oracle Fusion Middleware
Oracle Identity Management
PKI
PL/SQL
Perl
RAC
RDBMS
SFTP
SQL
SQL Tuning
SQL*Loader
SQL*Plus
Scripting
Security Clearance
Smart Card
Statistics
TDE
Technical Direction
Toad
Virtual Private Network
Job Details
Position: Subject Matter Expert in Database Administration and ETL
Location: Washington, D.C. (Onsite)
Duration: Long Term Contract With potential extension
Experience:
- Typically has 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.
- The contractor filling this role as a Subject Matter Expert in Database Administration and ETL must already have an active T4 High Risk Public Trust background clearance before the work begins.
- Must know relational database configuration, focusing on Oracle and MS SQL Server platforms, as well as database design and administration expertise to fill the technical requirements associated with these service requests.
Education:
- Bachelor s degree in computer science, Information Technology. Or equivalent.
Qualifications:
- Extensive knowledge and experience in SQL programming using query tools such as SQL PlScripts, PL/SQL, and Toad.
- Extensive knowledge and 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 Oracle tuning, including SQL tuning/optimizing to ensure the response time and throughput, as well as Oracle statistics generation to improve the performance of the Oracle optimizer.
- Ability to design, install, configure, implement, and integrate the full range of Oracle data warehouse on RAC including ASM on SAN, Oracle Fusion Middleware components (Oracle Access Manager, OAM, and Oracle Unified Directory, OUD for 2FA Smart Card authentication, and BI Publisher reports), and Oracle cloud control with capacity planning and security implementation including Oracle TDE/Wallet and Database Vault rule sets.
- Ability to define and implement the secured network data files transmission with SAIG message class/TD Client, SFTP, and VPN NetScaler.
- Ability to process the full range of end-to-end ETL processes starting with source data files evaluation and transmission, encryption/decryption (PKI/GPG commands), conversion (PERL), data loading (TOAD data point/for Oracle, Oracle Import/Export, Oracle SQL*Loader, Oracle SQL*Plus, Oracle Scripts/PL SQL) as well as data reconciliation to trace the scheduled and prioritized ETL tasks.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.