Postgresql along with cloud and Immediate joiner

Job Description

Oracle DBA SME with Azure Cloud and On Prem Exp MUST(105263)

Role: Technical SME, Cloud Database Operations
Relevant Oracle Experience: 15+ years
Relevant Cloud Experience: 3+ years

Location- Anywhere in india:

Primary Skills:

• Oracle Database & PaaS services
• Azure Cloud platform
• IaC – Infrastructure as Code using Terraform

Secondary Skills:

• Automation
• Oracle Performance tuning

Job Description:

• Candidate must be proficient in Advance performance tuning & trouble-shooting

• Key skills – Performance tuning , security hardening, automation (PowerShell ,

• Terraform, ARM /Bicep), HA/DR and cost optimization

• Responsible for Pre-installation tasks, installing Oracle DB and Patch Mgmt.

• Should have strong knowledge of Database Upgrade, Migration, Patch Installation,
  and Implementation.

• Deploy and manage Terraform codes, ability to troubleshoot

• Solid understanding of Ansible playbooks, ability to manage Ansible tower

• Focus on automation through Ansible and Terraform

• Responsible for installations and configuration of Oracle Database 12c/19c on Unix
  platform in standalone and RAC environment.

• Specialized in Oracle RAC, good understanding of the complexity of RAC Architecture
  across Servers, OS, network, storage layer.

• Troubleshooting node eviction.

• Strong knowledge of ASM and disk management.

• Strong Knowledge of RMAN Backup & recovery management and troubleshooting
  backup issues.

• Strong Knowledge of AWR, ADDM reports, explain plan monitoring, analysis, and
  troubleshooting.

• Should have SQL tuning skills and experience in refactoring SQL queries to improve
  performance.

• Should have knowledge on Database Connectivity issues, slow response, operations
  timed out, Database incident and error resolution.

• Azure cloud exposure in terms of portal navigation, core components, monitoring
  and bit of security

• Sensitivity: Internal & Restricted

• Excellent problem-solving skills should be able to transverse across infrastructure
  layers to diagnose issues.

• Write and troubleshoot shell scripting, SQL and PL/SQL Scripts.

• Work on High Priority Incidents , High change tickets and manage vendor problem
  tickets.

• Proven experience in automation and orchestration and worked on automaton
  scenarios for one touch solutions

• Experience in Devops, Terraform integration with Ansible knowledge and knowledge
  on Shell & PS Scripting is added advantage

• Knowledge in Paas database maintenance ,Redis etc is added advantage

• Cross functional in any other RDBMS (Microsoft SQL, Postgree SQL) or No SQL open
  source database is an plus

• Complete ITIL knowledge and handling Problem management ticketing for database
  including providing RCA for Priority critical Incidents like P1,P2 by offering technical
  solutions to issues on Oracle database and attending severity calls with business is
  mandatory and must

• Key Skills

• Oracle Database – Infrastructure & PaaS (mandatory)

• Azure Cloud (Mandatory)

• Hands-on experience deploying and managing database services in public clouds using

• Azure and GCP.

• Cloud Automation with Terraform in production environment (Mandatory)