Oracle DBA

2 weeks ago

Richmond, United States Crescens Full time
Job Title : Oracle DBA
Location: Richmond, VA
Duration: 9+months
Type: Contract

*local Richmond, VA candidates required for ONSITE work, at least 3 days/wk*

Job Description:
  • The Client is seeking a senior oracle database administrator to join the Oracle/SQLServer Database Administration Team in the Enterprise Data Management section.
  • The selected candidate will administrator & support Oracle databases throughout the agency.

The selected candidate will:
  • Rely on experience and judgment to plan and accomplish goals.
  • Independently perform a variety of complicated tasks.
  • Work with a team of Oracle/SQLServer DBAs.
  • Communicate clearly and effectively, both speaking and in writing.
  • Perform installations of database related software. (including database upgrades and patching).
  • Monitor databases to maintain/ensure database uptime and availability.
  • Troubleshoot application/database issues related to connectivity, access, security and etc.
  • Tune long running SQL using AWR/ASH/ADDM/Profiler and etc.
  • Review & refine existing database tasks and processes to better align with agency/group priorities.
  • Perform database migrations between multiple release of Oracle12c,19c and 21c using data pump export/import, RMAN database duplication procedures. .
  • Working Experience in OCI/ Exadata Design, Migration and Administrative support
  • Leverage & utilize cron and O/S scripting in support of database maintenance/diagnosis/support.
  • Review the existing database implementation and propose, execute, and/or direct necessary changes.
  • The successful candidate will be capable of performing an analysis of the effectiveness of the existing system and clearly communicate reasoned justification for continuance and update, or alternative approaches.

Qualifications:
  • Over 5 years of experience in maintaining/supporting Oracle databases.
  • Bachelor's Degree in Computer Science, Information Systems with strong technical experience or other applicable and/or equivalent skills, knowledge and/or work history.
  • Demonstrated experience in communicating effectively using standard requirements and design artifacts.

Desired knowledge of and experience with the following technologies:
  • Oracle Database and Grid Infrastructure installation and upgrade versions 12c, 19c.
  • Oracle database configuration reviews, audits and troubleshooting on versions 12c 19c for all platforms supported by Oracle.
  • Expert knowledge on Backup and Recovery solutions with RMAN, as well as logical backups and backup scripting.
  • Advanced performance tuning skills with expertise on Oracle performance analysis tools such as ASH and AWR along with SQL Plan Baselines, SQL Profiles
  • Good understanding of latest DB new features and ability in applying them to provide a measurable value on clients systems.
  • Experience with Exadata deployments,managing and maintaining Exadata/OCI environments
  • Knowledge and experience of Oracle Cloud Infrastructure and Exadata Cloud Service

Preferred Experience:
  • Exadata / OCI Administration
  • Migrating DBs from OnPrem to OCI Exadata
  • Advanced database/SQL tuning concepts, DevOPS, CI/CD Special

Instructions to Applicants:
  • This position requires a fingerprint-based background check.
  • The successful contractor will be required to continue education at own expense to stay current with the client technologies.

Required:
  • Oracle Database Administration (Linux Servers and Window Servers) - versions 12c,19c,21c
  • Oracle Database Setup/Installation/Patching/Upg...
  • Oracle Database backup/restore/duplication
  • Oracle Cloud Control Support & Administration
  • Oracle Database Performance & Tuning
  • Oracle Database Administration - OCI/Exadata
  • Oracle Administration - Advanced Features (Data Guard)
  • Oracle Administration - Advanced Features (Partitioning)
  • OCI / Exadata Certification
  • Oracle Administration - Advanced Features (RAC)

  • Oracle DBA

    2 weeks ago

    Richmond, United States TechnoGen Full time

    Job Title:- Database Administrator - II Locations:- 22001 Loudoun County Pkwy, Ashburn, VA (VA0045)-USA Visa:GC/USC Kindly share candidate details. **** ****Working Model: Hybrid- Looking for local , We're in the office 2days per month. First and Third Wed each month Description: Responsibility shall include overall maintenance, administration, monitoring...

  • Data Warehouse Architect

    1 month ago

    richmond, United States Software Technology Inc. Full time

    Description: In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Data architect to provide data intake, data governance, data transformation, data quality, data Lineage, metadata and master data management, data virtualization, data services and consumption. Extensive experience with cloud infrastructure.We are...

  • Data Warehouse Architect

    1 month ago

    Richmond, United States Software Technology Inc. Full time

    Description: In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Data architect to provide data intake, data governance, data transformation, data quality, data Lineage, metadata and master data management, data virtualization, data services and consumption. Extensive experience with cloud infrastructure.We are...

  • Data Warehouse Architect

    1 month ago

    richmond, United States Software Technology Inc. Full time

    Description: In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Data architect to provide data intake, data governance, data transformation, data quality, data Lineage, metadata and master data management, data virtualization, data services and consumption. Extensive experience with cloud infrastructure.We are...

  • Data Warehouse Technical Architect

    1 month ago

    richmond, United States Vector Consulting, Inc Full time

    Our government client is looking for an experienced Data Warehouse Technical Architect on a hybrid 12+ months renewable contract role in Richmond, VA.Notes:Position is Hybrid - In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Preference would be someone local to Richmond or Driving distance from Central Office.We...

  • Data Warehouse Technical Architect

    1 month ago

    richmond, United States Vector Consulting, Inc Full time

    Our government client is looking for an experienced Data Warehouse Technical Architect on a hybrid 12+ months renewable contract role in Richmond, VA.Notes:Position is Hybrid - In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Preference would be someone local to Richmond or Driving distance from Central Office.We...

  • VDOT Programmer Analyst 4Datawarehouse Technical Architect

    1 month ago

    Richmond, United States Cyber Resource Full time

    Engagement Type Contract Short DescriptioN In office 12 days for first 3 months then the resource should be in office every Wednesday. Preference would be someone local to Richmond or Driving distance from Central Office. Complete Description Data architect to provide data intake data governance data transformation data quality data Lineage metadata...

  • Data Warehouse Technical Architect

    1 month ago

    Richmond, United States Vector Consulting, Inc Full time

    Our government client is looking for an experienced Data Warehouse Technical Architect on a hybrid 12+ months renewable contract role in Richmond, VA.Notes:Position is Hybrid - In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Preference would be someone local to Richmond or Driving distance from Central Office.We...

  • Data Warehouse Technical Architect

    3 weeks ago

    Richmond, VA, United States Vector Consulting, Inc Full time

    Our government client is looking for an experienced Data Warehouse Technical Architect on a hybrid 12+ months renewable contract role in Richmond, VA.Notes:Position is Hybrid - In office 1-2 days for first 3 months, then the resource should be in office every Wednesday. Preference would be someone local to Richmond or Driving distance from Central Office.We...