Subject Matter Expert (Support&Ops)

Job Description

Subject Matter Expert (Support&Ops)

Noida, Uttar Pradesh

Job Summary

Job description:\\\ \\\ The Oracle Database Administrator is responsible for configuring, administering, and maintaining the Oracle database environments.\\\ Responsibilities include database upgrades, patching, security, troubleshooting and issue resolution, backup procedures, and performance tuning.\\\ In addition, application DBA s will provide support and direction to developers and other support personnel as needed.\\\ Daily 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.\\\ Exadata knowledge \\\ \\\ \\\ 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

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 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

Other Requirements

Replacement for \Kundan Kumar, 52252720\

Apply now

Information at a Glance

Why HCLTech?

At HCLTech, youll supercharge your potential. Youll find your career. And youll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.