Subject Matter Expert (Support&Ops)

HCLTech · United States

Apply on the company website

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

More jobs at HCLTech