Sanjiv Kumar Email and Phone Number

• Handling more than 100 databases and application server with administration of OS, Storage and backup solution of the whole group across the Middle East and India.• Migration and patching of all the Oracle DB and Application servers from 10g to 11g,12c on UNIX and windows.• Planning of storage and OS configuration for Database and application installation.• Installation, Configuration and Managing Oracle 10g and 11g Databases as well as Application servers.• Implemented High Availability solutions with Solaris Cluster, IBM HACMP, Oracle 11g RAC, Physical Standby Databases (Data Guard).• Configure and Manage OEM and Grid console to monitor and manage all the DBs in single console.• Trouble shoots Oracle Application server related issue like Web Logic, IBM Web sphere, form and reports.• Administration of Windows & Unix OS.• Backup and Recovery with RMAN and shell script using Symantec Veritas and IBM Tivoli.• Planning and managing Oracle Storage Structure.• Provide the support to developer for DB and application related issue.• Performing Export & Import operations using expdp/impdp and exp/imp.• Stats gathering and rebuilding index time to time to improve performance.• Provide support on Different application like Exchange, Finance, HR, Automotive• Migrate databases from different servers.• Coordinate with vendor for OS and HW support.• Well command over Unix and windows OS.• User Management security roles, group policy, user authentication, auditing and authorization.• Fail over and restoration drill to check the Tape backup and Data Guard.• Preparing documents as per ISO and present during the ISO audit.• Creating and Registering New Databases in RAC Environment.• Provide 24X7 supports when required.• Interface with Oracle Corporation for technical support.• Install and configure of MS SQL DB.• Making database and OS related Scripts and implement it to manage some jobs easily and effectively.

Oracle DBA with experience in windows,solaris,aix,storage.

Installation, up gradation and migration of Oracle RAC on windows & Unix.Manage around 70 RAC database servers across different location remotely.Managing and creating Oracle database.Managing Oracle Storage Structure.Creating and administrating database objects like table, views, indexes etc.User Account management: Creating Users, Disabling users, assigning roles. Performing Export & Import operations. Monitoring & Managing the Tablespaces and Datafiles growth.Analyzing objects, collecting system statistics, reorganizing tables and rebuilding indexes.Monitoring and elimination of Row Migration & Row Chaining.Backup and Recovery procedure by Oracle Utility RMAN which includes documenting the process.Backing up of Archive Log files and monitoring space in that mount point.Taking Export dump daily for Backup purpose.Responsible for taking full cold database backup.Regular checking of Alert log file.Configure and maintain Data Guard operation.Performance Tuning.Providing support for the smooth functioning of the Database to developers.Applying various patches on Application and Database server.Work as part of a team and provide 24X7 supports when required.Knowledge of Oracle 10g RAC, OEM Grid, ASM.

Installation & Configuration of Database on Sun Solaris.Creating and administrating database objects like table, views, indexes etc.Exporting & importing of Database from one server to another.Migrate data from SQL to Oracle.Database space management.Backup/Recovery using RMAN and conventional methods.Configure and maintain Data Guard operation.Taking Export dump daily for Backup purpose.Responsible for taking full cold database backup.Configure and Manage OEM in RAC Environment.Manage and Install Oracle 10g Client.Development & preparation of MIS reports like-sales, stocks & purchases.Monitoring locks and various sessions using OEM.Analyzing objects, collecting system statistics, reorganizing tables and rebuilding indexes.Installation and configuration of SAP.Applying various patches on Application and Database server.Monitor system activities and logs.

Installation & Configuration of Database.Responsible for the Database Maintenance and Backup-Recovery operations.Hot & Cold Backup of Oracle Database and recovery.Creating and administrating database objects like table, views, indexes etc.Monitoring database activity using OEM.Installation and configuration of SAP client.Applying various patches on Application and Database server.Installing and configuring windows2003 server, Windows XP.Managing IT infrastructure including Application, OS & troubleshooting of Network related issues.Backup and Recovery of file server through NT backup, Symantec & VERITAS tools.Data centre management.Provide Technical support over Phone and through Remote desktop.Manage antivirus console.Managing & maintaining the domain user accounts & distribution lists.Installation and Configuration of DHCP, DNS, FTP, IIS and File Server.Installation and configuration of Exchange 2007 and configure client Accounts.Server Installation and Maintenance, AD Installation and Configuring Client Accounts. Backup and Recovery of file server through NT backup, Symantec & VERITAS tools.Briefing the team members about the benchmarked service level metrics, customer complaints. Updating the team members about basics connected with soft skills/processes.

MS sql,ORACLE Grid Control 13c