Subject Matter Expert (Support&Ops) (IN)

HCLTech

Fresher India Full Time Work from office
HCLTech logo
Posted : today
Actively hiring

Job description

Join our Operations team as a Subject Matter Expert specializing in Oracle databases. This role focuses on ensuring the robust health and performance of our Oracle environments.

We are seeking an individual with a deep understanding of Oracle database installation, administration, and troubleshooting. Your expertise will be crucial in maintaining system stability and optimizing database operations.

This is an opportunity to leverage your specialized knowledge in a dynamic support environment, contributing to the reliability of critical database systems.

Responsibilities

Key responsibilities include the installation of Oracle software and database prerequisites, alongside comprehensive Oracle database basic administration and managing the latest features.

You will be responsible for maintaining instance parameters and system settings, migrating databases using various tools like SQL*Loader, Import/Export, and Data Pump.

Additional duties involve applying and testing security patches, managing user accounts, cloning databases using cold/hot backups and RMAN, and performing capacity planning for database growth. You will also manage automated file and storage, implement database security policies, and ensure database availability and resource management.

Qualifications

Ideal candidates will possess a strong understanding of Oracle database administration, including installation, parameter maintenance, and system settings.

Experience with database migration tools, security patching, user account management, and various backup and cloning techniques (cold, hot, RMAN) is essential.

A solid grasp of Oracle 10g/11g features such as Data Pump, ASM, and Flashback Recovery, coupled with performance tuning and monitoring skills using tools like AWR and TKPROF, is required. Familiarity with availability management, resource management, and task scheduling for databases is also expected.

Essential Skills

Oracle Software InstallationDatabase AdministrationInstance Parameter MaintenanceSystem Settings ManagementDatabase Migration (SQL*LoaderImport/ExportData Pump)Security PatchingUser Account ManagementDatabase Cloning (Cold BackupHot BackupRMAN)Capacity PlanningAutomated File ManagementStorage ManagementOracle 10g/11g Features (Data PumpASMFlashback Recovery)Performance TuningPerformance Monitoring (AWRTKPROFExplain Plan)Availability ManagementDatabase Resource ManagementTask SchedulingDatabase Backups (Logical & Physical)Database Security Policy Implementation

Highlights

  • Actively hiring

More Details

RoleSubject Matter Expert (Support&Ops) (IN)
Employment TypeFull Time, Work from office

About the Company

HCLTech logo

HCLTech

IT Consulting