Ramesh A Vidap, Mba It Email & Phone Number

Houston, TX, US

Plainsboro, New Jersey, US

• Senior DBA helping customers with installation, configuration, creation, backup and data recovery, patching, upgrade and replication of databases on-prem and in AWS EC2, Azure VM, Google Cloud Platform (GCP) and AWS.
• Handled end to end database migration to cloud open source databases including MySQL, MariaDB and PostgreSQL, Cutover plan and Fail back plans, maintenance outage involving multiple cross-functional teams.
• Discussing with customers on their high availability and disaster requirements along RPO and RTO for same and cross region and providing them with the recommended solution.
• Installed and configured OEM for enterprise monitoring, performance management as well as masking for critical customer data.
• Understanding customer’s data privacy requirement and providing custom solutions like encryption at rest using TDE, encryption during transit using SSL and NNE, Fine grained auditing, Data vault, Data redaction, Data.
• Expert at analyzing and troubleshooting performance bottlenecks using AWR, ADDM, SQL Trace Facility, TKPROF, Explain Plan and OEM and Sql tuning advisor.

• Expertise in Installation / Configuration / Performance Tuning / Trouble shooting Oracle Goldengate OGG in both homogeneous and heterogeneous environments including Oracle/MySQL/MsSQL to Oracle/MySQL/MariaDB
• Provisioning infrastructure for databases, server and VPC using Teraforms.
• Deploying configuration management and CI/CD services such as Ansible, Powershell, Jenkins, Docker, JIRA and CloudFormation.
• Upgrade and migration of Oracle databases to new versions.
• Migrating servers (Database and Application) from on premise using Server Migration Service(SMS), Amazon Machine Image (AMI) and EC2.
• Monitoring and performance tuning of Oracle database through SQL and PL/SQL Tuning, TKProf, Explain Plan, tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor

Responsibility to interface with Enterprise Database group and implement DB standards, ensure compliance to Data security and other applicable data standardsConduct Performance Tuning, Query Optimization initiatives and assist the team in troubleshooting and resolving performing related issues.Responsible for database MOD changes.Create, Implement and.

Bangalore, Karnataka, IN

• Installation and managing of Oracle 11g Databases on Linux and Windows environment.
• Planning and implementing the Backup strategy using Logical backups, Cold backups, Hot backups, and RMAN database backup.
• Database refresh with Oracle utilities like SQL*Loader, Export/Import, RMAN and DataPump.
• Data movement activities across database versions and platforms.
• Incident handling from different databases and Applications.
• Monitoring of standby db and Golden Gate for ensuring business continuity & fixing lag issues.

Livonia, Michigan, US

• Automating backup jobs using shell scripting
• Progress Database Support on MFG/PRO ERP environment
• Dump/Load of Production databases

Mumbai, Maharashtra, IN

• Installation and configuration of Oracle ASM and non-ASM Databases (9i, 10g, 11g) on Linux.
• Managing Oracle RDS cloud Instances.
• Up gradation of databases applying patches, patch sets
• Implementing RMAN backup, Monitoring and Fixing Backup failures.
• Apply bug fix patch in production and Non-production databases.
• Up-gradation of databases from Oracle 9.2.0.6 later to 11R2 for production and non-production environments.

Mumbai, Maharastra, IN

• Installation, configuration, administration of Oracle database and client on Windows, UNIX and Linux environment.
• Basic database administration like Backup, Tablespaces management, User and Role Management.
• ERP Functional support and troubleshooting technical issues related to application and data.

Master Of Business Administration (M.B.A.), Information Technology

Bachelor'S Degree, Business/Commerce, General