Summary
Overview
Work History
Education
Accomplishments
Additional Information
Certification
Interests
Work Availability
Quote
Skills
Timeline
AssistantManager
Vishal Kiran Thavva

Vishal Kiran Thavva

Principle Software Engineer
Hyderabad

Summary

Certified Cloud Architect with 10 Years of Experience into Database Technologies Oracle, PostgreSQL, MongoDB, Exadata. Expertise in spearheading the Migrations, POC's, Implementations, Troubleshooting to diverse Industries. Have been a Scrum Member from DB Team for Product stability, Automations thru Sprint plans in helping Organization achieve maximum benefits. Adaptable and Very challenging in nature.

Overview

10
10
years of professional experience
4
4
years of post-secondary education
5
5
Certificates
3
3
Languages

Work History

Principle Software Engineer

ORACLE INDIA PVT LTD
Hyderabad
07.2021 - Current

Global Customer Support: EXADATA, RAC, ASM, OCI Cloud.


Supported various customer Engineered systems Issues and provide
Solutions.
As a GCS Engineer, Have been supporting all severity SR’s.
Have been handling all kind of Exa-scalability, Exa-cloud, RAC,
Storage, Cell and DB node performance Issues.
Assisting customers during QFSDP patching on Exadata systems
(storage servers, DB servers, Grid home, InfiniBand switch software and ILOM firmware).
Have been addressing bugs, which customer encounter and providing
bug fix patches to customer by coordinating with development team
when required.
Have been assisting on system vulnerabilities CVE’s and log4j issues.
Have been doing RCA’s for critical issues.
Have been supporting clients over zoom sessions in critical situations.

Have troubleshooted node eviction Issues which might be due to existing bugs or due to hight load and misconfigurations.

Senior Database Specialist

SS&C Technologies, DST
Hyderabad
10.2018 - 07.2021
  • Client: DST Internal (Health care, Retirement Services, private equity administrators & mutual funds.

Have Lead AWD Project- In terms of Migrations, upgradations, new builds, standards, Documentation, POC’s, Checklist items for tracking, Automations
Worked on building 19c Non-CDB and CDB.
Upgraded the Oracle databases from 11.2 to 12.2, 12.1 to 19.6 with
pluggable conversions and standby on, DGMGRL configurations.
Done a POC for a client to migrate 8 node RAC 12.2 to 19.6 stand alone with DR and wallet off.
Restored the lost application PDB on reporting environment when catalogwas missing.
Trouble shooting and resolved PDB$SEED issues.
Tested the performance of oracle databases using oracle database
replay in OEM before migrating to Mesh hardware.
Have migrated the databases from VBlock to Mesh hardware with minimal
downtime for around 280 databases.
Have worked on backup setup to data domains, PSU's, OEM agent installs & upgrades.
Have worked on Hammer DB for load testing and performance.check on
Oracle, PostgreSQL databases.

Senior Member Technical

ADP INDIA PVT LTD
Hyderabad
04.2015 - 09.2018

ADP Internal ( Oracle RAC, Postgresql, MongoDB, Golden gate )

Experience in backups using expdp, impdp and backups/ restore using RMAN
 Refresh of development/test/QA databases from production backup.
 Cloning and managing Duplicate/Standby databases using RMAN.
 Very good technical skills in RMAN, Performed database recovery and restorations to a Particular point of time as per client’s requirement.
 Experience in ASM administration like partitioning LUNS, creating disks, LUN addition to ASM disk groups. Non-ASM to ASM conversions.
 Worked on Storage Migrations from Hitachi to Vmax.
 Experience in Maintaining and administration of Real Application Cluster (RAC) with Data guard setup. RAC builds of 11g, 12c up to 6 nodes and exposure of SRVTL & CRSCTL utilities.
 Worked on golden gate replications and monitoring.
 Monitoring the performance and analyzing using AWR, ADDM, ASH reports,
Execution plans, Gathering stats, trace on session, TFA debug.

Database Administrator

TECH MAHINDRA PVT LTD
Chennai
06.2012 - 03.2015
  • Client: Nissan North America ( DB2 Mainframes & Oracle )

Working on deployments whenever necessary in coordination with
Application teams.
 Experience in backups using expdp, impdp and backups/ restore using RMAN
 Refresh of development/test/QA databases from production backup.
 Cloning and managing Duplicate/Standby databases using Rman.

Worked on oracle database patching on standalone and RAC systems using
OPatch utility ( CPU and PSU ).
 Worked on migration of oracle databases from version 8i/9i/10g to 11g from
windows to Linux platform.

Education

B-TECH - Electronics And Communications Engineering

MVGR COLLEGE oF ENGINEERING
06.2006 - 11.2010

Accomplishments

Received spot awards for lost PDB recovery and for Build Automations.

Received ‘Pat on Back' for the successful migrations, up gradations of oracle databases.

Received my moment awards from clients for Proactive solutions and resolutions on 400+ backup failures.

Received best support Team of the year award from NISSAN client consecutively FY 11-12 & FY 12-13

Trained on Oracle Database 11g – RAC Administration by Oracle University

Trained on Exadata - X8M from Oracle University.

Trained on Cisco Certified Network Administrator from Cisco Academy.

Additional Information

Automations Work:

 Automated and Enhancements to most of the build work like Prevalidations, setting up environment, Pull software’s/scripts from Jfrog Artifactory, Directories creations and installations, Objects creation, building standby, configure dgmgrl , Backups configuration, Post validations/corrections with 60+ checklist items using shell script.

 Automated user’s creations, drops & alterations on multiple database using shell script.

 Have automated couple of daily Maintenance activities using Shell Scripting.

 Automated data file addition using shell/OEM.

 Automated the audit work using shell script for both standalone and pluggable databases– to review the csv files and drop the termed users and revoking the sysdba access.

 Automated the stop/start of DB, golden gate services in RAC to invoke odd/even fashion as part of Event-1 for storage migrations.

Skills:

 Oracle RAC, Multitenant  PostgreSQL  Mysql  MongoDB  Exadata  Shell scripting  Golden Gate  Performance Tuning  DB Migrations  OCI cloud  AWS cloud  GITHUB  Jfrog Artifactory

AWS Cloud:

 Expertise on AWS cloud services like VPC, EC2, S3, RDS, ELB, and EBS, auto scaling, IAM roles through AWS Console.  Migrated Databases from Oracle to AWS RDS.  Migrated Oracle databases to Postgresql RDS and Aurora using DMS.  Designed the AWS network architecture including VPC between regions and subnets.  Lift and shift of Application Work load on to AWS cloud includes EC2

Certification

Oracle Cloud Database Migration and Integration Certified Specialist

Interests

Gardening

Cooking

Photography

Technical Learning

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

Try not to become a man of success. Rather become a man of value.
Albert Einstein

Skills

Oracle RAC

undefined

Timeline

Oracle Cloud Database Migration and Integration Certified Specialist

02-2022

Oracle Cloud Infrastructure 2021 Certified Architect Associate

02-2022

Principle Software Engineer

ORACLE INDIA PVT LTD
07.2021 - Current

Senior Database Specialist

SS&C Technologies, DST
10.2018 - 07.2021

Oracle Certified Professional

06-2016

Oracle Certified Associate

10-2015

Senior Member Technical

ADP INDIA PVT LTD
04.2015 - 09.2018

Database Administrator

TECH MAHINDRA PVT LTD
06.2012 - 03.2015

CCNA

08-2011

B-TECH - Electronics And Communications Engineering

MVGR COLLEGE oF ENGINEERING
06.2006 - 11.2010
Vishal Kiran ThavvaPrinciple Software Engineer