Talent.com
Oracle DBA / ETL Developer

Oracle DBA / ETL Developer

A.C. CoyWashington, DC, United States
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.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

    serp_jobs.job_alerts.create_a_job

    Oracle Developer • Washington, DC, United States

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Senior SQL Developer

    Senior SQL Developer

    VirtualVocationsBaltimore, Maryland, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior SQL Developer with Capital Markets experience.Key Responsibilities Develop and maintain database applications supporting Risk Management Design and develop data...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Sr. Oracle Cloud Report Developer

    Sr. Oracle Cloud Report Developer

    Dunhill Professional SearchFairfax, VA, US
    serp_jobs.job_card.full_time
    Serve as a reporting expert developing, testing, and validating reports across the Oracle Fusion Cloud modules.Collaborate closely with the functional team to understand business requirements and d...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Oracle HCM Cloud Reports Lead Developer

    Oracle HCM Cloud Reports Lead Developer

    Dunhill Professional SearchFairfax, VA, US
    serp_jobs.job_card.full_time
    BI Publisher, OBTBI and HCM Extracts.Work with project team functionals, developers and client stakeholders on developing requirements for reports. Assist with input and development of design materi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    Oracle / APEX Developer Resource

    Oracle / APEX Developer Resource

    Human Capital Resources and ConceptsWashington D.C, DC, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    HCRC is seeking a talented and motivated Oracle / APEX Developer to join our team.This role will be responsible for designing, developing, and maintaining applications using Oracle Application ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Oracle SOA Developer

    Oracle SOA Developer

    i360technologiesWashington, DC, US
    serp_jobs.job_card.full_time
    At i360technologies, we’re a team of driven professionals specializing in business consulting and technology services for federal agencies. We’re passionate about solving complex challen...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    i360technologies is hiring : Oracle PL SQL BI Publisher Developer in Washington

    i360technologies is hiring : Oracle PL SQL BI Publisher Developer in Washington

    MediabistroWashington, DC, United States
    serp_jobs.job_card.full_time
    Tier 3 technical support to help the user base with issues related to the systems and their functionality.Support includes maintenance of interfaces between the hosted Eagle ADMS solution and the c...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior ETL Developer

    Senior ETL Developer

    VirtualVocationsWashington, District of Columbia, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior ETL Developer to join their Data Infrastructure team, focusing on tasks for Marketing.Key Responsibilities Develop and optimize data warehouse architecture and d...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Oracle Database Engineer

    Oracle Database Engineer

    ManTechLaurel, MD, United States
    serp_jobs.job_card.full_time
    Database Administrator / Engineer.The team delivers enterprise infrastructure capabilities for a global workforce performing a wide range of missions in defense of our Nation.Responsibilities Include...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Oracle EBS Developer

    Oracle EBS Developer

    VirtualVocationsAlexandria, Virginia, United States
    serp_jobs.job_card.full_time
    A company is looking for an Oracle EBS Developer.Key Responsibilities Lead the technical design, development, and deployment of Oracle EBS solutions Manage the end-to-end project lifecycle, incl...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Oracle Technical Developer

    Oracle Technical Developer

    System OneWashington, DC, United States
    serp_jobs.job_card.temporary
    Job Title : Oracle Technical Developer.Compensation : $72 - $90 hourly.Job Title : Oracle Technical Developer – Agency Contract. We are seeking an experienced Oracle Technical Developer for a 12-month ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Oracle HCM Integration Developer

    Oracle HCM Integration Developer

    VirtualVocationsWashington, District of Columbia, United States
    serp_jobs.job_card.full_time
    A company is looking for an Oracle HCM Integration Developer.Key Responsibilities Develop and maintain inbound and outbound integrations using various Oracle HCM tools Collaborate with Payroll a...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Oracle HCM VBCS Developer

    Oracle HCM VBCS Developer

    Dunhill Professional SearchFairfax, VA, US
    serp_jobs.job_card.full_time
    Oracle HCM Cloud Visual Builder (VB) Developer.In this role, you'll design, develop, test, and implement advanced Visual Builder solutions across Core HR, Benefits, and other HCM modules.You'll par...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Oracle Developer- 3400306

    Oracle Developer- 3400306

    AMS Staffing, Inc.Merrifield, VA, US
    serp_jobs.job_card.full_time
    HR 1099 or $105K W2 (Plus benefits and PTO).Hybrid (1 day remote, 4 days onsite).Contract to Hire (Potential to convert to FTE after 6 months). Bachelor’s degree required : .FEFF;Referral ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Oracle APEX Developer

    Oracle APEX Developer

    VirtualVocationsFairfax, Virginia, United States
    serp_jobs.job_card.full_time
    A company is looking for an Oracle APEX Developer.Key Responsibilities Design, develop, and maintain Oracle APEX applications for web and mobile platforms Manage cloud-based deployments of APEX ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Oracle ETL Software Developer

    Oracle ETL Software Developer

    Barrow Wise ConsultingMD, USA
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Oracle DBA - TS.SCI w / favorable poly REQUIRED

    Oracle DBA - TS.SCI w / favorable poly REQUIRED

    BK ConsultingMcLean, VA, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Database Administrator QUALIFICATIONS : .Eight years of demonstrated ‘hands-on’ database engineering and administration of systems for complex and high volume data processing, using a var...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Oracle APEX Developer

    Oracle APEX Developer

    SiloSmashersAlexandria, VA, USA
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Oracle Database Architect

    Oracle Database Architect

    Think Tank, Inc.Silver Spring, MD, USA
    serp_jobs.job_card.full_time +1
    serp_jobs.filters_job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30