Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Disclaimer
Aws Knowledge
Redshift Responsibilities
Timeline
Generic

Ravindra Babaso Bhosale

AWS Database Administrator
Solapur

Summary

Experienced L2 Database Administrator with a demonstrated history of working in the information technology and service industry in Big data analytics Domain skilled in Redshift and have an experience of 3.9 Years. Pursued Bachelor in Mechanical Engineer and comes with 3.9 years of experience in Technically sophisticated & astute Bigdata Professional, with total 3.9 years of experience and currently associated with Wissen Infotech Pvt Ltd. Experience in Implementation, Administration and custom application development for major GE Healthcare, GEHC( GE HEALTHCARE). Holds sound knowledge in Redshift.

Overview

4
4
years of professional experience
4
4
years of post-secondary education
1
1
Certification
3
3
Languages

Work History

Database Administrator

Wissen Infotech
Bangalore
06.2021 - Current
  • Working as L2 Database Administrator Engineer in GE healthcare.
  • Project typically deals with more straightforward querying and reporting of business data.
  • Applications collect and process large amount of data from internal and external systems.
  • Here we use BI applications to create reports, dashboards and data visualizations. For ETL using glue to move data in and out from amazon Redshift.
  • Monitored network hardware operations to evaluate proper configuration.
  • Improved overall user experience through support, training, troubleshooting, improvements and communication of system changes.

Education

Bachelor - Mechanical Engineering

Punyashlok Ahilyadevi Holkar Solapur University
Solapur
07.2015 - 07.2019

Skills

Redshift

AWS Services

S3

RDS

SQL

Linux/Unix

Windows

GitHub

AWS Console

AWS Cloud Watch

Yarn UI

SQL Workbench

Dbeaver

Zeppelin

undefined

Certification

AWS Certified Cloud Practitioner, Foundational, 08/27/21, 08/27/24

Personal Information

  • Gender: Male
  • Nationality: Indian

Disclaimer

I hereby declare that all the information provided above is true and correct to best of my knowledge and belief.

Aws Knowledge

  • Knowledge on understanding glue jobs and solving the user issues.
  • Knowledge on creating EC2 instances and ELB.
  • Knowledge on S3 storage, life cycle policy, versioning.
  • Knowledge on step functions to monitor and understand flow of execution.
  • Implemented auto rotation in secret manager to change the password of user automatically using a lambda function.
  • Knowledge on Lambda functions functionality.
  • Knowledge on IAM Roles management and IAM Roles policies.
  • Knowledge on EBS and EFS Storage.
  • Knowledge on using AWS Cli for S3, EMR and Redshift.
  • Knowledge on cloud watch alarms.
  • Knowledge on Athena worked on poc to create tables and query s3 data directly using Athena.
  • Knowledge on No SQL Database such as Dyanamodb.

Redshift Responsibilities

• User Management
• Access Management
• Object Management
• Enabled WLM for the cluster and created queues and assigned groups to the queues.
• Changing the WLM setup as per schedule.
• Worked on resize of cluster both Elastic and Classic
• Automated wlm changes as per scheduled using auto WLM workload scheduler.
• Changing the WLM allocation on adhoc user requests
• Worked on Poc on enabling AUTO WLM on priority based in lower environments.
• Scheduled Monitoring scripts to monitor long running, blocking sessions, idle sessions ,data growth and inform users to take immediate action to reduce the waiting time of queries.
• Enabled concurrency scaling for reporting queue.
• Automated process of vacuuming tables during maintenance window using python script.
• Implemented Deep copy on tables and automated the process by creating a stored procedure and to run parallel using python to decrease the maintenance window.
• Automated process of analyzing tables parallel in batches daily.
• Automated compression check on tables to analyze tables and prepare a report which gives us information about columns which needed to be compressed.
• Created and automated script to load history of system tables as we have retention period on system tables.
• Copying data from one environment to another using unload/copy on adhoc user requests.
• Automated data copy from one environment to another using python.
• Experience in writing queries to get the metrics of queries using multiple system tables.
• Monitoring Redshift Advisor and implementing them for performance improvements.
• Experience on working with external sachems and external tables.
• Adhoc execution of queries and stored procedures on user requests.
• Experience on tuning query to improve the performance based on the explain plan of query.
• Monitoring the cluster performance using Redshift Console and cloud watch alarms.
• POC on end to end performance on Data-sharing and worked with AWS on all the issues which are caused during POC.
• Developed a dashboard on github using static webpages with the cluster status using python and jupyter book and jupyter notebooks.
• Involve in cluster build activities of EMR clusters.
• Having good knowledge on Terraform.
• Responsible for creating monitors, alarms, and notifications for EC2 hosts using cloud watch.
• Monitoring the performance of EC2 instances via Cloud watch.
• S3 – Working with S3 to create the buckets to store objects.

Timeline

Database Administrator

Wissen Infotech
06.2021 - Current

Bachelor - Mechanical Engineering

Punyashlok Ahilyadevi Holkar Solapur University
07.2015 - 07.2019
Ravindra Babaso BhosaleAWS Database Administrator