Subject Matter Expert (Support&Ops)

Job description

Job description:\\\\r\\\\n\\\\r\\\\nThe Oracle Database Administrator is responsible for configuring, administering, and maintaining the Oracle database environments.\\\\r\\\\nResponsibilities include database upgrades, patching, security, troubleshooting and issue resolution, backup procedures, and performance tuning.\\\\r\\\\nIn addition, application DBA s will provide support and direction to developers and other support personnel as needed.\\\\r\\\\nDaily responsibilities include monitoring production environment, providing acceptable system performance, and assuring data is protected and recoverable as required and assuring data is protected and recoverable as required.\\\\r\\\\nExadata knowledge \\\\r\\\\n\\\\r\\\\n\\\\r\\\\nKey Responsibilities:\\\\r\\\\n\\\\r\\\\nInstallation, configuration, tunning, patching, refreshes and upgrading database environment using different utilities.\\\\r\\\\nSetting up and monitoring standby databases, DR-Drill, backup and recovery techniques, diagnose and correct performance problems.\\\\r\\\\nProven experience managing database configurations.\\\\r\\\\nManaging database Users, Roles, Profiles, Permissions and Security. Create and publish database health check reports.\\\\r\\\\nPerform regular maintenance activities.\\\\r\\\\nMonitoring Space management, users activities, and resource utilization. Ability to independently maintain and administer databases.\\\\r\\\\nAbility to learn and adapt procedures, processes, and new technologies quickly.\\\\r\\\\nGood logical and analytical skill.\\\\r\\\\nGood communication skill.\\\\r\\\\nCollaborate with other team members and stakeholders\\\\r\\\\nGood understanding of Oracle database concepts and structures on various in-house and cloud platforms.\\\\r\\\\nOracle database skills and Unix operating system understanding is required.\\\\r\\\\nGood Knowledge of architecture and configuration of latest Oracle versions. Good experience of patching, cloning, security, backup and recovery procedures, node addition, deletion, replication setup and DR-Drill activities. Good understanding of Performance Tuning, Query Optimization, Client/Server Connectivity.\\\\r\\\\nExperience of writing shell scripts as well as knowledge in general system administration tasks.\\\\r\\\\nExperience of setting up Oracle high availability [RAC, Dataguard] environment using various tools.\\\\r\\\\nExperience of database administration, development, maintenance, and production support.\\\\r\\\\nExperience of managing Oracle databases on various cloud environments. Experience of identifying performance problems and optimization of database performance.\\\\r\\\\nExperience on planning and Performing optimal Backup and Recovery solutions.\\\\r\\\\nGood knowledge of RAC, ASM, RMAN, Dataguard, Datapump and other Oracle utilities.\\\\r\\\\nGood understanding of SQL and PLSQL Procedures, Functions, triggers. Good in providing guidance to the development team in optimizing SQL statements.\\\\r\\\\nGood understanding on deploying code moves as part of change management.\\\\r\\\\nProficient in performing the recovery of the Oracle database files in various recovery scenarios.\\\\r\\\\nAnalyzing SQL, tuning parameters, optimizing SGA, using AWR/ADDM/OEM, leveraging Exadata\\\\\\\'s Smart Scan/RDMA.\\\\r\\\\nStrong trouble shooting and problem-solving skills.\\\\r\\\\nAbility to work well in teams with good oral, written, and interpersonal skills.\\\\r\\\\nExperience of managing optimizing, and maintaining high-performance Oracle databases on Exadata system.\\\\r\\\\nManaging storage cells, compute nodes, Infiniband, and using Oracle Enterprise Manager (OEM).\\\\r\\\\nShareplex basics Key Responsibilities Key Responsibilities: Installation, configuration, tunning, patching, refreshes and upgrading database environment using different utilities. Setting up and monitoring standby databases, DR-Drill, backup and recovery techniques, diagnose and correct performance problems. Proven experience managing database configurations. Managing database Users, Roles, Profiles, Permissions and Security. Create and publish database health check reports. Perform regular maintenance activities. Monitoring Space management, users activities, and resource utilization. Ability to independently maintain and administer databases. Ability to learn and adapt procedures, processes, and new technologies quickly. Good logical and analytical skill. Good communication skill. Collaborate with other team members and stakeholders Good understanding of Oracle database concepts and structures on various in-house and cloud platforms. Oracle database skills and Unix operating system understanding is required. Good Knowledge of architecture and configuration of latest Oracle versions. Good experience of patching, cloning, security, backup and recovery procedures, node addition, deletion, replication setup and DR-Drill activities. Good understanding of Performance Tuning, Query Optimization, Client/Server Connectivity. Experience of writing shell scripts as well as knowledge in general system administration tasks. Experience of setting up Oracle high availability [RAC, Dataguard] environment using various tools. Experience of database administration, development, maintenance, and production support. Experience of managing Oracle databases on various cloud environments. Experience of identifying performance problems and optimization of database performance. Experience on planning and Performing optimal Backup and Recovery solutions. Good knowledge of RAC, ASM, RMAN, Dataguard, Datapump and other Oracle utilities. Good understanding of SQL and PLSQL Procedures, Functions, triggers. Good in providing guidance to the development team in optimizing SQL statements. Good understanding on deploying code moves as part of change management. Proficient in performing the recovery of the Oracle database files in various recovery scenarios. Analyzing SQL, tuning parameters, optimizing SGA, using AWR/ADDM/OEM, leveraging Exadata\'s Smart Scan/RDMA. Strong trouble shooting and problem-solving skills. Ability to work well in teams with good oral, written, and interpersonal skills. Experience of managing optimizing, and maintaining high-performance Oracle databases on Exadata system. Managing storage cells, compute nodes, Infiniband, and using Oracle Enterprise Manager (OEM). Shareplex basics Skill Requirements Key Responsibilities: Installation, configuration, tunning, patching, refreshes and upgrading database environment using different utilities. Setting up and monitoring standby databases, DR-Drill, backup and recovery techniques, diagnose and correct performance problems. Proven experience managing database configurations. Managing database Users, Roles, Profiles, Permissions and Security. Create and publish database health check reports. Perform regular maintenance activities. Monitoring Space management, users activities, and resource utilization. Ability to independently maintain and administer databases. Ability to learn and adapt procedures, processes, and new technologies quickly. Good logical and analytical skill. Good communication skill. Collaborate with other team members and stakeholders Good understanding of Oracle database concepts and structures on various in-house and cloud platforms. Oracle database skills and Unix operating system understanding is required. Good Knowledge of architecture and configuration of latest Oracle versions. Good experience of patching, cloning, security, backup and recovery procedures, node addition, deletion, replication setup and DR-Drill activities. Good understanding of Performance Tuning, Query Optimization, Client/Server Connectivity. Experience of writing shell scripts as well as knowledge in general system administration tasks. Experience of setting up Oracle high availability [RAC, Dataguard] environment using various tools. Experience of database administration, development, maintenance, and production su