Amritpal Singh Jassal

WORK HISTORY

EDUCATION

SKILLS

ABOUT AMRITPAL SINGH JASSAL

Year of IT experience as Oracle DBA ver.9i/10g/11g/12c/18c/19c on various Unix/Linux and Windows, Solaris platforms.Installed and configured oracle database server 10gR2/11g /12c on RED HAT ENTERPRISE LINUX and Windows. Experience in Installation, configuration of Oracle RAC, developed 2 Node RAC. Implemented strategy for partitioning and management of historical data tables in RAC. Database creation through DBCA, advanced and wrote scripts to create manually. Performed database up gradation from 9i /10g to 11g, 11g to 12c, 12c to 18c and 12c to 19c through customized SQL scripts on Linux,AIX serverProficient in using OEM and RMANCreating and managing tablespaces and data files as per the requirement.Having hands on experience in HOT backups.Performed logical and physical backups for databases.Performed Cloning of databases for TEST.Performed Data migration between databases using oracle utilities IMPORT, EXPORT, DATAPUMP and Transportable Tablespaces. User management by Creation of users and assigning roles and privileges.Perform DB Patching, Cloning, DB Installation, troubleshoot issues/errors, Collaborate with Oracle support for bugs & issues resolutions and personal research.Managing backups for recovery and restore purpose.Expertise in maintaining Database Security using auditing.Implementation of ASM (automatic storage management) on Linux for better storage and space management.Performed backup and recovery, restore using RMAN (recovery manager).Performed Oracle Patching (10.2.0.1.0 to 10.2.0.6.0).Performing daily Archive log file backup and checking Alert Log files.Monitoring of database by using TOAD 10.6 and EM 13c Performing day to day database administration tasks and assists users in resolving issues.