Sandeep Sharma

Sandeep Sharma

ORACLE DBA

Followers of Sandeep Sharma687 followers
location of Sandeep SharmaDelhi, India

Connect with Sandeep Sharma to Send Message

Connect

Connect with Sandeep Sharma to Send Message

Connect
  • Timeline

  • Skills

    Pl/sql
    Oracle
    Oracle rac
    Rman
    Database administration
    Databases
    Linux
    Red hat linux
    Data migration
    Troubleshooting
    Oracle database
    Unix
    Unix shell scripting
    Sql
    Oracle database administration
  • About me

    8+ years of ORACLE DBA experience in Database Administration, RAC Installation, up-gradation & migration and patching , handling backup and recovery, performance Troubleshooting using AWR, Health check, database security, development and production support in oracle 9i/10g/11g/12c 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. Extensive experience of core database administration activities in Telecom, Healthcare, Pharmaceuticals and Banking domains.

  • Education

    • Guru Nanak Dev University, Amritsar

      2002 - 2005
      Bachelor's degree Information Technology
    • Punjab Technical University

      2005 - 2008
      MCA Computer Software Engineering
  • 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

  • Licenses & Certifications

    • OCP

    • Oracle Cloud Infrastructure 2019 Certified Architect Associate

      Oracle
      Aug 2020
      View certificate certificate
    • Oracle Cloud Infrastructure 2019 Certified Architect Associate

      Oracle
      Aug 2020
      View certificate certificate
    • Oracle Database 12c Administrator Certified Professional

      Oracle
      Apr 2018
      View certificate certificate
    • Oracle Cloud Infrastructure Foundations 2020 Certified Associate

      Oracle
      May 2020
      View certificate certificate
    • Oracle Cloud Infrastructure 2019 Cloud Operations Certified Associate

      Oracle
      Jul 2020
      View certificate certificate
    • Oracle Autonomous Database Cloud 2019 Certified Specialist

      Oracle
      Jun 2020
      View certificate certificate
    • Oracle Database 12c Administrator Certified Associate

      Oracle
      Sept 2016
      View certificate certificate