Ravindra Babu Yathati
Database Administrator
Summary
Detail-oriented Database/Middleware Administrator with over 15 years of experience managing databases MS SQL Server/MySQL/Oracle/DB2/MongoDB/PostgreSQL and Redis , Apache/Redhat JBoss/WebSphere in production environments, Installing Software, Backups, Recovery of Databases, Monitoring Resources, Users/Login Control, proficient in Trouble Shooting and Performance Tuning, database, proactively working with developer to prevent performance or other production impacting issues and operating systems. In addition, fulfilled DBA on call rotation responsibilities, which include application support, troubleshooting, server migration, server configuration, backups, monitoring, performance planning, server upgrading, improving security. And highly skilled at On-Prem to Cloud Migration, High Availability and Disaster Recovery Solutions ON-Prem and in Azure. Maintained servers and systems to ensure smooth business operations, a passionate contributor to team success with a track record of empowering teams. A self-starter who is versatile with database technologies, always motivated learn, grow, and stay current.
Overview
30
30
years of professional experience
Work History
AIG Global Services, Hewlett-Packard
- (DXC) , Malaysia
DXC Technology, Sybase
11.2016 - Current
- Installation, Administration of SQL Server on Windows 2000/ 2003 /2008 /2008R2 /2012/ 2012R2 /2016/ 2019 Platform
- Upgrade SQL Servers versions and migrate DB
- Install patch or service pack for SQL SERVER 2000 /2005/ 2008/ 2008 R2/2012/2014/2016/2019, SQL Azure and the associated bundled tools
- Hands on experience on SQL Azure
- Moving databases from on premise servers to Microsoft Cloud platform, SQL Azure
- Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities
- Performance monitoring, troubleshooting, and identifying the cause of the performance degradation by communicating with the application team
- Experience in handling the Mission Critical databases and resolving all the database issues reported by application team
- SQL Server data storage management
- Implementing Database maintenance plan for database consistency and Integrity
- Writing Stored Procedure and Triggers
- Having experience of developing the effective Indexing methods to boost the performance
- Creating Users and giving permissions to them
- Regular and full Database Backup using device every day, weekly and fortnight,
- Prepare SQL server for High Availability environment and for SQL server databases running on Azure
- Hands on cloud security models along with data masking, de-identification, and encryption methodologies, establish appropriate end-user access control levels
- Recovery of Database at the time of Database crashes or digester
- Hands on experience on Database Replication, Log shipping and database mirroring, Always On Availability Group and SQL Failover Cluster
- Installation and Configuration of SQL Server SQL Azure
- Security auditing and application auditing
- Having experience in Migrating on Premises SQL Databases to SQL Azure using DMA & DMS
- Having experience in configuring Virtual machines using Azure portal
- Having experience in creating the alerts for VMs using Azure Portal
- Reviewing the Activity logs and troubleshooting the errors
- Having knowledge on configuring managed disks and unmanaged disks in Azure
- Configured Log Analytics for Virtual Machines and SQL AZURE Pass databases
- Having knowledge on storage accounts and storage replications
- Experience in moving on premises Sql Server databases to Azure using bacpac files
- Experience in creating the database maintenance tasks using Azure Automation
- Experience in working with Azure SQL Database Import and Export Service
- Experience in working with Point in time restores in Azure
- Configured Long Term Retention (LTR) backups for Mission critical databases
- Configured on-premises SQL database backups to Azure using Microsoft Azure Backup tool
- Creating logins, users and assigning the permissions to the users in Azure
- Configured Active Geo Replication, Failover Groups using Azure portal
- Knowledge on AKS
- Monitoring the alerts using the Operations Management Suite (OMS) in Azure portal
- Experience in installing, configuring and administering JBoss Application Server 7.x/6.x/5.x/4.x on Linux Environments and Windows Environment
- Excellent working knowledge of Operation & Production Support with large mission critical systems in multiple technologies and platforms including JBoss, WebLogic, Tomcat, Apache and UNIX
- Hands on experience in a Linux environment with Apache Tomcat, Apache 2.2, PHP 5.x setup on EC2 instances
- Deployed various WAR, JAR, EAR and J2EE applications on managed servers and in clustered environment using Console or auto deployment scripts in stage and production
- Granting Roles and Permissions to Sybase Server Users so as UNIX users
- Managing and monitoring the use of disk space, memory, and connection
- Installation and configuration of Sybase 12.5 on windows
- Installation and configuration of Sybase 15.x on Sun Solaris, AIX, and Windows
- Applying EBF
- Planning to Backup Database, Tran Log and Thresholds
- Performance Tuning of Sybase Server and Query Optimization
- Creating/Modifying/Locking Logins and Users in Sybase Database
- Diagnosing System Problems
- Tuned databases and application queries, performed server access and login management, and performed database backups and restores
- Reduced development and test environment database refresh turnaround time by updating scripts / procedures
- Worked on Table level migrations using BCP
- Maintaining the database consistency with DBCC at regular intervals
- Rebuilding the indexes at regular intervals for better performance
- Designed and implemented comprehensive Backup plan and disaster recovery
- Monitored and modified Performance using execution plans and Index tuning
- Recovering the databases from backup in disasters
- To analyze long running slow queries and tune the same to optimize application and system performance
- Involved in trouble shooting of database and application problems
- Monitoring replication to maintain database consistency between servers
- Monitoring Sybase Server and System Resources
- Production Application Support for a Finance Desk Application to handle Collateral Allocation
- Working on replication
- Security auditing and application auditing
- Oracle
- Install and configure Oracle Database 11g/ 12c/19c
- Sizing of the objects as per requirement
- Creation of Users and Roles, Quotas Profiles and performing auditing
- Creating a Table spaces as per requirement
- Monitoring the database growth, Re-Organization of Tables
- Interact with Hardware Support Engineer
- Data Porting using oracle utility (EXP, IMP and DATAPUMP)
- Monitoring the ARCHIVELOG for databases
- Optimized INIT.ORA parameters to best utilize the new system’s resources
- Performing HOT BACKUPS AND RMAN
- Check the alert log for any ORA- errors and make necessary actions to rectify them
- Check to ensure that space in the all-table spaces should be less than 80% full
- DB2
- Installation and configuration of DB2 10.5/11.1/11.5 on AIX, RHEL and Windows
- Upgraded DB2 v 9.5/9.7 to DB2v10.5 and V10.5/11.1 to V11.5
- Granting Roles and Permissions
- Backing up and Restoring Databases
- Tablespace configuration and monitoring
- Having experience with DB2 Explain, Run stats, REORG and other ONLINE and Offline utilities
- Hands on experience on HA/DR solutions for DB2 databases
- Install Fix packs
- MySQL/ MariaDB
- Install, configure, patching, and upgrading MySQL database, backup MEB, recovery and also employing both advanced and general performance tuning strategies
- Setup InnoDB Cluster, replication between Innodb cluster and DR server
- Experience with MySQL Replication, with both Master-Slave and Master-Master
- DR exercise
- Ability to handle multiple/conflicting projects and deadlines
- Knowledge and experience in database security management
- Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
- Experience setting up Master-Slave replication, multi-Master replication, backup, point in time recovery, high available configurations, and disaster recovery in a complex and dynamic production environment
- Provision MariaDB or MySQL instances
- Ensure performance, security, and availability of databases
- PostgreSQL
- Install and configure PostgreSQL
- Schedule backup and recovery
- MongoDB
- Install and configure MongoDB
- Schedule backup and recovery
- Projec#2
Hewlett-Packard
11.2016 - Current
- On the payroll of Emerio Corporation, Malaysia
- Worked at Hewlett-Packard, Malaysia.
AIG Global Services Malaysia
01.2012 - 10.2016
- Installation and Configuration of SQL Server 2005/2008/2012 in a clustered and non-clustered environment
- Hands on experience in SSIS, SSAS and SSRS of MS SQL Server
- Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency
- Reporting Services, Notification Services, Indexing and Full-Text Search
- Excellent command of writing ad-hoc queries utilizing Dynamic SQL and SQLCMD command line utility
- Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005
- Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities
- Prepare SQL server for High Availability environment
- Upgrading SQL Server SQL 2005 to SQL Server 2012
- Hands on experience on SQL Azure
- Moving databases from on premise servers to Microsoft Cloud platform, SQL Azure
- Install patch or service pack for SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012
- Disk space Planning and Management in all the servers
- Backup and Restoration of Database
- Implement and maintain database security
- Configure and maintain database replication on publisher, distributor, and subscriber
- Configure Maintenance plan activity to maintain the database healthy and performance
- Working on Ticket Logging System
- Resolve incident, service call and work order ticket based on SLA
- Granting Roles and Permissions to SQL Server Users so as UNIX users
- Installation and configuration of Sybase 12.5 on windows
- Installation and configuration of Sybase 15.x on Sun Solaris, AIX and Windows
- Applying EBF
- Managing and monitoring the use of disk space, memory, and connection
- Backing up and Restoring Databases
- Planning to Backup Database, Tran Log and Thresholds
- Performance Tuning of SQL Server and Query Optimization
- Creating/Modifying/Locking Logins and Users in Sybase Database
- Diagnosing System Problems
- Monitoring SQL Server and System Resources
- Production Application Support for a Finance Desk Application to handle Collateral Allocation
- Working on replication
- Experience in installing, configuring and administering JBoss Application Server 7.x/6.x/5.x/4.x on Linux Environments and Windows Environment
- Excellent working knowledge of Operation & Production Support with large mission critical systems in multiple technologies and platforms including JBoss, WebLogic, Tomcat, Apache and UNIX
- Hands on experience in a Linux environment with Apache Tomcat, Apache 2.2, PHP 5.x setup on EC2 instances
- Deployed various WAR, JAR, EAR and J2EE applications on managed servers and in clustered environment using Console or auto deployment scripts in stage and production
- Security auditing and application auditing.
DBA
HP Global Center Malaysia (GCM)
10.2012 - 09.2016
HP Global Center Malaysia
10.2007 - 09.2012
- Administrating more than 200+ Database servers across all the world regions
- Installation and Configuration of SQL Server 2000/2005 in a clustered and non-clustered environment
- Hands on experience in SSIS, SSAS and SSRS of MS SQL Server
- Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency
- Reporting Services, Notification Services, Indexing and Full-Text Search
- Excellent command of writing ad-hoc queries utilizing Dynamic SQL and SQLCMD command line utility
- Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005
- Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities
- Prepare SQL server for High Availability environment
- Install patch or service pack for SQL 2000 and SQL SERVER 2005
- Maintaining Production and Acceptance database of their client (Kone, General Motors, Ericsson, Jardine Lloyd Thompson,) )
- Disk space Planning and Management in all the servers
- Backup and Restoration of Database
- Implement and maintain database security
- Security and Application auditing
- Configure and maintain database replication on publisher, distributor and subscriber
- Configure Maintenance plan activity to maintain the database healthy and performance
- Working on Ticket Logging System based on HP open view service desk
- Resolve incident, service call and work order ticket based on SLA
- Granting Roles and Permissions to SQL Server Users so as UNIX users
- Managing and monitoring the use of disk space, memory, and connection
- Backing up and Restoring Databases
- Planning to Backup Database, Tran Log and Thresholds
- Performance Tuning of SQL Server and Query Optimization
- Creating/Modifying/Locking Logins and Users in Sybase Database
- Diagnosing System Problems
- Monitoring SQL Server and System Resources
- Production Application Support for a Finance Desk Application to handle Collateral Allocation
- Working on replication
- Security auditing and application auditing.
DBA
HP Global Center Malaysia, AIG Global Services Malaysia
07.2010 - 09.2012
DBA
Emerio Corporation
07.2007 - 04.2010
Education
B. Tech - Computer Science and Engineering
S.V. University
Skills
Operating Systems: Linux (RedHat, CentOS & SUSE), AIX, Windowsundefined
Accomplishments
- Taken training on Azure and AWS and certified both
- Training on Mango DB PostgreSQL, Cyber security and Nutanix is ongoing.
Timeline
DXC Technology, Sybase
11.2016 - Current
Hewlett-Packard
11.2016 - Current
DBA
HP Global Center Malaysia (GCM)
10.2012 - 09.2016
AIG Global Services Malaysia
01.2012 - 10.2016
DBA
HP Global Center Malaysia, AIG Global Services Malaysia
07.2010 - 09.2012
HP Global Center Malaysia
10.2007 - 09.2012
DBA
Emerio Corporation
07.2007 - 04.2010
AIG Global Services, Hewlett-Packard
B. Tech - Computer Science and Engineering
S.V. University
Similar Profiles
Matthew HochwenderMatthew Hochwender
Senior Global Director at Hewlett Packard, Aruba Global ServicesSenior Global Director at Hewlett Packard, Aruba Global Services
Arjun PatilArjun Patil
Associate Professional Application Designer at EIT Services India P. Ltd [Formerly Hewlett Packard Global Soft India P.Ltd] of DXC TechnologyAssociate Professional Application Designer at EIT Services India P. Ltd [Formerly Hewlett Packard Global Soft India P.Ltd] of DXC Technology
VSL Bharathi KomaravoluVSL Bharathi Komaravolu
SAP Technical Consultant at Hewlett Packard Global SoftSAP Technical Consultant at Hewlett Packard Global Soft
Michael PepitoneMichael Pepitone
NA at Florida Highway Patrol, State TrooperNA at Florida Highway Patrol, State Trooper
Omar HernandezOmar Hernandez
NA at Ramco roustabout, Big Lake TxNA at Ramco roustabout, Big Lake Tx