Experience

• 

  Infosys

  Jun 2008 - Sept 2012

  Oracle database administrator

  Project Description:Client name : Price Water house cooperRole : Oracle Database AdministratorDatabases : OracleOS Platform : RedHat Linux, Sun Solaris 9 and 10Project description : Pwc is Word Leading professional services firm across 158 countries with close to 169,000 people who are committed to delivering quality in assurance, tax and advisory services. PwC" is the brand under which member firms of PricewaterhouseCoopers International Limited (PwCIL) operate and provide services. Together, these firms form the PwC network. Infosys was assigned to manage Learning and HR payroll related databases and people soft application support with 5 different environments. Contribution : Scope of DBA activities includes handling of multiple environments and tasks like• Incident management and Change Management to address frequent issues, mitigate them and tracking using Service manager 7 (SM7) ticketing tool.• Database monitoring, maintenance and database availability. • Database refreshes using Rman and export/import method.• Tablespace management, User management, space management, troubleshooting of backup and recovery.• Database cloning from the production environment for the testing purpose as per the adhoc request.• Dataguard set up and trouble shooting of dataguard environment.• Implementing shell script for database backup, cloning, monitoring and standby by synchronization. Show less

• 

  Mphasis

  Oct 2012 - May 2014

  Lead infra engineer

  Worked for the Ahold (in full Koninklijke Ahold N.V.) Dutch international retailer based in Amsterdam account as an Oracle DBA.

• 

  Barclays

  Feb 2015 - now

  Working as Oracle DBA - L2 and managing around more than 15000 Oracle databases related to Investment Banking and Retail Banking domain.• Installing and upgrading Grid Infrastructure / Clusterware to 11.2.0.4.0.• Configuring and upgrading ASM to 11.2.0.4.0.• Installing Oracle 11gR2 RAC on Solaris 10 and RHEL 6.5.• Verification of raw storage and translating them in ASM disk group.• Upgrading DBs to 11gR2.• Creating standby database and configuring data guard broker using DGMGRL.• Converting database from file system to ASM.• Managing ASM disk group, adding and dropping disks.• ASM using tools ASMCMD.• Creating single instance standby and RAC standby database using RMAN.• Administering standby database using DGMGR (data guard manager) and OEM.• Managing RAC with Oracle supplied utilities, CLUVFY, CRSCTL and SRVCTL.• Administering databases using V$ and GV$ views.• Setting up alert to manage archive log gap between primary and standby database.• Adding and deleting standby database to existing data guard configuration.• Customization of SPFILE to accommodate standby database.• Converting physical standby to snapshot standby back and forth.• Meeting with project team to chalk out database migration plan.• Refreshing and cloning DB's using RMAN. Show less

  • Assistant Vice President (AVP) - Oracle DBA

    May 2019 - now

  • Oracle Database Administrator -L2

    Feb 2015 - Apr 2019
• 

  Symantec

  May 2015 - Feb 2016

  Senior technical support engineer

  Worked as Senior Technical Support Engineer for supporting Control Compliance Suite product as a product owner to the end customers across the globe within entire tenure with Symantec.