Oracle DBA Senior SME

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

Primary Skills:Oracle Database PaaS servicesAzure Cloud platformIaC Infrastructure as Code using Terraform Secondary Skills: AutomationOracle 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 Unixplatform in standalone and RAC environment. Specialized in Oracle RAC, good understanding of the complexity of RAC Architectureacross Servers, OS, network, storage layer. Troubleshooting node eviction. Strong knowledge of ASM and disk management. Strong Knowledge of RMAN Backup recovery management and troubleshootingbackup issues. Strong Knowledge of AWR, ADDM reports, explain plan monitoring, analysis, andtroubleshooting. Should have SQL tuning skills and experience in refactoring SQL queries to improveperformance. Should have knowledge on Database Connectivity issues, slow response, operationstimed out, Database incident and error resolution. Azure cloud exposure in terms of portal navigation, core components, monitoringand bit of securitySensitivity: Internal RestrictedExcellent problem-solving skills should be able to transverse across infrastructurelayers to diagnose issues. Write and troubleshoot shell scripting, SQL and PL/SQL Scripts. Work on High Priority Incidents , High change tickets and manage vendor problemtickets. Proven experience in automation and orchestration and worked on automatonscenarios for one touch solutions Experience in Devops, Terraform integration with Ansible knowledge and knowledgeon 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 opensource database is an plus Complete ITIL knowledge and handling Problem management ticketing for databaseincluding providing RCA for Priority critical Incidents like P1,P2 by offering technicalsolutions to issues on Oracle database and attending severity calls with business ismandatory and must

Key SkillsOracle Database Infrastructure PaaS (mandatory)Azure Cloud (Mandatory)Hands-on experience deploying and managing database services in public clouds usingAzure and GCP.Cloud Automation with Terraform in production environment (Mandatory)

Key CompetenciesCertified in OracleCertified in Azure and TerraformExcellent verbal and written communication skillsSelf-motivated individual capable of independent workPassion to learn, upskill and excelCustomer service orientationProblem analysis and solving skillsPlanning and organizing, attention to detail