Principal Database Administrator - Oracle internals
Oracle
Bangalore, Karnataka
Permanent
Full-time
23 days ago
Job Title : Principal Database Administrator- Oracle internals 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.
