Senior DBA – 22nd September 2020 to presentOrganization – LifeWorks Wellbeing Solutions (India) LLP (Formerly Morneau Shepell India LLP)Project- Large Market U.S.Clients- American Airlines,Bosch,New York Stock Exchange,Astrazeneca,Saint Gobain etc (50+ clients)Environment – Linux, WindowsResponsibilities:1. 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.2. Day to day Database Admin activities for maintenance tasks.3. Recently performed Databases upgrades from 12c to 19c Version.4. Installation, Patching, Upgradation and Administration of Oracle 11g/12c/19c databases.5. Monitoring, managing and troubleshooting Oracle Golden gate 12c and its processes.6. Check Oracle Golden Gate Replication, Analysis of trail files using Log dump and monitoring.7. Provision, monitor and manage the Oracle cloud ADB.8. Configuring and management of RMAN Backups, Performing backups and recoveries using RMAN backups.9. Implementation of data guard with maximum availability, protection and performance configuration. 10. Managing Data-guard Administration for Physical, Active Data-guard.11. Recover DR database if gap is there between production and standby database.12. Management and monitoring of the Oracle real application cluster (2 node RAC).13. Perform data pump at Database level, tablespace level, schema level and table level. 14. 16. Perform weekly database maintenance activity (Gather Statistics, Rebuild Indexes and Compile Invalid Objects).15. 17. Generate and review AWR and ADDM.16. 18. Schedule RMAN backups through OEM 13c tool.17. 20. Perform data recovery using Log Mining method.18. 21. Taking care of Database performance related issues.19. 22. Query and object level tuning with the help of Explain Plan & SQL Tuning Advisor.20. 25. Applied quarterly released database PSU/bundle patch on Production, UAT and Development databases.

Oracle DBA L2 - 2nd December 2019 to 18th September 2020Client - IBM India Pvt. Ltd. (HDFC Ergo Health Insurance), GurugramPayroll - IMSI Staffing Pvt. Ltd. (Previously IMSI India Pvt. Ltd.)Environment – AIX, WindowsResponsibilities:1. Database Monitoring – 24*7 monitoring of servers(Production and Standby Database servers).2. Prod DB (RAC DB) successfully migration from P8 to P9 (11gR2/AIX 7.1).3. Checking Prod dbs and standby dbs sync status, if required performing recovery.4. Experience in installation and setup Uni-Directional replication on 12C Golden Gate. 5. Experience in Oracle Golden Gate Replication, Analysis of trail files using Log dump and monitoring.6. Scheduling & Monitoring RMAN backup on dbs.7. Cloned/Refreshed the databases as per the client requirements. 8. Monitoring the Alert logs, disk space utilization and connectivity of Database.9. Monitoring CPU and Memory utilization using OS commands10. Tables export and import via Data-pump.11. PSU Patching on Prod, Preprod and UAT DBs.12. Creating Disk Group to ASM.13. Configuring and taking physical & logical backup.14. Creation of DB links.15. Creating schemas and other Oracle Objects as when required.16. Rebuilding indexes and gather stats as per need to improve DB/query performance. 17. Query and object level tuning with the help of Explain Plan & SQL tuning advisor.18. Work with Oracle Support by raising SRs on several issues.

Oracle DBA L2 - 2nd December 2019 to 18th September 2020Client - IBM India Pvt. Ltd. (HDFC Ergo Health Insurance), GurugramPayroll - IMSI Staffing Pvt. Ltd. (Previously IMSI India Pvt. Ltd.)Environment – AIX, WindowsResponsibilities:1. Database Monitoring – 24*7 monitoring of servers(Production and Standby Database servers).2. Prod DB (RAC DB) successfully migration from P8 to P9 (11gR2/AIX 7.1).3. Checking Prod dbs and standby dbs sync status, if required performing recovery.4. Experience in installation and setup Uni-Directional replication on 12C Golden Gate. 5. Experience in Oracle Golden Gate Replication, Analysis of trail files using Log dump and monitoring.6. Scheduling & Monitoring RMAN backup on dbs.7. Cloned/Refreshed the databases as per the client requirements. 8. Monitoring the Alert logs, disk space utilization and connectivity of Database.9. Monitoring CPU and Memory utilization using OS commands10. Tables export and import via Data-pump.11. PSU Patching on Prod, Preprod and UAT DBs.12. Creating Disk Group to ASM.13. Configuring and taking physical & logical backup.14. Creation of DB links.15. Creating schemas and other Oracle Objects as when required.16. Rebuilding indexes and gather stats as per need to improve DB/query performance. 17. Query and object level tuning with the help of Explain Plan & SQL tuning advisor.18. Work with Oracle Support by raising SRs on several issues.

Associate Engineer Database Management - 16th June 2016 to 16th October 2018Client - BSES Rajdhani Power Ltd./ (Reliance Infra), New Delhi (BSES Data Center)Payroll - CMS IT Services Pvt. Ltd.Environment – Linux, WindowsResponsibilities.1. Working with four Productions and their Standby Database of varying sizes 2 TB to 4 TB in Linux and Windows Platform.2. Database Monitoring – 24*7 monitoring of servers (Production and Standby Database servers).3. Estimate Storage requirement, Creation of Tablespaces and other Database Primary Objects.4. Executing query/ script on database as required by Developer Team.5. Installation of Oracle on user system Windows/Linux environment, checking connectivity to database etc.6. Installation of Oracle Database and Client software on user system.7. Monitoring of all server disk space or mount point & logs.8. Checking for errors in Alert logs and Trace file..9. Taking logical backups using export utility.10. Scheduling & Monitoring RMAN backup on dbs.11. Check all scheduled jobs whether executed or not.12. Check all archives on standby database servers whether applied or not.13. Monitoring all server network status using SOLARWIND.14. Creating and maintaining standby database.15. Making & sending report, sheets to Team Lead.