Oracle DBA

Overview

Our client is hiring a Oracle DBA on a long-term contract basis.

Work Location: Alpharetta, Georgia

Work Model: Hybrid

General Database Engineer Duties and Responsibilities

• Provide guidance and support to Application team
• Install, tune, implement and upgrade DBMS installations
• Write and deploy SQL patches
• Process work accurately and in a timely manner
• Always paying attention to the detail
• Urgency
• Proactively and regularly make recommendations for system improvements
• Collate, prepare, and present statistical information for internal and external use
• Looking for:
  Oracle-SME, Redis or any NOSQL database (Good to have), Automation/Scripting (Ansible, Python, Shell), Linux (must)
• Note:
  
  NO DEVELOPERS PLEASE, Looking for DBA (Database Administrator)
• Write and Maintain Database Programs
• Design New Databases
• Monitor Databases and Programs
• Write Programs and Scripts
• Troubleshooting
• Debugging
• Review Database Reports

• Expertise in Installation, Upgrade & Patching of different components in Oracle like RAC, Data-Guard, RMAN, OEM, ASM, Partitioning etc., and experience with the other platforms we manage listed in the Duties and Responsibilities.
• Experience with Replication including setup, troubleshooting issues and failovers (Goldengate or HVR)
• Monitor all systems (work processes, users, system logs, short dumps, locks, developer traces, system traces, disk space, etc.).
• Ensure production uptime service levels are maintained and made available per requirements that include backup, recovery, refresh, performance tuning, and security
• Provide data cleansing services, verify data integrity, and implement access controls
• Provide routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management
• Experience with Schema creation, deployment, and maintenance
• Experience with Setting up and configuration of Auditing, audit trails
• Carry out recovery of databases in an event of log full, system crash Troubleshoot issues related to the installation for our supported platforms
• Should have knowledge of Disaster Recovery setup and maintenance
• Automation using shell-script, python, Ansible, go, etc.
• Performance & Tuning Related Expertise
• Experience with Performance analysis, monitoring of queries and platform specific tuning.

Pay Rate: $60 – $70

Job : 84249