Simple Singh

Experience

• 

  HCL Technologies (Infrastructure Services Division)

  Dec 2014 - Aug 2017

  Senior Analyst

  • Organization– HCLDesignation – Senior AnalystDuration – Dec 2014 To Aug 2017 Client – SC-Jhonson• Worked on- DB2 9.7, 10.1, 10.5 on AIX, Linux.• DB2 installation• Fix Pack Up-gradation.• DB2 Version Migration• Performance Tuning• HADR setup• DB2 Maintenance utilities:- Reorg, Runstat, Backup.• Data movement utility (export/import, load, db2move).• Performance monitoring using DB2TOP, TOPAS, NMON, utilities etc.• Backup of production servers (hot split and cold split backup using TSM)• DB Restoration , Roll forward recovery of db b/w same platform and b/w diff. Platform• Basic knowledge of TSM (backup hung, archive log check etc.)• TSM to simpana migration.• Scripting Knowledge to automate db2 backups, db2diag alert etc.• Simpana commvault GUI tool handling for db2 backups,restore etc.• DB2 OS migration from AIX to Linux server.• Sound Knowledge of Tablespaces.• Familiar with many utilities like db2ckbkp, db2cklog, db2iupdt, db2iupgrade etc.• Maintaining Database Level (DB CFG) and Database Manager Level (Instance) Parameters.• Increasing and decreasing tablespace sizes using alter tablespace command.• Involved with the development team, and resolving problems related to the database privileges, etc.• Troubleshooting for various real time issues. Show less

• 

  Syntel

  Aug 2017 - Aug 2019

  Associate Consultant

  • Organization– SyntelDesignation – Associate ConsultantDuration – Aug’17 To till dateClient – Moody'sIn this project my primary responsibility are:-ORACLE: Worked on – Oracle 12c on AIX and Linux Oracle Patching Knowledge of Oracle backup and restoration Experience in data loading utilities like logical backups using full export, import and DATA PUMP. Oracle DR setup and dataguard setup Troubleshooting for various real time issues Oracle Maintenance Utility: Runstat, Backup Performance monitoring Handle on-call issues and jump into sev1/sev2 calls and ensure timely restoration of database services. Created clone database and duplicate database for load testing, acceptance testing etc. using RMAN Performing switchover and failover during DR drill activity Setup dataguard setups (deployed dataguard broker –DGMGRL) ,Enabled fast start failover. Configuring and administering auditing setup for oracle 12c database.DB2 : Worked on- DB2 9.7, 10.1, 10.5 on AIX,Linux. DB2 installation Fix Pack Up-gradation. DB2 Version Migration Performance Tuning HADR setup DB2 Maintenance utilities:- Reorg, Runstat, Backup. Data movement utility (export/import, load,db2move). Performance monitoring using DB2TOP, TOPAS, NMON, utilities etc. Backup of production servers (hot split and cold split backup usingTSM) DB Restoration , Roll forward recovery of db b/w same platform and b/w diff. Platform Scripting Knowledge to automate db2 backups, Reorg and runstats etc. Simpana commvault GUI tool handling for db2 backups,restore etc. DB2 OS migration from AIX to Linux server Familiar with many utilities like db2ckbkp, db2cklog, db2iupdt, db2iupgrade etc. Maintaining Database Level (DB CFG) and Database Manager Level (Instance) Parameters. Troubleshooting for various real time issues.AUTOMATION: Automation of Manual task using shell scripting and python Show less

• 

  Altran

  Aug 2019 - May 2021

  Specialist - Technical support
• 

  Accenture

  May 2021 - now

  • IT Operation Associate manager

    Jun 2022 - now

  • Database Admin Team Lead

    May 2021 - Jun 2022