Kiran Bommareddy
Oracle DBA
Banglore,Karnataka
Summary
15+ years of experience working on multiple database systems Oracle,Microsoft SQL,PostgreSQL,Sybase,DB2,Worked on major domains Capital Investments, Benchmarking,Banking Domain,Telecom Domain,Manufacturing,Internet AdV analytics
Overview
20
20
years of professional experience
Work History
Work History
Supported
- Years of experience in the Information Technology industry with strong Database/ System Administration skills
- Expertise in various databases such as Oracle, Sybase, DB2, MS SQL Server, Postgresql
- Expertise in various UNIX platforms (Solaris, AIX, and Linux)
- Having knowledge of installing and configuring of Web Servers, automated several tasks using Shell Scripts
- Worked for domains , Digital media, Banking, Telecom, capital investments and Manufacturing
- Upgraded 11g databases to 19c
- Upgraded OEM12c to OEM13c
- Configured splunk for Oracle database monitoring
- Automated Oracle patching using Ansible
- Upgraded Oracle RAC database from 10.2.0.4 to 11.2.0.1
- Upgraded Oracle 10g grid control to 12c grid control
- Sri Lanka Telecom (Sri Lanka), upgraded their rating and billing databases from 8.1.7.4 to 10.2.0.2 and solved the performance problem after upgrade
- Supported internal production database Convergys, created two standby databases upgraded production from 10.2.0.2 to 10.2.0.4
- Supported Vivo databases (Brazil), upgraded database from 9.2.0.8 to 10.2.0.4
- Supported Standard Chartered Bank Production databases
- Supported Indian Bank and Vijaya Bank production database
- Installed Oracle10g Grid Control Server and Agents in Convergys ASD DBA group maintained severs
- Upgraded Oracle Application Server from 9.0.4 to 10.1.2
- Moved 2 node Rac database across the datacenter for cost cutting for icrossing
- Ldap integration with 12c grid
- Upgraded 11g databases to 12c in for MSCI
- Worked as Performance tuning consultant in National Commercial Bank Jeddah
- Working presently in financial project separating the business as two
Subject Matter Expert
Kyndryl
Banglore, Karnataka
09.2021 - Current
Subject Matter Expert
IBM
Banglore, Karnataka
05.2017 - 08.2021
Lead Consultant
ITC Infotech
Banglore, Karnataka
06.2015 - 05.2017
Senior Associate
MSCI Inc
Mumbai , Maharashtra
02.2014 - 05.2015
Oracle DBA
Synechron
Pune , Maharashtra
05.2011 - 02.2014
Senior Principal Infrastructure Engineer
Mphasis
Pune , Maharashtra
07.2010 - 05.2011
Analyst Database
Convergys
Hyderabad , Telangana
10.2007 - 07.2010
Senior DBA
Scope international
Chennai , Tamil Nadu
04.2007 - 10.2007
Associate Engineer
Cognizant Technology Solutions
Chennai , Tamil Nadu
11.2005 - 04.2007
Software Engineer
Financial software Solutions
Chennai , Tamil Nadu
06.2002 - 11.2005
Education
Master of Computer Applications -
Bachelor of Computer Sciences - undefined
Oracle Certified Associate – Oracle 10g. - undefined
Skills
Sybase Database AdministrationInstalled Sybase software in different platformsCreated Sybase instance and managed the configuration fileCreated databases and device filesRestored dumps from the onsiteTuned the usage of log filesCreated users and managed securityInvolved in the replication server from Oracle to SybaseSkill Sets in DB2 Database AdministrationInstalled DB2 in AIX servers and WindowsCreated databases in different instancesCreated system managed and database managed tablespacesCreated containers for the tablespacesCreated operating system users and authenticated to databaseInvolved in backup and recoveryDesigned and Implemented Shell Scripts for Database BackupDesigned the Shell Scripts to clear the transaction logs for Sybase databasesDeveloped Shell Scripts for taking backup of Sybase, Oracle, and DB2 databases by using their native backup utilityShell Scripts were scheduled in Crontab for automatic weekly database backup in all UNIX serversUBH Offshore Environment SetupSetting up of AIX servers/ storage (IBM DS4300) for Sybase environmentInstallation and configuration of Sybase database on AIXDatabase sizes of 500GB were created and data loaded from the dumpReceived from onsiteTuned the performance for Sybase database to process 90 Million RecordsSkill Sets in WebSphere and MQ AdministrationInstallation of WebSphere through Graphical screen/ Silent mode using response fileApplying WebSphere fix packs/ cumulative fix packsCreation and configuration of WAS serversConfigured JDBC for establishing connectivity with databasesBackup and restoration of WebSphere configurationDeployed applications through admin consoleInstalled and configured MQ on Solaris boxSkill Sets in UNIX AdministrationInstallation and configuration on Solaris/ AIXOS hardening done for UNIX serversCreation of large file system in Solaris and AIXConfigured Samba in UNIX serverCreated volume groups and logical volume in AIXConfigured NFS server in LinuxGeneral User ID AdministrationAdministrating database in Solaris, AIX, HP-UX, and Linux platformsManaging and supporting Production 8i, 9i, and 10gCreating the Oracle Instance/ Database using customized scripts, conforming to Oracle’s Optimal Flexible Architecture (OFA)Administration and managing the Oracle Instance using custom scripts and 10g Oracle Enterprise Manager (OEM) database controlManaging tablespaces, datafiles, redo logs, tables, and its segmentsMaintaining data integrity also managing profiles, resources and password securityManaging Users, Privileges and Roles
Timeline
Subject Matter Expert
Kyndryl
09.2021 - Current
Subject Matter Expert
IBM
05.2017 - 08.2021
Lead Consultant
ITC Infotech
06.2015 - 05.2017
Senior Associate
MSCI Inc
02.2014 - 05.2015
Oracle DBA
Synechron
05.2011 - 02.2014
Senior Principal Infrastructure Engineer
Mphasis
07.2010 - 05.2011
Analyst Database
Convergys
10.2007 - 07.2010
Senior DBA
Scope international
04.2007 - 10.2007
Associate Engineer
Cognizant Technology Solutions
11.2005 - 04.2007
Software Engineer
Financial software Solutions
06.2002 - 11.2005
Work History
Supported