T and T Consulting Services

Oracle DBA Developer/Warehouse


PayCompetitive
LocationFalls Church/Virginia
Employment typeFull-Time

This job is now closed

  • Job Description

      Req#: 508783

      MUST BE US CITIZEN OR 5-YEAR US PERMANENT RESIDENT


      Project Overview:

      The FIS Project aims to create a modern and efficient Oracle-based SEDAR Data Repository/Warehouse for the Southeast Data, Assessment, and Review (SEDAR) process. This system will enable data providers to submit datasets and ensure data compliance through validation checks. The repository will extract updates from authoritative data sources and support various SEFSC surveys and state agencies in three regions: Southeastern U.S. Atlantic, Gulf of Mexico, and the Caribbean. The project's goal is to reduce compilation effort and errors, improve data accessibility, and ensure data security. The system will not be authoritative on all data but will act as a centralized platform for data integration and validation.

      Responsibilities:

      1. Design and implement an Oracle-based SEDAR Data Repository/Warehouse for Southeast Data, Assessment, and Review (SEDAR), enabling data providers to submit datasets with assurance of data compliance through validation checks.
      2. Oracle Data Warehouse Design and Implementation
      3. Oracle Developer / DBA
      4. Strong on Oracle database design, architecture, and reporting (developing views, etc).
      5. Very experienced at building Data Warehouses and enabling data for public distribution.
      6. Develop a system to extract updates from various authoritative data sources, ensuring data accuracy and efficiency.
      7. Collaborate with stakeholders from Southeastern U.S. Atlantic (SA), Gulf of Mexico (GOM), and the Caribbean regions to streamline data compilation and reduce errors.
      8. Continuously improve the system to ensure data security, data quality, and data accessibility.
      9. Troubleshoot and resolve any technical issues related to the SEDAR Data Repository.

      Qualifications:

      1. Proven experience in designing and implementing Oracle-based data warehouses or repositories.
      2. Strong understanding of data validation techniques and data compliance principles.
      3. Experience with data integration, data extraction, and data transformation tools.
      4. Familiarity with fisheries data and data management systems.
      5. Strong problem-solving skills and ability to work in a collaborative environment.
      6. Excellent communication and documentation skills.

      Education & Experience:

      1. Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
      2. Eight+ years of experience.


      Benefits: Competitive benefits package including health, dental, vision, life insurance coverage, 401(k) Plan, Training Programs, Accrued Paid Time Off (PTO) and Paid Holidays.

      Equal Opportunity Employer/Veterans/Disabled

  • About the company

      T and T Consulting Services, Inc. is a woman-owned 8(a) certified small business, specializing in providing superior IT Services to the Federal Government.