Talent.com
Oracle DBA / ETL Developer

Oracle DBA / ETL Developer

A.C. CoyWashington, DC, United States
11 days ago
Job type
  • Full-time
Job description

Overview

  • Tier One Technologies is looking for an Oracle DBA / ETL Developer to support a US Government client.
  • This project requires subject matter expertise in database administration and ETL support services to assist the Data and Analytics Service (DAS) team in continuing to operate reporting capabilities and predictive models based on key indicators thatdetermine potential risk and behavior patterns within specific segments of the data population. This contract will build upon current data gathering and analysis capabilities to address existing and newly identified challenges.
  • These tasks require specialized experience in designing, creating, and implementing services that support data warehousing and archiving strategies, incorporating the design for end-user access to the data warehouse, data cubes, and associated business intelligence tools.
  • The engagementaims to deliver technical services, solutions support, and knowledge transfer to client staff, especially in the Oracle Data Warehouse Administration and Maintenance, ETL end-to-end process, and Oracle Fusion Middleware components configurations.
  • This is a 1-year, onsite contract position with the potential for a 4-year extension .
  • The work will be performed at the client office in Washington, DC : 8 : 00 AM - 4 : 30 PM EST, Monday through Friday.
  • Must be a US Citizen.
  • SELECTED CANDIDATES MUST MEET ELIGIBILITY REQUIREMENTS FOR ACCESS TO SENSITIVE INFORMATION AND ENVIRONMENTS.

