Summary
Overview
Work History
Education
Skills
Languages
Key Skills
Education Profile
Disclaimer
Personal Information
Timeline
Generic

Vishwanatha BV

Bangalore

Summary

Highly results-driven and skilled Principal Oracle DBA with 14 years of hands-on experience in administering RAC and Non-RAC Oracle databases in 24x7 production environments across UNIX/Linux platforms. Proven expertise in Oracle Database Architecture, performance tuning, backup and recovery, HA/DR solutions, RMAN, Data Guard, and Oracle GoldenGate (Classic and Microservices).

Extensive experience in:

  • Database installation, configuration, patching, upgrades, and migrations
  • Cloning and refreshing databases using Hot/Cold backup and RMAN
  • Creating and managing Physical Standby databases with switchover/failover operations
  • Performance optimization using tools like AWR, ASH, and Oracle Enterprise Manager (OEM 12c/13c)

Strong hands-on knowledge of ASM instance management, ASM disk group configuration, and RAC environments. Experienced in cloud technologies including Microsoft Azure and AWS with understanding of cloud database concepts.

Managing SLA adherence, scheduled tasks, and incident/outage management. A dependable team player with excellent communication skills and a strong focus on delivering results, improving performance, and ensuring database reliability and availability.

Overview

15
15
years of professional experience

Work History

Senior Principal Engineer

T-Systems India Pvt Ltd
12.2019 - Current
  • Worked closely with customers to scope and design end-to-end Oracle 12c to 19c database migration plans, including environment assessment, upgrade strategy selection and risk mitigation.
  • Performed database administration tasks including performance monitoring, maintenance, backup/recovery, and version upgrades across Production, PPE, Development, QA, and Training environments in support of various enterprise-level applications.
  • Performed patch management on production and non-production Oracle databases, including pre-patch impact assessment, patch application, and post-patch validation.
  • Managed administration, maintenance, monitoring, and upgrades for Oracle databases across various environments (Production, PPE, Development, Testing, Training), ensuring performance, availability, and security.
  • Implemented high availability and disaster recovery solutions by setting up Oracle Data Guard (Standby databases) and Oracle GoldenGate for real-time data replication and failover capabilities.
  • Collaborated with development teams to create and optimize database objects (tables, views, triggers) based on project specifications, ensuring smooth integration with application logic.
  • Managed database security configurations, including user access controls, roles, and privileges, while conducting periodic audits to identify vulnerabilities and ensure compliance.
  • Cloned and refreshed Oracle databases to ensure accurate, up-to-date environments for development, testing, and quality assurance (QA), minimizing environment discrepancies.
  • Developed and submitted change requests for database migration, collaborating with cross-functional teams in CAB meetings to gain approval and take corrective actions as necessary.

Senior Oracle Database Administrator

Sonata Software
08.2018 - 12.2019
  • Provided 24x7 database support for Tesco's e-commerce platform (www.tesco.com/direct), including performance monitoring, troubleshooting, and optimizing slow-running queries for enhanced system performance.
  • Configured and monitored email alerts using OEM 12c for production, PPE, and development environments to ensure proactive issue resolution.
  • Successfully upgraded Grid Cluster and RDBMS databases from Oracle 11.2.0.3 to 11.2.0.4 (Two-Node RAC), applying the latest PSU (October 2016) to ensure database security and stability.
  • Configured Data Guard and implemented Fast Start Failover for various Tesco Bank databases, ensuring high availability and disaster recovery.
  • Upgraded multiple Tesco Bank databases from Oracle 11.2.0.3 to 11.2.0.4, enhancing performance and reliability.
  • Supported Tesco Bank mobile banking database DR drills, identifying slow-running queries and providing optimization recommendations to improve system performance.
  • Collaborated with the application team to use AWR/ASH reports for identifying performance bottlenecks and offering solutions for optimization.
  • Installed and configured databases for pre-production and production environments, ensuring timely and error-free deployments.
  • Gained hands-on experience with Oracle GoldenGate for real-time data replication and troubleshooting issues.
  • Managed and resolved Zendesk tickets and raised Jira changes for any production database implementations, ensuring smooth issue resolution and minimal downtime.
  • Monitored and managed all Tesco Dotcom and Tesco Bank databases using OEM 13c Grid Control, providing proactive performance management and system monitoring.

