Summary
Overview
Work History
Education
Certification
Achievements awards
Areas of Expertise
Training
Software
Interests
Timeline
Receptionist
Mr.SHIVAYOGAPPA KINAGI

Mr.SHIVAYOGAPPA KINAGI

Sr Software Engineer
Bengaluru,KA

Summary

I bring over 15 years of experience in IT as a Database Administrator and Performance Engineer, demonstrating a strong commitment to excellence in my work. My focus is on translating business requirements into effective technical solutions, utilizing platforms such as Oracle, MS SQL Server, MySQL, and DB2. My areas of expertise include installation, configuration, upgrades, backup and recovery, performance tuning, security, and migration. I am proficient in Data Guard, ASM, GoldenGate, and PSU patching for Oracle versions 12c and 19c. Additionally, I possess strong skills in Oracle Enterprise Manager (OEM 13c). Furthermore, I have a solid foundation in DevOps and Cloud Technologies, encompassing SAP, Microsoft Azure, and NetApp. This diverse skill set enables me to effectively contribute to the achievement of organizational goals.

Overview

16
16
years of professional experience
4
4
Certifications

Work History

Sr. Oracle Database Administrator

SHELL India Pvt Ltd.
12.2020 - Current
  • Managed Oracle database administration for enterprise-level systems, ensuring optimal performance, availability, and security.
  • Implemented database monitoring and tuning strategies, resulting in a 15% increase in system efficiency.
  • Led the successful migration of on-premise Oracle databases to the cloud, reducing operational costs by 25%.
  • Oversaw the implementation of backup and recovery procedures, reducing data loss risk by 30%.
  • Installed and configured Oracle 19c on RHEL 7.1 and RHEL 8.
  • Configured database server, back-office server, and set up the Application on Cloud.
  • Created multiple databases on 19C under CBD with multiple PDBs.
  • Conducted performance tuning on both the database and application sides.
  • Monitored database health daily and generated health check reports.
  • Resolved issues identified during health checks.
  • Performed database backups using RMAN, NetApp Snap, and data pump.
  • Cloned databases for test instances using RMAN and data pump.
  • Monitored Database using OEM for performance tuning.
  • Set up NetApp services for Oracle to optimize MiBs/IPOS for optimal performance.
  • Implemented NetApp Snap and NetApp Mirror for backup and recovery to achieve optimal time and speed.
  • Configured Golden Gate for database replication from Primary to standby instances.
  • Created Pipeline in Azure DevOps (ADO).
  • Planned and executed migration of repositories from ADO to GitHub Actions.
  • Deployed code in the SAP environment.
  • Monitored errors using ADO and Dynatrace.
  • Conducted variability checks using SonarQube and Mend.
  • Automated tasks, such as moving prod logs to archive and separating build and deployment processes.
  • Managed audit processes for clearing users who left the company and project.


ORACLE DBA

SHELL ROYAL DUTCH
05.2014 - 12.2020
  • Monitored and managed billing and cost optimization processes.
  • Monitored performance and availability of applications on the Azure platform.
  • Optimized environment for maximum performance.
  • Identified potential issues in application deployment.
  • Provisioned cloud resources and managed implementation automation.
  • Identified and resolved performance bottlenecks.
  • Implemented and managed security policies.
  • Configured high availabilities using autoscaling and Multi-availability Zones.
  • Monitored DB loads and generated AWR reports for abnormal loads.
  • Conducted RMAN and Data Pump backup and restore operations.
  • Tuned long-running queries.
  • Managed Data Guard databases and troubleshooting.
  • Created flashback restore points and restored databases.
  • Migrated data from production to test and development environments.
  • Analyzed AWR and ASH reports to troubleshoot performance issues.
  • Optimized Oracle databases for high performance and availability.
  • Implemented database security measures to safeguard sensitive data and comply with regulations.
  • Conducted regular backups and disaster recovery procedures.


  • RMAN and Data Pump backup and restore operations.
  • Tuning long-running queries.
  • Data Guard databases and troubleshooting.
  • Trained junior DBAs in best practices for Oracle database management, improving overall team performance.
  • Reduced downtime by proactively monitoring system health and identifying potential problems before they escalated.
  • Developed custom scripts for automating routine tasks, increasing productivity and reducing manual labor.
  • Maintained detailed documentation of database configurations, changes, and procedures for easy reference by team members and future troubleshooting efforts.
  • Flashback restore point creation and flashback the DB to restore point.
  • Data migration from prod to test and DEV environments.
  • Analyzing AWR and ASH reports to troubleshoot performance issues.
  • Diagnosed and resolved critical database issues promptly, minimizing the impact on business operations.
  • Assisted in the migration of legacy systems onto modern platforms, ensuring smooth transitions without affecting business continuity or user experience.

