Principal Database Administrator

Job Title : Principal Database Administrator - Python / Shell scriptingJob Location : BengaluruExp Range : 8 years - 15 yearsPosition overview : We are looking for candidates having strong database experience on Oracle RAC and scripting experience on Python / Shell scripting Roles & Responsibilities : · 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.Preferred QualificationsTechnical· Strong Computer Science or equivalent Academic background (BE/MTech or MS) and minimum 7 years of experience in database environments and configuring/or testing/or administrating in Oracle 12c, 19c.· Strong Computer Science skills with B.E/BTech/MS/MTech with major in CS (preferred) or other areas.· 6+ years of hands-on experience with systems engineering on Linux (troubleshooting, scripting, administration, user/kernel), networking and storage resources.· 6+ years of programming and scripting experience in Python, Shell.· Must have experiences on Linux and experience with Oracle Database, RAC is a big plus.· Experience with Exadata is a big plus.· Well versed with Clusterware tools - ocrconfig, ocrcheck, ocrdump, crsctl, srvctl and crsctl query catalog and expertise with CRS, CSS, Oracle ASM, Cluster time synchronization service, EVM, GNS, oraagent, ONS and Oracle root agent· Experience in Linux/Unix is must and experience on Solaris is a plus PRB