Senior Oracle Database Administrator

Oracle India Pvt Ltd
10.2016 - 07.2018
  • Working on 2-Node/5-Node 11g RAC with ASM environment.
  • Performance analysis using EXPLAIN PLAN, TKPROF, AWR and ADDM.
  • Maintaining continuous replication using Golden Gate (unidirectional) between Source & reporting DB.
  • Adding storage and planning future requirements using ASM for various databases.
  • Providing database support that involves backup, recovery, maintenance, proactive monitoring, security, research and development for all Production, QA & Development Servers.
  • Taking various actions against ORA errors and warnings from alert logs.
  • Maintaining all databases by ensuring high availability using data guard.
  • Troubleshooting Cluster Start-up Issues, Node Evictions, Network Issues and Storage Related Issues.
  • Experience in Reviewing the Cluster Logs for troubleshooting and Implementing Cluster Health Check.
  • Database Recovery in the event of a crash.
  • Involve in participating incident management calls with various support teams such as UNIX, storage and application team to troubleshoot and fix the major production issues as per the SLA based on business criticality.

Oracle Database Administrator

IBM INDIA Pvt Ltd (Regular)
02.2015 - 06.2016
  • Installation, configuration and upgrading of Oracle 10g,11g and 12C on Linux servers.
  • Create and Manage tablespace as per the requirement from application and development team on production databases.
  • Create and Manage users and assign roles and permissions.
  • Working on HIGH important tickets and getting involved with client calls to resolve issues.
  • Installation, configuration, and administration of 11g RAC databases.
  • Well versed with CRSCTL tool administrate RAC cluster.
  • Well versed with SRVCTL tool administrate RAC databases.
  • Up gradation of RAC grid, databases from 11gR2 to 12C.
  • Quarterly applying patches for RAC database and standalone databases.
  • Configuration of RMAN backup for RAC environment.
  • RMAN configuration and taking backup of database, archive log, using RMAN.
  • Implement and maintain database security (create and maintain users and roles, assign privileges).
  • Working knowledge of DBA best practices.
  • Setup and maintain documentation and standards.
  • Work as part of a team and provide 24 X 7 support on demand basis.
  • Perform general technical trouble shooting and give consultation to development/QA/Product teams.
  • Capacity monitoring and management capabilities.
  • Experience with high-volume OLTP database systems.
  • Creating roles, Privileges and assigned roles to users.
  • Cloning the Database from Production Databases for Dev and testing server.
  • Performing schemas, table refresh using data pump utility.
  • Configured DATAGUARD (Standby) for availability.
  • Migrate database from Non-ASM to ASM.
  • Cloning of Dev database from production database using RMAN utility.
  • Patching of prod database.

Oracle Database Administrator

IBM INDIA Pvt Ltd (On Contract)
08.2012 - 02.2015
  • Good knowledge in Oracle Database architecture and concepts.
  • Hands on experience of installation and maintenance of Oracle database software.
  • Hands on experience Schema and User management.
  • Hands on experience of Space maintenance as per requirement for tablespace and segment.
  • Hands on experience of hot backup, cold backup by using Oracle utilities like RMAN and Export and Import utilities.
  • Monitoring following alerts and take suitable action in case of warning or failure.
  • Monitoring of CPU & memory utilization.
  • Monitoring of backups.
  • Good knowledge in validating and applying patches for Oracle.
  • Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features.
  • Oracle Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN.
  • Worked in 24x7 production environment and provided on-call and day-to-day support.
  • Perform regular database health monitoring using trace files and alert log files.
  • Generating AWR reports periodically to provide recommendations to customers.
  • Knowledge on DATAGAURD.
  • Up gradation of RAC grid and database from 10G to 11G.
  • Upgrading of database from 11.2.0.3 to 11.2.0.4 version.
  • Managing disk free space in database servers and datafiles.
  • Monitoring alert log and trace files to monitor the day-to-day DBA activities.

