Job Responsibilities:

• Adhering to SLAs
• Reporting to the Track Lead / Team Lead
• Helping team members in case of Issues/Technical Problems
• Handling tickets / requests
• Troubleshooting technical issues
• Ensuring that the processes are adhered to
• Responsible for successful completion of Installation, configuration and migration
• Ensure maximum uptime according to the SLA
• Responsible for building / maintaining a test environment
• Improves and maintains customer and employee satisfaction
• Implementing new technologies and design changes
• Implementing Backup/Restoration Strategy for 24x7 operation support
• Applying patches/upgrades to maintain security level Technical Requirements
• Installation of Oracle Software/Database Pre-requisites
• Oracle Database 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 Planning 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
• Availability Management for Databases
• Database Resource Management and Task Scheduling
• Scheduling Database Backups, taking Logical Backups & Physical Backups
• Implementing Database Security Policy.

Soft Skills:

• Excellent communication and conversation skills (Verbal and Written)
• Good documentation skills
• Good working knowledge of MS OFFICE
• Should have a good customer handling skill
• Able to handle unforeseen situations
• High level of acceptance
• Can drive HCL’s value and its methodology

Other Skills / Experience:

• Worked on Production systems
• Experience with Database Migration, Installation, Upgrades and Patching - Datacenter understanding
• Knowledge of Other RDBMS is a Plus
• Experience in PL/SQL and worked on ER Diagrams
• Working Knowledge on Cluster ware