Responsibilities

  • ODAS Oracle Enterprise Database System Capacity Planning and Installation, Setup, and Configuration, as well as user management - install, configure, and support ODAS applications based on the Oracle data warehouse system designed to support ODAS operations.
  • ODAS Enterprise ETL Solution – perform a daily operation of a data extraction / refresh process from the government'sdata systems to ODAS (OIG Data Analytical System) data warehouse systems using an “end-to-end” automated ETL solution.
  • ODAS Data Refresh Solution and ODAS BI Publisher Reports Support – perform a daily operation of a data refresh process for application specific systems, such as ODAS BI Publisher or on-demand data refresh to ODAS data warehouse systems using an “end-to-end” automated ETL data refresh solution.
  • Documents Deliverable - provide a comprehensive set of documents for the ODAS ETL process, Oracle Data Warehouse, including Middleware components, ODAS Applications mentioned above in each of the stages of SDLC, as well as user and administrator reference manuals.
  • Implement 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.
  • Research and perform system analysis to allow for a fully functional big data system and unstructured database, including feasibility studies of social media.
  • 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.

    • Qualifications

  • Bachelor’s degree in computer science, Information Technology. Or equivalent.
  • 6+ 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.
  • 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 OIG system administrators and DAS 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 OIG 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 SQL
  • Loader, Oracle SQL
  • Plus, Oracle Scripts / PL SQL) as well as data reconciliation to trace the scheduled and prioritized ETL tasks.
  • Excellent communication skills.
  • Must be a U.S. Citizen and able to obtain a Position of Public Trust Clearance.
  • Must be able to pass drug screening, criminal history, and credit checks.
  • Must have resided in the United States for at least 3 of the last 5 years immediately prior to the start of performance on this contract or have worked for the United States overseas in a federal or military capacity, or be a dependent of a federal or military employee serving overseas.

    • #J-18808-Ljbffr

    Create a job alert for this search

    Oracle Developer • Washington, DC, United States

    Related jobs
    • Promoted
    Oracle ERP Financial System Analyst (Grants and Fixed Asset)

    Oracle ERP Financial System Analyst (Grants and Fixed Asset)

    Office of The Chief Financial OfficerMaryland, MD, United States
    Full-time
    Government of the District of Columbia.Office of the Chief Financial Officer (OCFO).Oracle ERP Financial System Analyst (Grants and Fixed Asset). The Office of the Chief Financial Officer (OCFO) who...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle DBA

    Oracle DBA

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for an Oracle Database Administrator (DBA) - Remote.Key Responsibilities Install, configure, and maintain Oracle RDBMS across various environments Lead and support the migra...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle ERP Product Specialist

    Oracle ERP Product Specialist

    Office of The Chief Financial OfficerMaryland City, MD, United States
    Full-time
    Government of the District of Columbia.Office of the Chief Financial Officer (OCFO).IT Specialist (Product Specialist - CLOUD). The Office of the Chief Financial Officer (OCFO) whose mission is to e...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle Database Engineer

    Oracle Database Engineer

    ManTechFort Meade, MD, United States
    Full-time
    MANTECH seeks a motivated, career and customer-oriented.In this role, you will provide technical expertise for database design, development, implementation, information storage and retrieval, data ...Show moreLast updated: 17 days ago
    • Promoted
    Oracle ERP Applications Analyst

    Oracle ERP Applications Analyst

    VirtualVocationsFairfax, Virginia, United States
    Full-time
    A company is looking for an Oracle ERP Applications Analyst to provide support for their Oracle Fusion Cloud ERP implementation. Key Responsibilities Assist with system readiness, validation, and ...Show moreLast updated: 1 day ago
    • Promoted
    Oracle Cloud Payroll Analyst

    Oracle Cloud Payroll Analyst

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for a Functional Analyst - Oracle Cloud Payroll to support a full-platform Oracle Cloud HCM implementation. Key Responsibilities Support the implementation and post go-live of...Show moreLast updated: 1 day ago
    • Promoted
    Oracle Application Developer(Apps Cloud)

    Oracle Application Developer(Apps Cloud)

    Office of The Chief Financial OfficerMaryland, MD, United States
    Full-time
    Government of the District of Columbia.Office of the Chief Financial Officer (OCFO).Hybrid - Location Washington DC.The Office of the Chief Financial Officer (OCFO) whose mission is to enhance the ...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Application Developer

    Senior Application Developer

    VirtualVocationsBaltimore, Maryland, United States
    Full-time
    A company is looking for a Senior Application Developer to manage data transmission APIs and ensure secure integrations across enterprise systems. Key Responsibilities Develop data transmission AP...Show moreLast updated: 30+ days ago
    • Promoted
    Integration Analyst

    Integration Analyst

    VirtualVocationsAlexandria, Virginia, United States
    Full-time
    A company is looking for an Integration Analyst, Remote.Key Responsibilities Collaborate with business stakeholders to gather and analyze integration requirements Design and maintain data mappin...Show moreLast updated: 30+ days ago
    Oracle ETL Software Developer

    Oracle ETL Software Developer

    Barrow Wise ConsultingMD, USA
    Full-time
    Quick Apply
    Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you under...Show moreLast updated: 30+ days ago
    • Promoted
    CRM Developer

    CRM Developer

    VirtualVocationsFairfax, Virginia, United States
    Full-time
    A company is looking for a CRM Developer to oversee the administration, customization, and integration of their enterprise CRM platform. Key Responsibilities Manage and maintain CRM environments, ...Show moreLast updated: 30+ days ago
    • Promoted
    Talend Developer

    Talend Developer

    VirtualVocationsAlexandria, Virginia, United States
    Full-time
    A company is looking for a Talend Developer.Key Responsibilities Design and implement ETL workflows using Talend Studio and Talend Data Integration Optimize data pipelines and handle large-scale...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle ERP Financial Manager

    Oracle ERP Financial Manager

    Office of The Chief Financial OfficerMaryland, MD, United States
    Full-time
    Government of the District of Columbia.Office of the Chief Financial Officer (OCFO).Hybrid; Location : Washington, DC).The Office of the Chief Financial Officer (OCFO) whose mission is to enhance th...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle Fusion Technical Lead

    Oracle Fusion Technical Lead

    E-talentnetworkMcLean, VA, United States
    Full-time
    Century Technologies is seeking an Oracle Cloud PaaS developer to join our ERP team.This position will be responsible for the architecture, development, and technical support of Oracle Fusion Cloud...Show moreLast updated: 3 days ago
    • Promoted
    Oracle Cloud - Integrations / Conversions - Senior Assoicate

    Oracle Cloud - Integrations / Conversions - Senior Assoicate

    PwCBaltimore, MD, United States
    Full-time
    At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency.These individuals ana...Show moreLast updated: 3 days ago
    Oracle APEX Developer

    Oracle APEX Developer

    SiloSmashersAlexandria, VA, USA
    Full-time
    Quick Apply
    We are seeking an experienced Oracle APEX Application Developer to join our team.The ideal candidate will have a proven track record in Oracle APEX application development, strong PL / SQL skills, an...Show moreLast updated: 30+ days ago
    Oracle Database Architect

    Oracle Database Architect

    Think Tank, Inc.Silver Spring, MD, USA
    Full-time +1
    Quick Apply
    US Citizen Preferred / Proof of Work Authorization Required for Non-US Citizens.This is a remote opportunity with the possibility of working onsite in Tallahassee, FL. Responsible for assessing and ma...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle ERP Applications Support Manager

    Oracle ERP Applications Support Manager

    Office of The Chief Financial OfficerMaryland, MD, United States
    Full-time
    Government of the District of Columbia.Office of the Chief Financial Officer (OCFO).ERP Applications Support Manager.This position is located in the Office of the Chief Financial Officer (OCFO), Of...Show moreLast updated: 30+ days ago