Subject Matter Expert (Support&Ops)

Technology, Data & Digital · IT Infrastructure & Security · Database Administration

Smart Summary

AI-generated overview of this position

HCLTech is seeking a Subject Matter Expert (Support&Ops) in Gautam Buddha Nagar, India. This role involves comprehensive Oracle database administration, including installation, migration, security patching, performance tuning, and backup management. The ideal candidate will have strong knowledge of Oracle 10g/11g features and experience with various database tools and techniques.

Job Summary

- Installation of Oracle Software/Database Pre-requisites. - Oracle Datbase Basic Administration and Latest Features. - Maintain instance parameters and system settings - Migrating databases using various tools such as SQL*Loader, Import/Export and Data pump. - Applying and Testing security patches to the databases. - Managing User Accounts. - Experience in cloning using cold backup, hot-backup and RMAN backup. - Capacity Planing in terms of Growth of Database. - Automated File and Storage Management. - Good knowledge of 10g/11g features as Data Pump, ASM and Flash back recovery. - Experience in basic Performance Tuning and Monitoring using various tools such as AWR,TKPROF and Explain Plan. - Availibility Management for Databases. - Database Resource Management and Task Scheduling. - Scheduling Database Backups,taking Logical Backups & Physical Backups. - Implementing Database Security Policy.

Key Responsibilities

Installation of Oracle Software/Database Pre-requisites. - Oracle Datbase Basic Administration and Latest Features. - Maintain instance parameters and system settings - Migrating databases using various tools such as SQL*Loader, Import/Export and Data pump. - Applying and Testing security patches to the databases. - Managing User Accounts. - Experience in cloning using cold backup, hot-backup and RMAN backup. - Capacity Planing in terms of Growth of Database. - Automated File and Storage Management. - Good knowledge of 10g/11g features as Data Pump, ASM and Flash back recovery. - Experience in basic Performance Tuning and Monitoring using various tools such as AWR,TKPROF and Explain Plan. - Availibility Management for Databases. - Database Resource Management and Task Scheduling. - Scheduling Database Backups,taking Logical Backups & Physical Backups. - Implementing Database Security Policy.

Skill Requirements

Installation of Oracle Software/Database Pre-requisites. - Oracle Datbase Basic Administration and Latest Features. - Maintain instance parameters and system settings - Migrating databases using various tools such as SQL*Loader, Import/Export and Data pump. - Applying and Testing security patches to the databases. - Managing User Accounts. - Experience in cloning using cold backup, hot-backup and RMAN backup. - Capacity Planing in terms of Growth of Database. - Automated File and Storage Management. - Good knowledge of 10g/11g features as Data Pump, ASM and Flash back recovery. - Experience in basic Performance Tuning and Monitoring using various tools such as AWR,TKPROF and Explain Plan. - Availibility Management for Databases. - Database Resource Management and Task Scheduling. - Scheduling Database Backups,taking Logical Backups & Physical Backups. - Implementing Database Security Policy.

Other Requirements

 Installation of Oracle Software/Database Pre-requisites. - Oracle Datbase Basic Administration and Latest Features. - Maintain instance parameters and system settings - Migrating databases using various tools such as SQL*Loader, Import/Export and Data pump. - Applying and Testing security patches to the databases. - Managing User Accounts. - Experience in cloning using cold backup, hot-backup and RMAN backup. - Capacity Planing in terms of Growth of Database. - Automated File and Storage Management. - Good knowledge of 10g/11g features as Data Pump, ASM and Flash back recovery. - Experience in basic Performance Tuning and Monitoring using various tools such as AWR,TKPROF and Explain Plan. - Availibility Management for Databases. - Database Resource Management and Task Scheduling. - Scheduling Database Backups,taking Logical Backups & Physical Backups. - Implementing Database Security Policy.

Key Sourcing Information : NA

Interviewer 1 SAP ID : 51974178

Job Description : - Installation of Oracle Software/Database Pre-requisites. \\\\r\\\\n- Oracle Datbase Basic Administration and Latest Features. \\\\r\\\\n- Maintain instance parameters and system settings \\\\r\\\\n- Migrating databases using various tools such as SQL*Loader, Import/Export and Data pump. \\\\r\\\\n- Applying and Testing security patches to the databases. \\\\r\\\\n- Managing User Accounts. \\\\r\\\\n- Experience in cloning using cold backup, hot-backup and RMAN backup. \\\\r\\\\n- Capacity Planing in terms of Growth of Database. \\\\r\\\\n- Automated File and Storage Management. \\\\r\\\\n- Good knowledge of 10g/11g features as Data Pump, ASM and Flash back recovery. \\\\r\\\\n- Experience in basic Performance Tuning and Monitoring using various tools such as AWR,TKPROF and Explain Plan. \\\\r\\\\n- Availibility Management for Databases. \\\\r\\\\n- Database Resource Management and Task Scheduling. \\\\r\\\\n- Scheduling Database Backups,taking Logical Backups & Physical Backups. \\\\r\\\\n- Implementing Database Security Policy. \\\\r\\\\n

#oracle#database#support#operations#administration#migration#security#performance tuning#backup#on-site
HCLTech Logo

Company

HCLTech

Job Posted

3 weeks ago

Employment Type

Full Time

WorkMode

On Site

Experience Level

Mid-Senior

Locations

Gautam Buddha Nagar, India

Applicants

Be an early applicant