Oracle Database Administrator - McLean, United States - Zillion Technologies

Description

'This role is also open for Dallas, Texas and Atlanta, Georgia''not open to Sponsored candidates at this time'The Client is looking for a Oracle Database Administrator with automation experience.

The Database Administrator must have solid experience working in Oracle, Postgres Aurora, AWS, Automation with Shell scripting OR Ansible for on-prem, Automation with CFTs, Lambda functions, Terraform for cloud.

Responsibilities include installations, upgrades, configuration, backup/restore and disaster recovery (DR). The administrator will also need to examine existing CFTs, make modifications and if needed write new CFTs.


Responsibilities Include:

Provide DBA support on all aspects of databases administration including provisioning, backup/recovery, replication, deployment and real time production troubleshooting responsibilities on Oracle and Aurora Postgres.

Install, configure, monitor, upgrade and maintain database in production and non-production environments.
Provide 24x7 on call DBA support for production environment on rotation schedule and adhoc need basis.
Provide Database deployment support for Test and Production environments.
Diagnose and address database performance issues using performance monitors and various tuning techniques.
Interact with Systems administrators on Linux/Unix/VM operating systems issues related to Databases.
Able to write database provisioning, maintenance and reporting cloud automation scripts.
Configure and maintain Database High availability.
Support data replication and Sharding.
Troubleshoot database production problems and database connectivity issues.
Implement DR solutions.
Ability to work well as a team and as an individual with minimal supervision.


Cloud Development and Automation:
Utilize AWS services to develop and automate cloud-based solutions.
Implement and maintain automation scripts to enhance efficiency and scalability.
Leverage AWS Lambda for automation tasks like DB provisioning, deletion etc.


Basic Requirements:
More than 10 years of experience in Database administration.
Solid hands on experience (5+ years) with Aurora Postgres.
Extensive Database performance tuning experience.
Deep knowledge of industry-standard, enterprise-class best practices for a large database environment.
Good experience with AWS Cloud and Linux/VM platform.

Expertise in automation via AWS CFT/ Lambda functions (3+ years).Deep understanding of HA (High Availability), DR (Disaster Recovery), Database and storage technologies, Data replication.

Experience implementing, supporting and auditing database security.
Hands on automation experience with Python, YAML, Unix Shell scripting, etc.#J-18808-Ljbffr