Sandeep Sharma

Experience

• 

  Telecom software corporation

  Jan 2008 - Apr 2010

  ORACLE DBA

  Database Administration, Installation, upgradation & migration, backup and recovery, performance Troubleshooting using AWR, STATSPACK. Health check, database security, development and production support in oracle 9i/10g/11g on Linux and UNIX Platform. Creation of Database through manually and DBCA, configuration of No archiving to Archiving mode and rebuilding of Indexes in production Database of BHARAT SANCHAR NIGAM LIMITED BSNL

• 

  Aircom International

  Aug 2010 - May 2011

  DBA
• 

  Sutherland Healthcare Solutions

  May 2011 - Oct 2011

  Oracle Database administrator

  Manage the Oracle Database (9i/10g/11g) on more than 350 sites remotely.

• 

  Tata Consultancy Services

  Oct 2011 - Apr 2015

  Oracle DBA

  • Experience as Oracle DBA in 24 * 5 Production database.• Capable of managing Oracle database with installation on Linux/Windows/Solaris Platform• Creating and managing database objects, users, roles, privileges, profiles and security Management for Databases.• Monitoring and resolving Lock Conflicts in oracle database• Experience in using Oracle Export- Import/Data Pump utilities.• Performing data recovery with the help of FLASHBACK feature.• Tablespace/Datafile/Temporary Tablespace/Segment/Extent management and maintenance.• Maintaining hot backup on disk and tape.• Creation and maintenance of databases with/without ASM, space management and configuring database listeners.• Sizing database objects for effective space management and optimal performance.• Maintaining archived data on appropriate storage devices. • Checking from new entry in Alert log file in regular Intervals.• Experience in backup and recovery strategies through physical and logical backups. • Managing Backup using RMAN and Classical (User managed backup).• Upgrading Oracle from 9.2.0.1 to 11.2.0.2.• Regular maintenance and fine-tuning the database.• Interface with Oracle Corporation for technical support Show less

• 

  HCLTech

  Apr 2015 - now

  Oracle DBA

  • Managing Oracle 11g RAC, ASM, Dataguard, Golden Gate Administration. • Oracle Golden Gate Installation and administration.• Installed and configured all enteEM12c.• Involved with installation and maintenance of Oracle 10g RAC/Oracle 11g RAC • Standby database setup for high availability and disaster recovery purpose.• Good experience RAC Cluster ware administration, configuration and Patching.• Experience in performance tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, AWR and ADDM.• Extensive experience in Database Backup/recovery using RMAN( Full/incremental Backups) and in traditional hot/cold Backups and Flashback Database features.• Experience in Logical Backups and database migration tools with Data PUMP, • Export/Import and Transportable Tablespaces.• Good experience in PATCHING and UPGRADATION.• Worked in ITIL framework and SLA environment.• Excellent Communication skills , co ordination and communication with system administrators , development teams. Show less