Senior Oracle DBA - HYBRID

Overview

Remote
Depends on Experience
Contract - Independent
Contract - W2
Contract - 07 Month(s)

Skills

Amazon Web Services
Oracle
Linux
Backup Administration
SQL
Shell Scripting
Oracle Exadata

Job Details

Job Description:

***Crop to Crop resumes are accepted

Primary responsibilities include managing the application schema, design, and extensions within the database for development, test, and production environments for Oracle database on Linux platform. The responsibilities also include database technical support, performance tuning, application administration and consulting, and providing support for Oracle, Oracle Data guard, Oracle Exadata.

This resource will serve in a key role in the managing Oracle database on AWS cloud platform, Lead the development of procedures and best practices for effective database for high volume application system and providing database solution for application modernization.

This position is responsible for performing tasks associated with the Leading the management of the application schema, design, and extensions within the database, in development, test and production environments.

Some of the key duties:

  • Provision and manage Oracle database instances on AWS/Linux
  • Set up replication and high availability for Oracle databases using tools like Golden gate
  • Monitor Oracle database performance and Troubleshoot Oracle database problems
  • Perform backups and restores of Oracle databases
  • Work with application developers to identify and refine data requirements, table/database design, assist in SQL writing

Required Skills:

Demonstrable skills in designing schema, access patterns, locking strategy, and tuning Oracle Databases in an enterprise environment

Modifying the database structure, creation, and update to existing database objects per application needs

Experience in configuring, monitoring, and Cache management for Oracle database servers

Must have experience in implementing and supporting Oracle on AWS/Linux platform

Strong experience in allocating system storage and planning future storage requirements for the database system

Understanding of Exadata's hardware and software components, including storage cells, InfiniBand networking, and Smart Scan technology.

Experience with managing storage using Oracle Automatic Storage Management (ASM)

Proficiency in one or more shell scripting languages

Experience authoring code in SQL, PL/SQL

Designing and implementing backup/restore service and disaster recovery (DR) solutions

Installing and upgrading the database software, Patching the software that powers database

Good Analytical,Technical,TimeManagement and Communication Skills

Participate in on-call rotation and weekend work

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Chandra Technologies, Inc.