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)