Oracle DBA Senior SME

Role: Technical SME, Cloud Database Operations 
Relevant Oracle Experience: 15+ years  Relevant Cloud Experience: 3+ years Location- Anywhere in india

Mandatory skills-

1. Oracle DB hosted in Azure cloud
2. managing PaaS database instances on Azure
3. Performance Tuning skills  
4. SME management on Real application clusters (RAC), ASM and Data Guard
5. Terraform knowledge - Infrastructure as Code (IaC) principles for managing Oracle database environments

Above 5 are mandatory

1. Redis  Paas and Mongo DB skills are desired
2. Knowledge in Microsoft SQL server are desired 

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)

Key Competencies • Certified in Oracle • Certified in Azure and Terraform • Excellent verbal and written communication skills • Self-motivated individual capable of independent work • Passion to learn, upskill and excel • Customer service orientation • Problem analysis and solving skills • Planning and organizing, attention to detail