Oracle DBA

Thomson Reuters
05.2010 - 08.2014
  • Installation and Configuration of 11gR2 on RHEL 5.4 Daily Monitoring database health & generating health check reports
  • Resolving Issues which are identified during health check Database backups using RMAN and data pump Cloning database for test instance using RMAN/data pump Applying patches Monitoring Database using OEM & database performance tuning Performing proactive tasks on the database daily / weekly status reports

Tech Support

EPSON
05.2009 - 05.2010
  • Installation and Configuration of R12.1.1 on OEL 5.6 EBS upgrade from R12.1.1 to R12.1.3 Database Upgrade from 11.1.0.7 to 11.2.0.3 Daily database Health check activities User Management - Created and managed users, privileges and roles
  • EBS R12 Patching Cloning R12 PROD using Rapid Clone utility to test and Dev environments Resolving user Issues and performance related issues Administered Apache Server, Forms Server, Concurrent Managers and Report server daily / weekly status reports

Education

Bachelor of Computer Applications - Computer And Information Sciences

BASAVESHWAR SCIENCE COLLEGE
KARANATAKA
04.2001 -

Certification

Oracle Cloud Infrastructure 2019 Architect Associate

Achievements awards

  • Got Award for Capability Building
  • Got Recognition for Automation and innovation at Shell
  • Got 2 Out performance Award at Accenture
  • 3 Time best employ Award at Accenture

Areas of Expertise

  • Databases, Oracle 9c, MySQL 8.0.1 & PostgreSQL
  • Cloud & Virtualization, SAP, Azure, VMWARE GitHub Actions & Terraform
  • Automatic Storage Management (ASM) Dataguard.
  • Quest (TOAD) SQL Developer, OEM 13C, OEM 19C, GoldenGate, RMAN.
  • PL/SQL, Shell Scripting, Excel Macros, PowerShell, YAML & PYTHON.
  • ServiceNow, SonarQube, Mend.


Training

  • Skillathon Training for DevOps SHELL
  • Oracle Database 11G RAC Administration Ed1 Oracle Corporation
  • Oracle Database 11g : Performance Tuning (Hosted) PRV Oracle Corporation
  • Oracle 11G RAC Administration Ed1 PRV Oracle Corporation
  • Oracle 11G New Features for Administration Ed 2 PRV Oracle Corporation

Software

Azure Cloud

Oracle Database

GoldenGate

Netapp

Unix

Mend

Dynatrace

Sonarqube

Terraform

Interests

Riding and Driving Car

Timeline

Sr. Oracle Database Administrator

SHELL India Pvt Ltd.
12.2020 - Current

ORACLE DBA

SHELL ROYAL DUTCH
05.2014 - 12.2020

Oracle DBA

Thomson Reuters
05.2010 - 08.2014

Tech Support

EPSON
05.2009 - 05.2010

Bachelor of Computer Applications - Computer And Information Sciences

BASAVESHWAR SCIENCE COLLEGE
04.2001 -

Similar Profiles

CREATE PROFILE
Mr.SHIVAYOGAPPA KINAGISr Software Engineer