Ranvir Meshram

Experience

• 

  Phenix Technologies

  May 2003 - Apr 2004

  Faculty for oracle9i

  Designation: Faculty for oracle9iDuration: 3rd May 2003 to 30th April 2004Job responsibility: • Work as faculty for oracle in DBA track, for OCA level in the organization. I am teaching there through-out oracle9i university syllabus in phoenix technologies.• Oracle supplies very well-designed schemas that you can use to sharpen your SQL skills.

• 

  Naive Technology

  May 2004 - May 2005

  Jr. Database Administrator

   Organization: Naive Technology, Nagpur.Designation: Jr. Database Administrator Duration: May 2004 to 3rd May 2005 Job responsibility:• Work as Development DBA in the organization and giving the production support to the Client.• Monitor the performance of database and troubleshooting of any potential problems affecting the database / application.• Design strategy for Backups and recovery of database.• Identify and address performance bottlenecks within the infrastructure.• Support, mentor and train users for database and application access.• User creation, profile creation, granting roles & privileges.• Onsite support and maintenance of the database as DBA on regular basis.• Configuring Data Guard for the database. Show less

• 

  Regenerative Medical Service, Lonavla, Pune

  Jan 2010 - Jun 2011

  Oracle DBA

  Job responsibility: • Installation of RMS-OP ERP software. • Monitoring Oracle Physical Standby Database • Generating AWR report and monitor • Recover table and standby database through Flashback utility • Taking backup through RMAN • Refresh prod schema on schedule basic through Expdp/Impdp utilities • Applying CPU patch • Create shell script for backup under scheduled • Created shell script for database activities • Taking backup through RMAN generated script as daily, weekly, monthly • Monitoring space of tablespaces, data files, undo and temp tablespaces • Monitoring Network related file for troubleshoot network related issues • Monitoring data pump jobs • Upgrade database from 9i to 10g • Create database on oracle10g, 9i as required • Creating user, role, profile and assign privileges, role and profile to users • Configure RMAN parameter values as needed • Taking backup through RMAN utility • Writing backup script for RMAN on daily and monthly basic • Regular Export/Import according to user need as well as perform. • Export user level, table level, database level. Show less

• 

  Phoenix Progressive Certifications Enterprise Pune.

  Jun 2010 - Jul 2011

  Oracle DBA

  Job responsibility: • Manage the status of multiple Oracle 11g environments and database instances. This includes system resource monitoring, backup and recovery activities, Oracle Installation, patching and upgrading, performance tuning, analytical and logical skills. • Writing backup script for RMAN on daily and monthly basic. • Export user level, table level, database level. • Monitoring Oracle Application server As10gR2mt • Writing SQL & PL/SQL code. • Oracle clinical 4.6 / TMS installation / RDC / EDC. • Extract views, using study design mapping tables. • Monitoring space of tablespaces, data files, undo and temp tablespaces. • Generate clinical data reports that are delivered to external customers. • Provide patch/release analysis and guidance, apply and validate relevant updates. • Working on Vmware ESXi 4.1 on multiple host OS. • Manage UNIX and Windows 2003 Server components across multiple environments. • Document activities and work according to SOPs. Writes clearly and accurately. • Maintain a safe work environment & reports workplace hazards Immediately. • Provide end user training as needed. Show less

• 

  Wipro Technologies

  Jul 2011 - Nov 2015

  Oracle Database Administrator

  o ORACLE• Implementation, configuration, maintenance, administration & support of Oracle 9i/10g/11g database.• Implementation of Oracle 10g and 11g RAC• Configuration of Oracle ASM, changing redundancy level of ASM disk groups.• Configuration of database replication using storage bases replication and Oracle Data Guard.• Database Version upgrade.• Database migration from non ASM to ASM environment, non RAC to RAC environment.• Cross-platform database migration.• Database performance tuning.• Database backup and restoration using RAMN, export/import, data-pump export/import.• Ability to work on multiple Platforms like Wintel, Solaris, RHEL, OEL and HP-UX.• UAT/TEST/DEV environment creation• Database Reorganization using export/import and table movement.• Testing switch over – switch back and fail over testing in DR.• Configure TAF Configuration to avoid downtime when one node down in RAC environment.• Configure backup of the OCR and Voting Disk in RAC environment.• Disk space planning for next 6 months according to database growth.o MySQL DBA• Involved in all major Database Administration activities like Design, Installation, Configuration, Creation, Maintenance, Support of Databases, Performance Tuning, Backup and Recovery, Optimization and Database Security, MySQL 5.0/5.1/5.5• Manage MySQL database in replication Master-Master & Master Slave on OS Cluster environment.• Configuration of MySQL MEB Backup tool• Ability to work on multiple Platforms like Wintel, Solaris, RHEL and OEL.• UAT/TEST/DEV environment creation.o MS SQL DBA • Installation , configuration, maintenance, administration & support of SQL Server 2005/2008 Database Server• Configuration of windows cluster, database cluster in windows 2003/2008 environment and 2005/2008 database environment• Log Shipping Configuration• Data Base Mirroring Configuration• Configuration of Backup and Integration it with backup software• Performance Tuning, Maintenance Plan Configuration Show less

• 

  Capgemini

  Nov 2015 - now

  Senior Consultant - DBA

  • Implementation, configuration, maintenance, administration & support of Oracle 9i/10g/11g/12c OEM database.• Implementation of Oracle 10g/11g RAC• Configuration of Oracle ASM, changing redundancy level of ASM disk groups.• Configuration of database replication using storage bases replication and Oracle Data Guard.• Database Version upgrade.• Database migration from non ASM to ASM environment, non RAC to RAC environment.• Database performance tuning.• Database backup and restoration using RMAN, export/import, data-pump export/import.• Ability to work on multiple Platforms like Wintel, Solaris, RHEL, OEL and HP-UX.• Production/UAT/TEST/DEV & Pre-Production environment creation• Database Reorganization using export/import data-pump export/import & table movement.• Testing switch over – switch back and fail over testing in DR.• Configure TAF Configuration to avoid downtime when one node down in RAC environment.• Configure backup of the OCR and Voting Disk in RAC environment.o MySQL DBA• Involved in all major Database Administration activities like Design, Installation, Configuration, Creation, Maintenance, Support of Databases, Performance Tuning, Backup and Recovery, Optimization and Database Security, MySQL 5.0/5.1/5.5/5.6• Manage MySQL database in replication Master-Master & Master Slave on OS Cluster environment.• Configuration of MySQL MEB Backup tool• Ability to work on multiple Platforms like Wintel, Solaris, RHEL and OEL.• Production/UAT/TEST/DEV & Pre-Production environment creation.o MS SQL DBA • Installation , configuration, maintenance, administration & support of SQL Server 2005/2008R2/2012 and 2014 Database Server• Configuration of windows cluster, database cluster in windows 2003/2008R2/2012 environment and 2005/2008 database environment• Log Shipping Configuration• Configuration of Backup and Integration it with backup software• Performance Tuning, Maintenance Plan Configuration Show less

• 

  Capgemini

  -

  Technical Manager - DBA