Nikhil Pahwa

Experience

• 

  Systems Domain

  Dec 2010 - May 2012

  Oracle DBA

  • Database Administration involving installation & configuration of Oracle databases, database backup & recovery. Implementation of test database for providing basic hands on to the students and corporates.• Involved in providing Oracle 10g DBA training to the students and corporates from different companies like IBM,DELL,INFOSYS,MCAFEE.• Installation of Oracle 10g Database on Redhat Linux 5 using vmware for test database.• Space management ( creating tablespaces, adding datafile and resizing the datafiles).• Re-creating of control file to change the Max parameters and to change the database name using uid utility.• Performing backup using exp/imp, cold and hot backup and running RMAN backup in case of failure.• Recovery catalog configuration and creation of rman backup scripts running using crontab.• Timely monitoring the alert log files error.• Control file management (Taking backup of control file, recreating new control file in case of loss, multiplexing)• Performing the cold and hot backup and running RMAN backup in case of failure. Show less

• 

  Ariva Med Data Infotech Pvt. Ltd.

  Jun 2012 - May 2013

  Oracle DBA

  • Installation of OEL 5 and Oracle 11g Database installation and creation for the Development, Testing, Replication Environment.• Installation of 11gR2 RAC 2-Node configuration using ASM on OEL 5 with NAS storage. • Configured a replication instance for the development environment and implemented table level replication using oracle streams.• Installation and Configuration and 11g Data guard with 1 standby site, Configured a physical standby database using rman. Constant check for archive log lags on primary and standby site.• Database creation & Environment Setup from scratch for non-production environments RAC & NON RAC.• Knowledge of installation and implementation of Oracle Golden Gate 11g (Bi-Directional).• Configured Production Server with the OS and the database installation for UAT for future use.• Implemented log miner to manually record the transactions happened on the database into tables.• Migration of database using export/import, rman backups of different database instances.• Managing physical and logical structure of the database (Control Files, Data files, Redo logs, Rollback Segments,Tablespaces).• Renaming RAC/non-RAC databases using NID utility as per application requirement.• Complete Documentation of Production and Development environment setup.• Making changes in the parameters of Spfile/Pfile depending on the requirement.• Configuring RMAN and maintaining Recovery catalog, writing automation scripts for RMAN and performing backup and recovery with RMAN.• Creating and managing ASM instance. Creating disk groups, adding disks and removing disks from disk group.• Configuration of listener.ora and tnsnames.ora and providing the required information to the development team for jdbc connectivity.• Creating shell scripts for automating backups and related processes using Cron.• Altering and updating the structure of the tables as per the requirement from the test team. Show less

• 

  SAP

  Jun 2013 - Aug 2014

  Database Administrator

  1. Installation and Creation of Oracle 11g Database on different platform like Solaris, Linux, HP-UX, Windows manually for Development and Testing as per the SAP environment.2. Involved in DB upgrades, Patching,Cloning, Migration.3. Troubleshooting incidents related to backup failure jobs, user connectivity issues, tablespace issues, ORA-01555 error, ORA-600 errors, Availability of databases and listeners and archival issues etc.4. Experience as On-Call 24x7 production DBA and development DBA and Oracle Support processes for technical requests through Meta link.5. Handling Day to Day activities like managing physical and logical structure of the Database (Control Files, Data files, Redo logs, Rollback Segments, Table spaces).6. Monitoring the performance of Oracle databases on daily basis, regular review and analysis of Oracle trace and alert log files, and carry out the necessary corrective activities.7. Provide on call support 24/7 to all end users, other colleagues and level 1 for oracle related issues and handling escalated issues.8. User management issues involving control user access to resource and information by allocating proper privileges or creating read only users as per the request.9. Taking HOT Backup (OS Level) at times as per the request and work with backup team for backup related issues and ensure the backup is successfully move to Legato(backup) server.10. Taking archive log backups manually in case of archive log directory full situation. 11. Restore and Recovery of database using point in time using Recover Database commands.12. Configuration of SGA and making changes in other parameters of pfile/spfile in case of any memory/performance related issues.13. Increasing the space of disk on OS Level in case of any space related issues. 14. Mentoring new colleagues by providing KT on Oracle DB Administration. Show less

• 

  CSG

  Aug 2014 - now

  • Monitoring, Managing and Administration of Production/Non Production RAC/Non RAC databases running on Exadata X4 and X2 servers. • Handling different versions of Oracle Databases (12c, 11g, 10G, 9i) on different operating systems like Unix, Linux, Aix, HP-UX.• Have hands on experience on the Database up gradation from 9i to 10g, 10g to 11g 11.2.0.3 to 11.2.0.4 or 11.2.0.4 to 12c or 11.2.0.3 to 12c so on. Have done more than 50+ up gradations• Managing the database of over 25TB size.• Installing PSU Patches on 12c, 11g production databases using OPatch auto and OPatch on quarterly Basis on ASM and Non ASM file system based databases.• Work on Daily alerts as per their criticality that is received from Oracle Enterprise Manager 11g and 12C. Work on adding/modifying the user defined metrics and reports as needed on 12c OEM Grid Control.• Testing of Oracle 12c upgrades by restoring the DB from prod database server to test servers (databases of different products) and do necessary modifications in the work plans if needed. Closely work with Oracle support team in case of any failures or errors recorded while upgrades.• Generating and analyzing the AWR, ASH and ADDM reports and taking the appropriate actions based on the result to get rid of the performance issues.• Involved in Backup and Recovery activities using Rman, running the backups manually if needed.• Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes.• Monitor table space sizes, resizing table spaces, relocating data files for better disk I/O. Managed archive logs.• Monitoring & Maintenance of Replication Jobs using Materialized views. Perform manual refresh of materialized views at times in case of any failures.• Experience as On-Call 24x7 production DBA and Oracle Support process for technicalRequest through Meta link • Provide Process Knowledge Transfer to the new team members to make them understand the environment. Show less

  • Database Engineer

    Aug 2023 - now

  • Database Administrator Senior

    Jan 2019 - now

  • Senior Database Consultant

    Jul 2017 - Dec 2018

  • Database Consultant

    Aug 2014 - Jun 2017