Oracle Database Administrator Specialist

***THIS ROLE IS NOT OPEN FOR SPONSORED CANDIDATES AT THIS TIME!***

***THE CLIENT HIGHLY PREFERS CANDIDATES TO BE ONSITE (HYBRID) IN MCLEAN, VA OR PLANO, TX OR ATLANTA, GA; 3 DAYS A WEEK!***

Oracle Database Administrator Specialist

Duration: 12 months. Opportunity for conversion.

Years of experience: 10+

Must Have:10+ years of experience with Oracle, 3 years of experience with Aurora, 5+ years of experience with Shell scripts OR Ansible and 2+ years of experience with Cloud Development.

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.

Preferred Skills:

• Experience supporting Oracle on prem and Aurora Postgres on AWS.
• Experience with AWS CFT development.
• Experience with Database monitoring tools.
• Excellent written and verbal communication skills.
• Experience working in virtual environment using VMware.
• Database and Cloud vendor certification.