Kunjankumar S.

Installed and configured oracle 10g with automatic storage management (ASM). Day to day monitoring like availability of system, listener, database, alter log file, trace file. Performed Daily Monitoring of Oracle instances using OEM Grid Control, TOAD to monitor users, table spaces, memory structures, rollback segments, logs, and alerts Performed, developed and maintained database backup and recovery using RMAN for various failures. Created database object like tables, indexes, views, synonyms, sequences. Performed logical backup of database, schemas, tables using Export/Import and DATA PUMP utility. Migrated the Databases from 9i to 10g and Monitored alert log and trace files for errors. Managing space both in table spaces and file systems level and Monitoring Segments for fragmentation. Provide recovery solutions and Cloning of Database for Test Purpose. Security management – Creating users, Roles, Privileges and performing logical backups using EXP and IMP. Oracle's Optimal Flexible Architecture (OFA) & database backups using various methods, including export, cold backup, hot backup, and Oracle Recovery Manager Backup. Checked space availability in table spaces and adding space if they reach threshold. Strong programming and debugging skills in PL/SQL, SQL and UNIX shell scripting. Developed and modified database stored procedures, functions, triggers, packages to enhance and improved functionality using PL/SQL. Creating new user accounts and assigns them different roles and profiles. Having knowledge about Managing Dependencies: local and remote dependencies, direct/indirect dependencies. Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach. Worked with business users and application developers to identify business needs and provide solutions.