drjobs Database Administration And ETL Subject Matter Expert

Database Administration And ETL Subject Matter Expert

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Washington - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

About this Position:
Job Title: Oracle ETL Subject Matter Expert
Required Skill Set:
The consultant 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.
Key Requirements/Skills:
  • 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 SQL programming using query tools such as SQL Plus/Scripts PL/SQL and Toad.

  • 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.

  • Demonstrated knowledge of terminology usage and operating characteristics of information systems hardware software and operating system components within the client-server and web environment.

  • Ability to perform the SDLC (Software Development Lifecycle) process including business process flow analysis defining detailed requirements and technical design documentation for development and performing the system and integration tests specifically for the ETL business requirements.

  • Ability to analyze and evaluate moderate to highly complex information systems by being able to interpret such devices as Entity-Relationship Diagrams data dictionaries record layouts and logic flow diagrams.

  • Ability to interact with end users and monitor the operations of ODAS systems.

  • Ability to create SOP (Standard Operating Procedures) and follow the SOP daily to maintain the high availability of ODAS systems.

  • Ability to coordinate with system administrators and staff to deploy application(s) to ODAS systems.

  • Ability to provide guidance and instructions to a team of junior-level staff members.

  • Ability to translate project requirements into detailed system/design requirements to include providing alternatives recommendations and assistance to management and staff.

  • 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/TDClient 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 SQLLoader Oracle SQLPlus Oracle Scripts/PL SQL) as well as data reconciliation to trace the scheduled and prioritized ETL tasks.

  • Serve as a production manager to interact with end users and monitor the operations of ODAS systems and provide support with real-time diagnosis and troubleshooting based on the web and database architecture to ODAS system users.

  • Must be able to implement the Oracle and Linux security with Shell programming MS Share Point and MS Office as well as Oracle WebLogic configurations and operations to manage Oracle OAM OUD and BI Publisher.

  • Ability to research and perform system analysis to allow for a fully functional big data system and unstructured database including feasibility studies of social media.

  • Shall be able to assist in implementing the version upgrade changes and patches in silent mode for the Oracle Grid Infrastructure RAC Database (including Advanced Security features) Oracle Fusion Middleware (including Oracle WebLogic Server Oracle HTTP Server Oracle Access Manager Oracle Unified Directory Oracle Business Intelligence Enterprise Edition and Oracle Cloud Control) Oracle Database Vault and all standard components of each application.

  • 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.

  • Extensive knowledge and experience in SQL programming using query tools such as SQL Plus/Scripts PL/SQL and Toad.

  • Education: Bachelors degree in computer science Information Technology. Or equivalent.

Specific Requirements and Deliverables:
This aims to deliver technical services solutions support and knowledge transfer to clients staff especially in the Oracle Data Warehouse Administration and Maintenance ETL end-to-end process and Oracle Fusion Middleware components configurations.

Qualifications of Key Personnel:

  • Demonstrate that proposed staff meet:

    • 6 10 years of SME-level experience.

    • Expertise in Oracle SQL PL/SQL Data Pump SQL*Loader ETL tools Linux/Windows scripting Toad WebLogic RAC/ASM BI Publisher etc.

    • T4 High Risk Public Trust clearance (active) or eligibility.

  • Show how theyve successfully completed similar projects.

Employment Type

Full-time

Company Industry

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.