---

---

Location

Bangalore | India

---

Job description

Job Title : Principal Database Administrator- Performance Tuning Specialist Job Location : Bengaluru/Hyderabad/Noida/Pune /Mumbai Exp Range : 8 years - 20 years

Position Overview

: We are looking for Oracle DBA with hands on experience on Oracle internals : Memory Management , latching , Root cause analysis ,Debugging , latching , Query indexing , Performance Tuning and optimization

Skills Required :

·

Develop new test methodologies

across the database/systems stack to fully tap the capabilities offered by underlying layers (including network, storage and OS platform) of Engineered Systems. · Deep dive into specific layers of

Oracle RAC database

and Systems stack to identify bottlenecks at a granular layer levels and improve product quality so as to achieve overall robustness and reliability of the whole System. ·

Build and enhance automated, flexible and re-usable test frameworks

and applications for system testing at scale to expose product defects, regressions and verifying solutions. ·

Perform complete and end-to-end automation of System provisioning

and management tasks including

administration ,

deployment ,

patching , maintenance,

installations , network,

tech stack upgrades

and designing/build test framework to test and meet maximum high availability requirements on Oracle Engineered Systems. Specific tasks include OS upgrade, firmware and driver patch validation, kernel upgrades/rollbacks, platform management software patching/rollback etc. for the infrastructure. · Responsible for problem resolution of Oracle DBMS creating installation scripts and procedures troubleshoot network issues and resolve network connectivity issues. ·

Administration & Deployment of Oracle RAC (GUI & Silent Mode), ASM, and Oracle Clusterware Components on different OS platforms. · Perform adding and Deletion of Nodes, Workload Management, Administering Services,

Oracle RAC/ASM Troubleshooting , etc. · Basic understanding in performance tuning like generating

AWR, ADDM, ASH reports. · Review customer escalations and bridge testing gaps by enhancing existing test applications. · Ensure quality of new ease-of-use features to provide proactive, predictive, and lower risks to our customers. · Ensure quality of post-release patching by understanding new feature/enhancement and verifying various fixes. Log and track product defects as encountered. · Responsible for collecting and analyzing common trace files, network packet tracing, memory dumps, Oracle logs, RAC logs, analyze OS metrics for network, memory, processing and IO troubleshooting · Providing thought leadership to internal team members through internal webinars/meetings and act as the subject-matter-expert for the internal stakeholders to resolve technical deployment obstacles, spreading cloud-related knowledge to others in the organization.

---

Job tags

---

---

Salary