Oracle Database Administrator

Role: Database Administrator (Oracle & AWS)

Duration: Full time / Permanent role

Location: Alameda CA (Onsite from Day 1)

Senior profiles 14 years

DBA:

Database Administrator (DBA) should be able to handle tasks on a hybrid environment in on premise and AWS cloud which include deployment administration and optimization of databases hosted on Amazon Web Services (AWS) infrastructure.

Deploying and configuring Oracle 19c (and later versions) database systems both on EC2 as well as an RDS instance

Performing routine maintenance tasks like Oracle backups restores and security measures to ensure the integrity and availability of data. This includes monitoring database performance diagnosing and resolving issues and optimizing database configurations for better performance. Debugging DB Job failures (such as archive logs backup failures increasing swap space

Monitoring database performance metrics and scaling database resources up or down as needed to accommodate changes in workload. Optimizing database queries indexes and configurations to improve performance and reduce latency. Setting up Rubrik reports and Rubrik Agents on DB EC2 servers for Infrastructure reporting.

Implementing and maintaining security measures to protect databases from unauthorized access data breaches and other security threats.

This may involve configuring AWS security groups IAM (Identity and Access Management) policies encryption and compliance with industry standards.

Implementing strategies for high availability and disaster recovery to ensure continuous access to data in case of system failures or disasters. This may involve setting up multiAZ deployments database replication failover procedures and automated backups.

Automating DB tasks such as patching updating variable sets analysing metrics disk space using Ansible.

AWS,Oracle,Rubrics,Ansible,Amazon RDS,EC2