Job description
<p>Oracle Database Administrator :<br/><br/>Responsibilities :<br/><br/>Direct Responsibilities :<br/><br/>1.
Responsible for installation, configuration and managing the database (Oracle 19c)servers and applying the security patches.<br/><br/>2.
Remediating the vulnerabilities.
Database performance tuning.<br/><br/>3.
In addition, also provide and maintain the high availability (Clustering) and BCP/DR Recovery database solutions.<br/><br/>4.
Responsible to develop ITIP Information Management Dashboards including risk analysis, current projects etc for different functions / clients.<br/><br/>5.
Establish excellent working relationships with different functions across various regions.<br/><br/>6.
Ensure rigorous follow up and communication to stakeholders on estimated delivery timelines of Projects<br/><br/>7.
Analytical mindset in troubleshooting and resolving database problems<br/><br/>8.
Good understanding in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools<br/><br/>9.
Manage and maintain multiple Oracle database instances across development, testing, and production environments.<br/><br/>10.
Perform routine database administration tasks including installation, configuration, patching, and upgrades of Oracle Database software.<br/><br/>11.
Monitor and optimize database performance, ensuring high availability and responsiveness.<br/><br/>12.
Implement backup and recovery strategies to safeguard data integrity and minimize downtime.<br/><br/>13.
Collaborate with cross-functional teams to support application development and deployment.<br/><br/>14.
Assist in database design, schema management, and capacity planning.<br/><br/>15.
Provide application upgrade support for minor releases.<br/><br/>16.
Assist in debugging of application related issues.<br/><br/>17.
Execute DLL for Database objects with scripts provided by apps teams.<br/><br/>18.
Provide application database upgrade support<br/><br/>19.
Execute data manipulation (insert, update, delete) / Transformation, masking, scrubbing scripts provided by apps/dev team.<br/><br/>20.
Provide response Time SLA attainment analysis for all the reported incidents.<br/><br/>21.
Check the Top sessions and SQLs using more CPU and high IO.<br/><br/>22.
Periodically check the tables without PK or indexes or having more indexes.<br/><br/>23.
Experience with backups, restores and recovery models.<br/><br/>Contributing Responsibilities :<br/><br/>1.
Develop assess and select proper strategy for the projects considering performance, Cost, Time and Scope Constraints<br/><br/>2.
Responsible to follow up and closing on all risk item identified by IG Audit or any other internal and external audits.<br/><br/>Technical & Behavioral Competencies :<br/><br/>1.
Oracle DBA with 12c and 19c experience on RHEL and Windows..<br/><br/>2.
Working experience on Cloud is desirable.<br/><br/>3.
Experience in core DBA, RAC and Dataguard implementation and monitoring activities and troubleshooting and Database Migration and upgrade activities.</p> (ref:hirist.tech)
Required Skill Profession
Computer Occupations