Deepak Kumar Sahoo

Experience

• 

  Collabera

  Mar 2012 - Dec 2013

  Senior Engineer

  Worked as Oracle database administrator

• 

  Brillio

  Jan 2014 - Oct 2017

   Performance Tuning for Retail database using ADDM, AWR and ASH reports  Storage management using ASM of Oracle 10G/11g/12c  Configuration of Oracle Data-guard in physical standby mode  Managing of Oracle 10g/11g/12c data-guard databases  Backup and recovery strategy  Backup configuration for Net-backup and Tivoli storage management  Configure and monitor Oracle Cluster ware resources  Perform database tuning using Explain Plan and TKPROF and init.ora parameters  Providing necessary support to development team in fine tuning queries  Configuration of grid control and adding databases to grid control  Monitoring ,troubleshooting and tuning databases through grid control  Monitoring the production database using monitoring tools and rectifying the problem if usage of resources goes beyond threshold  Export & Import of tables, tablespaces, schemas and full database level as scheduled by using Data pump Export & Import Utility  Monitoring and managing RAC and EXADATA server  Monitoring and managing reports like backup, space issues on database as well as asm and database , target status on grid  Handling day to day Customer requests Show less

  • Lead DBA

    Apr 2016 - Oct 2017

  • Senior Engineer

    Jan 2014 - Mar 2016
• 

  NatWest Group

  Nov 2017 - now

  Infrastructure Analyst

  * Working as an Oracle Production Support and Project DBA Providing Support to all Tyre 1 applications 24/7 .* Good knowledge on the Change Management and Governance for implementations.* Experience in creation and maintenance of the user Security .* Monitoring alert log file and managing day-to-day operations, maintaining Tablespaces CRD files and housing keeping the files for space management.* Performing Database refresh with RMAN and datapump utility .* Configuration and Commssioning of RMAN for taking backup’s (level 0,Level 1, archive log backups).* Doing restore and recovery using RMAN/Tape backups.* Migrated 10g database on ASM to 11g database on filesystem using expdp and impdp.* Extensive Knowledge in the implementation of High availability using RAC and Dataguard concepts.* Experience on Unix Shell scripting for automation od DBA jobs.* Very Good knowledge in Dataguard setups and performing Disaster recovery on dataguard and Veritas systems* Extensive knowledge on Oracle Goldengate setup and management.* Extensive knowledge on database performance tuning, SQL tuning , System Tuning* Managing LDAP servers (OID,OVD,OUD) and Oname servers. Show less