System Analyst

IBM INDIA Pvt Ltd (On Contract)
10.2010 - 05.2012
  • Performed Schema level cloning/Refresh from DEV to SIT and UAT.
  • Performed Database Refresh/Duplicate from Production to SIT or DEV.
  • Creating Materialized View, database links to share the objects.
  • Resizing data files of table spaces, when it is overflows.
  • Assigning table space quota for users.
  • Deleting old achivelogs, on completing back up of them.
  • Taken Full Database Export using Datapump Utility.
  • Configured Fast recovery area in the database.
  • Applied CPU/SPU patch for every quarter on DEV SIT UAT and PROD.
  • Applied CRS Patch for oratab corruption on 12c Database.
  • Applied patch on Production and its standby Database.
  • Adding log file groups and members into a group.
  • Configuring archive log mode for Databases.

Education

Bachelor of Engineering - Electronic and Communication

Sri Venkateswara College of Engineering
01.2010

12th - undefined

Kottureshwara pre university college
01.2005

Skills

  • Linux/OEL ( RHEL 7)
  • IBM-AIX
  • Oracle database 11g
  • Oracle database 12c
  • Oracle database 19C
  • Oracle 11g RAC
  • Oracle 12c RAC
  • Oracle 12c ASM
  • Oracle 19C ASM
  • RMAN
  • Oracle Enterprise Manager (OEM)
  • 13c Grid Control
  • Golden Gate
  • Datapump
  • AWR
  • DMU

Languages

Kannada
English
Hindi
Telugu

Key Skills

  • Linux/OEL (RHEL 5, RHEL 6, RHEL 7), HP-Ux, IBM-AIX, Windows Server 2003, Windows XP, Oracle database 10g, Oracle database 11g, Oracle database 12c, Oracle database 19C, Oracle 11g RAC, Oracle 12c RAC, SQL, PL/SQL, Oracle 11g ASM, Oracle 12c ASM, Oracle 19C ASM, RMAN, SQL
  • Plus, PL/SQL, SQL
  • Loader, SQL
  • Net, Toad, Oracle Enterprise Manager (OEM), 12c, 13c Grid Control, Golden Gate, Export/Import, Datapump, AWR, ASH, ADDM, Explain Plan, Tkprof, DMU, TCP/IP, Oracle Database 11g Administrator (Oracle Certified Associate), ITIL V3 foundation certified

Education Profile

  • Bachelor of Engineering, Electronic and Communication, Sri Venkateswara College of Engineering, Bangalore, Karnataka, 2010
  • 12th, Kottureshwara pre university college, Kottur, Karnataka, 2005

Disclaimer

I hereby declare that all the details furnished above are true to the best of my knowledge.

Personal Information

  • Passport Number: Available
  • Gender: Male
  • Marital Status: Married

Timeline

Senior Principal Engineer

T-Systems India Pvt Ltd
12.2019 - Current

Senior Oracle Database Administrator

Sonata Software
08.2018 - 12.2019

Senior Oracle Database Administrator

Oracle India Pvt Ltd
10.2016 - 07.2018

Oracle Database Administrator

IBM INDIA Pvt Ltd (Regular)
02.2015 - 06.2016

Oracle Database Administrator

IBM INDIA Pvt Ltd (On Contract)
08.2012 - 02.2015

System Analyst

IBM INDIA Pvt Ltd (On Contract)
10.2010 - 05.2012

12th - undefined

Kottureshwara pre university college

Bachelor of Engineering - Electronic and Communication

Sri Venkateswara College of Engineering

Similar Profiles

CREATE PROFILE
Vishwanatha BV