Subject Matter Expert (Support&Ops)

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