Ganesh D.

Ganesh D.

Oracle DBA

Pathardi , India

Experience: 10 Years

Ganesh

Pathardi , India

Oracle DBA

10 Years

Now you can Instantly Chat with Ganesh!

About Me

·        10+ years of experience in ORACLE Database Administration on Production and Development Databases.

·        Exadata Administration.

·        Exadata environment monito...

·        Exadata environment monitoring using OEM.

·        Database creation and refresh in non-prod environment.

·        Working closely with Oracle FE engineer while H/W failure.

·        Performance related issues handled.

·        Compression using EHCC to reclaim space from database.

·        High Availability RAC 9i/10g/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.

·        Handled 12c container and non-container databases issues

·        Experience in capacity planning, space management, database upgrades/migration.

·        Migrated Non-ASM Single Instance to ASM RAC Instance.

·        Single Instance

·        Applying Patches and Patch sets for Oracle 10g/11gR2 database.

·        Creating database for Testing/Development/Production.

·        Data Guard configuration and troubleshooting.

·        Creation of users, granting accesses permissions to users.

·        Managing Import/Export and Data Pump depending up on Requirement.

·        Implementation of backup and recovery processes using RMAN.

·        Creation of Plan of Action for various DBA Maintains activities.

·        Raising SR with oracle for critical issues.

·        Providing 24X7 supports for production databases.

·        Unix scripts written to achieve automation for various DBA activities.

·        Performance Tuning.

·        Gathering statistics of database to improve performance of database.

·        Performance tuning done for individual SQL query.

·        Used AWR, ADDM, TKPROF,SQL Tuning Adviser.

·        Various performance related issues handled.

·        Guided developer to write efficient code to enhance database performance.

·        Done both reactive and proactive performance tuning.

·        12c Enterprise Manager Administrator

·        Trouble shouting OEM agents.

·        Creating report for database monitoring purpose.

·        Agent installation using various methods.

·        Creating incident rules and configure the emails alert.

·        Creating Metric Extension for specific alert.

Show More

Portfolio Projects

Mattale Inc.

Company

Mattale Inc.

Role

DevOps Engineer

Description

    • 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.

Show More Show Less

Libarty Globle Inc

Company

Libarty Globle Inc

Role

DevOps Engineer

Description

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.

Show More Show Less

New York Times

Company

New York Times

Role

DevOps Engineer

Description

  • 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.

Show More Show Less

KDG Operations

Company

KDG Operations

Role

DevOps Engineer

Description

  • 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.

Show More Show Less