Principal Database Administrator
bangalore
Job Title : Principal Database Administrator - Python / Shell scripting
Job Location : Bengaluru
Exp Range : 8 years - 15 years
Position 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 Qualifications
Technical
· 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