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 RDS/Aurora.• 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 masking.• Expert at analyzing and troubleshooting performance bottlenecks using AWR, ADDM, SQL Trace Facility, TKPROF, Explain Plan and OEM and Sql tuning advisor. • Led teams and implemented strategic solutions for top-tier clients.

• 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• Oracle Apex installation and upgrading. Oracle logger installation.• Configuring high availability for GoldenGate instances.• Migration of on premises Oracle Databases to Oracle/MySQL/MariaDB RDS.

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 maintain all the Data Modeling changes for release managementExpertise and Hands-on experience developing PL/SQL code as per the solution specificationsExcellent communication skills including the ability to interact with various stakeholders at different levels such as Product Owners, Scrum Masters/Project Managers, System Analysts, Developers and Testers etc.Tune databases, applications, monitor performance of database servers, related processes CPU, memory, storage, and network.Through knowledge of Oracle tools like OEM, RMAN, SQL Loader, AWR, ASH, ADDM, Flashback, SQL trace to perform daily jobs.Standby DB creation using Data Guard as per requirement for high availability. Upgrade 11g databases to 12c. Databases refresh activities as per requirements.Automating data movement activities with Exp/Imp , Datapump, ETL techniques and Autosys.Develop and maintain backup and recovery strategy to provide reliable database as per database downtime and transactions. Develop UNIX shell scripts, Batch scripts, SQLs, PL/SQL procedures, functions, packages and triggers to support and automate repetitive task.Administration, Security, Troubleshooting and Support of MSSQL Server 2012.Writing the stored procedures, checking the code for efficiency. Routine backups and restoration for MS-SQL server 2012.Design POC Mappings and help the ETL team on data acquisition techniques and loading strategies during the development phase.Query optimization and Fine tune the Informatica Mappings.Process to load the type 2 data from source (Oracle) to Dataware house data store using Golden gate.

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.• Support for Oracle streams, Golden Gate, Dataguard.• Performance tuning with help of ADDM and ADDR reports.• Identifying and fixing various ORA errors and raising SR to the Oracle support team as required.

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.• Identifying Database performance issues and fixing them with help of AWR and ADDM reports.• Ad-hoc Tasks (Collecting job listing / Assist AD team / Adhoc monitoring).• Configuring of Oracle Streams and monitoring replication.• PL-SQL coding and ETL with Oracle utilities like SQL*Loader, External tables.

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