Oracle DBA

Job Description
**mandatory SN Required Information Details 1 Role** Oracle DBA 2 Required Technical Skill Set** Oracle DBA 3 No of Requirements** 4 Desired Experience Range** 3-7 years 5 Location of Requirement PAN India Desired Competencies (Technical/Behavioral Competency) Must-Have**
(Ideally should not be more than 3-5) Oracle installation and Configuration on Linux/Windows OS platform, configuring HA, DR databases, Database upgrades and applying PSU packs, Hands on experience in writing/troubleshooting shell scripts/Perl/python Good-to-Have Knowledge of Cloud computing technologies, Real Application Cluster SN Responsibility / Expectations from the Role 1 Strong working knowledge of Oracle 12C, 18C and 19C. Knowledge of 21C will be added advantage. 2 Perform day-to-day administration of Oracle databases, including backup/recovery, Capacity planning and performance tuning. 3 Very good knowledge about Oracle Architecture, RAC, High Availability and DR solution and OEM 4 Configuring High Availability and DR solution with DGMGRL 5 Upgrading oracle databases to latest versions 6 Applying latest Fix-Packs as per requirements 7 Monitor database performance and recommend improvements for operational efficiency 8 Database performance tuning by configuring database parameters. 9 Monitor the Oracle Alert logs files, transaction logs, archive logs and backup log 10 Day to day activities like TS, backup, cronjob, OEM alert 11 Experience with Data-Guard, Cloning, RMAN backups, Golden Gate and point in time recovery, ASM 12 Monitor system's health and performance 13 Perform Database maintenance like, Reindexing, Update Statistics and review and optimize query tuning. 14 Perform scheduled maintenance and support release deployment activities after hours 15 Review Hardware and configuration and suggest the improvement areas. 16 Hands on setting up DR environment and experience in DR testing. 17 Manage database security and make sure it's complied policies, regular audit of security processes 18 Familiarity with monitoring tools like Confio, Solarwind and splunk etc. 19 Good knowledge in Linux operating system and hands on experience in writing shell scripts/Perl/python, with this scripting knowledge, should explore automating the repetitive tasks 20 Refine and automate regular processes, track issues and document changes 21 Independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution 22 Capacity planning, space management and data maintenance activities for database system. Perform database enhancement and modification as per the requirements. 23 Global On-call Support including weekend 24 Regular Connect with Client 25 Operational Shift support as per Roster 26 Willing to learn and work on other Opensource/ DB technologies like DB2, PostgreSQL, MySQL 27 Knowledge of ITSM process and ticketing tool like ServiceNow /REMEDY etc.