Vaibhav Bansal Email & Phone Number

Having around 17+ years of working experience as Database Engineer. Having around 12+ years of working experience as Cloud DB Engineer. Technical Skills: ETL, SQL, .NET, designing database structures, SSRS Designing database structures and tables Optimizing SQL queries to integrate with applications Developing functions, views, and stored procedures Standardized ETL processes and tools to automate data extraction and manual reporting, reducing 400 man hours across the entire operation. SQL tuning and Database performance tuning Automated performance tuning to reduce CPU usage. Troubleshooting and support with system errors to ensure data integrity across the board. Strong experience with MS SQL Server Integration Services. Control File Multiplexing, Redo log file Multiplexing Following the support guidelines as per documented procedures and ensure the Escalation Procedures are followed Proactively monitoring the database’s health and taking preventive or corrective action as required Extensive experience in designing Mongo DB replica sets and multi - sharded cluster. Experience in upgrading and migrating various versions of Mongo database on different platforms. Good experience on Mongo DB scaling across data centers and/or in-depth understanding of Mongo DB HA strategies, including replica sets. Migrating databases from on-prem to AWS RDS/ EC2. Check Mail & Alert Log File Errors and Make Necessary Actions to Rectify Them Export/Import of Tables, schemas, Table space, Database using traditional and data pump tools Worked on Exadata machines Provide support to Customers who run their database workload on AWS RDS and AWS EC2. Provides data integration software and services for various businesses using Informatica Set-up Oracle database on EC2, scheduling backups, restoration and recovery. Working on Customer issues related to RDS (Relational Database Management), Working on application related issues if user facing any connectivity, login issues and etc Migrating database from on-prem to AWS. Set-up Oracle database on EC2, scheduling backups, restoration and recovery. Designed and developed load balancing Mongo applications. Generating AWR report, ASH report and troubleshoot performance related issues. Generating AWR report, ASH report and troubleshoot performance related issues. Design and implementation of Table space, database, file system monitoring scripts Led and trained a team of 50 Cloud engineers, designing and delivering cloud solutions for multinational enterprises