• Client : KDG(June 2018 to till Date)

Role & Responsibility : Oracle DBA (L3)

• • PL/SQL tuning-Closely working with Application Teams to tackle performance issues in Application end.
  • Database reorg activity using Data pump
  • Off working hour on call support.
  • Day to Day business of Oracle DBA
  • User Management
  • RMAN backup and restoration for Non-Prod Database refresh
  • Data archiving and purging activity
  • Working on various issues of ORA-00600 errors and oracle’s new bug with Oracle Support.
  • Performance tuning and stat related issues using AWR, ADDM, SQL Tuning Adviser
  • Partition management.

• • Exadata Administration- Working closely with Oracle FE engineer while H/W failure. Performance Issue handled. Compression using EHCC to reclaim storage from database.

• Client :ING Bank (March 2017 to May 2018)

Role & Responsibility : Oracle DBA (L2)

• • OFSAA application PL/SQL tuning
  • Exadata HCC implemented to reclaim space from database
  • Database statistics gathering
  • Partition Management
  • Applying PSU and one off patch in testing and prod environment for ODI and OFSAAI application.
  • Client :New York Times (Dec 2014 to Feb 2017)

  • Role & Responsibility : Database Administrator

  • • High Availability 11g/12c
    • Restoration of RAC database for testing environment.
    • Configuration of Data Guard and monitoring using OEM.
    • Planning switch over and switch back activity.
    • Applying PSU and one off patch in testing and prod environment.
    • Monitoring the health check of RAC Database.
    • Experience in capacity planning, space management, database upgrades/migration.
    • Migrated Non-ASM Single Instance to ASM RAC Instance.
    • 12c Enterprise Manager Administrator
    • Trouble shouting OEM agents.
    • Creating Information publishing report.
    • Agent installation various methods.
    • Creating incident rules and configure the emails alert.
    • Creating Metric Extension for specific alert.
    • Single Instance
    • Applying Patches and Patch sets for Oracle 11gR2 database.
    • Creating database for Testing/Development/Production.
    • Data Guard configuration and troubleshooting.
    • Creation of users, granting accesses permissions to users using roles and appropriate privileges.
    • Managing Import/Export and Data Pump depending up on Requirement.
    • Implementation of backup and recovery processes using RMAN.
    • Regularly monitoring the performance of database.
    • Proficient use of AWR, ADDM, SQLTRPT for analyzing the performance of the database.
    • Gathering the database statistics to improve performance.
    • Creation of Plan of Action for various DBA Maintains activities.
    • Explicitly use of Explain plan and Tkprof Utility for better performance.
    • Analyzing indexes and rebuilding indexes on weekly.
    • Raising SR with oracle for critical issues.
    • Providing 24X7 supports for production databases.
    • Regular monitoring of Alert log file on day-to-day basis.

Role & Responsibility : Database Administrator

• • High Availability
  • Configuration of Data Guard and monitoring using OEM.
  • Planning switch over and switch back activity.
  • Applying PSU and one off patch in testing and prod environment.
  • Monitoring the health check of RAC Database.
  • Experience in capacity planning, space management, database upgrades/migration.
  • Migrated Non-ASM Single Instance to ASM RAC Instance.
  • 12c Enterprise Manager Administrator
  • Agent installation various methods.
  • Creating incident rules and configure the emails alert.
  • Exadata Administration.
  • Creating databases using DBCA in exadata machine.
  • Storage migration in exadata.
  • Adding exadata node in OEM for monitoring purpose.
  • Creating SR with Oracle Support for oracle bug.
  • Single Instance
  • Applying Patches and Patch sets for Oracle 10g and 11gR2 Database
  • Creating database for Testing/Development/Production.
  • Data Guard configuration and troubleshooting.
  • Creation of users, granting accesses permissions to users using roles and appropriate privileges.
  • Managing Import/Export and Data Pump depending up on Requirement.
  • Implementation of backup and recovery processes using RMAN.
  • Regularly monitoring the performance of database.
  • Proficient use of AWR, ADDM, SQLTRPT for analyzing the performance of the database.
  • Gathering the database statistics to improve performance.
  • Creation of Plan of Action for various DBA Maintains activities.
  • Explicitly use of Explain plan and Tkprof Utility for better performance.
  • Analyzing indexes and rebuilding indexes on weekly.
  • Raising SR with oracle for critical issues.
  • Providing 24X7 supports for production databases.

Regular monitoring of Alert log file on day-to-day basis.

• • High Availability
  • Installation of RAC database for test/prod environment.
  • Configuration of Data Guard and monitoring using OEM.
  • Planning switch over and switch back activity.
  • Applying PSU and one off patch in testing and prod environment.
  • RACCheck and ExaCheck report generated to submit oracle Support
  • Experience in capacity planning, space management, database upgrades/migration.
  • Migrated Non-ASM Single Instance to ASM RAC Instance.
  • 12c Enterprise Manager Administrator
  • Installation of 12c enterprise manager.
  • Creating Information publishing report.
  • Agent installation various methods.
  • Creating incident rules and configure the emails alert.
  • Creating Metric Extension for specific alert.
  • Single Instance
  • Applying Patches and Patch sets for Oracle 10g, 11g and 12c Cloud Control.
  • Creating database for Testing/Development/Production.
  • Data Guard configuration and troubleshooting.
  • Creation of users, granting accesses permissions to users using roles and appropriate privileges.
  • Managing Import/Export and Data Pump depending up on Requirement.
  • Implementation of backup and recovery processes using RMAN.
  • Creating Database Links and Snapshots (Materialized views).
  • Regularly monitoring the performance of database.
  • Proficient use of AWR, ADDM, SQLTRPT for analyzing the performance of the database.
  • Gathering the database statistics to improve performance.
  • Creation of Plan of Action for various DBA Maintains activities.
  • Explicitly use of Explain plan and Tkprof Utility for better performance.
  • Analyzing indexes and rebuilding indexes on weekly.
  • Raising SR with oracle for critical issues.
  • Database Baseline implementation and review.
  • Providing 24X7 supports for production databases.
  • Regular monitoring of Alert log file on day-to-day basis.