Summary
Overview
Work History
Education
Skills
Co-Curricular Activities and Achievements
Certification
Timeline
Generic

Badal Singh Dudy

Faridabad

Summary

Database professional with extensive experience in database management and optimization. Proven ability to enhance system performance and ensure data security. Known for strong collaborative skills and adaptability to evolving project needs, leveraging deep knowledge of PostgreSQL/ MySQL, database tuning, and data backup processes.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Database Administrator

Accenture Gurugram
08.2019 - Current
  • Supporting MySQL/PostgreSQL (version higher than 5.5/9.8) on Linux.
  • Also managing cloud as well AWS/ Azure/ GCP
  • Provide performance improvement plan and Query optimization for slow queries.
  • Strong knowledge and experiences in setting up and administering MySQL replication with binary log and GTID replication.
  • Strong knowledge and experiences in setting up and administering PostgreSQL replication with logical replication.
  • Experience with MySQL/PostgreSQL monitoring tools is plus (ex. Nagios/ Monyog/ Splunk/ Dynatrace monitoring tool)
  • Ensured database security with implementation of role-based access control and regular vulnerability assessments.
  • Streamlined backup and recovery processes, enhancing overall system stability and availability.
  • Trained junior team members on best practices for database administration, promoting a culture of continuous learning within the organization.
  • Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
  • Implemented capacity planning strategies to accommodate growth in data volume without compromising system performance or reliability.
  • Optimized database performance by monitoring health and implementing tuning recommendations.
  • Improved team productivity, coordinating database administration tasks and fostering collaborative work environment.

Freecharge Gurugram
05.2018 - 08.2019
  • 1. Supporting MySQL (version higher than 5.5) on Linux.
  • 2. Working with other groups to design and implement distributed MySQL architecture that will support performance and scalability needs.
  • 3. Actively administered several production MySQL servers in a high-traffic and distributed OLTP environment, with a mix of masters and replication and chain replication.
  • 4. Strong knowledge and experiences in setting up and administering MySQL replication with binary log and GTID replication.
  • 5. Strong knowledge of MySQL backup, recovery (MySQL Dump and Percona tools) and upgrade procedures.
  • 6. Experience with MySQL monitoring tools is plus (ex. Nagios/ Monyog monitoring tool)
  • 7. Managing AWS EC2, RDS, Aurora, Redshift, DynamoDB and PostgreSQL.

Planetcast Media Pvt. Ltd.
10.2017 - 05.2018
  • 1. Supporting MySQL (version higher than 5.5) on centos.
  • 2. Strong knowledge and experiences in setting up and administering MySQL replication.
  • 3. Strong knowledge of MySQL backup, recovery and upgrade procedures.
  • 4. Help identify slow queries and suggesting alternatives.
  • 5. Performing data archiving task regularly, particularly if facing fast growing data volumes.
  • 6. Set the cron job for development team.

Innopark Hyderabad
02.2015 - 08.2017
  • 1. Supporting MySQL (version higher than 5.5) on Linux.
  • 2. Strong knowledge of MySQL backup, recovery.
  • 3. Help identify slow queries and suggesting alternatives.
  • 4. Performing data archiving task regularly, particularly if facing fast growing data volumes.
  • 5. Basic knowledge of MySQL performance tuning at the MySQL server configuration level as well as SQL tuning.
  • 6. Have written moderately Linux/Unix shell scripts utilizing built-in shell variables, regular expressions, conditional expressions, functions.
  • 7. Experience with MySQL monitoring tools is plus (ex. Nagios monitoring tool)
  • 8. Purchasing the SSL certificates for our domains.
  • 9. Also using AWS (Amazon Web Server) @ moderate level.
  • 10. Also managing a MySQL part in our server migration also creating the replication for live database and archiving the large tables.
  • 11. Maintain the bandwidth utilization reports for our weekly team meetings.
  • 12. Also creating multiple instance in one server also managing the Dr servers.
  • 13. Maintain archive server for BI team.

Data Analyst

Eli India Pvt. Ltd
10.2013 - 10.2014
  • 1. Worked as Data Analyst.
  • 2. Worked on S3 Browser and Citrix software to Analyse the data.
  • 3. Collect the data from e.bay then use it to Analyse and after Analyse we transfer the data to our prizing team.
  • 4. Working on Ms-Excel for collect all the data for reporting.

Education

B.Tech - Information Technology

Maharshi Dayanand University
01.2012

Intermediate - undefined

HSBC
Palwal, HR
01.2008

High School - undefined

CBSE
Faridabad, HR
01.2006

Skills

  • Domain: - Online examination, Gaming Industry, online shopping, Industry Banking, Automobile
  • Applications: - Using MySQL (version higher than 55) on Linux/ CentOS supporting website like classic rummy, Landmark bingo, slots and PostgreSQL databases for Automobile website like BMW
  • Technical: - Programming Languages – Shell Scripting
  • DBMS – MySQL, PostgreSQL and Redshift
  • AWS – AWS EC2, RDS, Aurora, Redshift, DynamoDB, DMS and Azure PaaS and GCP as well
  • Operating System- Ubuntu and CentOS
  • Development Environments – Vim
  • Monitoring - Nagios, MongoDB, Splunk, Dynatrace

Co-Curricular Activities and Achievements

Industrial Training in PHP for 6 months from Tata CMC.

Secured First place in Xth S.S.T exam in district.

Secured First place in “Nuked-Natika” inter-college competition.

Secured First place in “2nd MVN Volleyball Cup” inter-college competition.

Participated in University Volleyball Team at Jaat Cup, Sonipat (Hr.) - Participated in State level Boxing Team.

Secured Third place in Essay writing competition held in our college twice.

Certification

AZ-900 certificate in 2019

AWS Certified Database Specialty in 2024

Timeline

Database Administrator

Accenture Gurugram
08.2019 - Current

Freecharge Gurugram
05.2018 - 08.2019

Planetcast Media Pvt. Ltd.
10.2017 - 05.2018

Innopark Hyderabad
02.2015 - 08.2017

Data Analyst

Eli India Pvt. Ltd
10.2013 - 10.2014

Intermediate - undefined

HSBC

High School - undefined

CBSE

B.Tech - Information Technology

Maharshi Dayanand University

Similar Profiles

CREATE PROFILE
Badal Singh Dudy