Sanjay Kumar Email & Phone Number

Environment Oracle 10g,11g, Red hat Linux 4,5., Sunsolaris,Windows Server; Client Description : My role here was as a DBA of a team involved in supporting databases in Production/Development environments on Linux,Windows platforms. Handling administration and optimization of the Oracle server versions 10g, and system analysis of new database modules, security issues and user report generation support. Responsibilities : Controlling and monitoring the user… Show more Environment Oracle 10g,11g, Red hat Linux 4,5., Sunsolaris,Windows Server; Client Description : My role here was as a DBA of a team involved in supporting databases in Production/Development environments on Linux,Windows platforms. Handling administration and optimization of the Oracle server versions 10g, and system analysis of new database modules, security issues and user report generation support. Responsibilities : Controlling and monitoring the user access to the database.Monitoring alert log and trace files for errors.Managing Import/Export depending upon requirement.Hot/Cold Backups of database.Resolving user issues and performance issues due to high CPU usage.Applied RDBMS patch by using Opatch.Creating Oracle Database manually and by using DBCA utility.User management involving creating users,assigning roles and priviligesConfiguring listeners and tnsnames.ora files.Tracing Sql Session and used TKProf to analyze the traced file.Interaction with client/users on various issues.Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.Resolving complex backup and recovery issues.Transferring the bulk data from text file into Oracle Database using .Databases upgradation from 10g to 11gScheduled and manual Cloning of databases weekly and monthly basis, also on the users requestSchemas refresh using Hot Backup or Exp/Imp as per request.Perform daily/weekly health checks for the databases and take the necessary actions.Monitoring the mount point size limits and taking necessary actions if required. Database cloning was the most frequent activity.Performing periodical backups (cold & hot)Creating Users with Quota Management.Granting specific privileges and roles to the users. Show less