Summary
Overview
Work History
Education
Skills
Languages
Accomplishments
Work Preference
Timeline
Generic
Open To Work

BHUPENDER SINGH RAWAT

Gaziabad

Summary

Results-driven SQL Developer DBA with extensive experience in performance tuning, query optimization, and database administration across multiple platforms. Collaborated effectively with cross-functional teams to implement tailored database solutions, while mentoring junior consultants on best practices to enhance team performance. Skilled in SQL development and database administration, specializing in performance tuning and process automation. Adept at managing complex databases, executing query optimizations, and implementing best practices, while fostering collaboration across teams to ensure quality and efficiency in project deliverables.

Overview

12
12
years of professional experience

Work History

Lead Consultant

ITC Infotech
05.2022 - Current

Executed query optimization and end-to-end database administration.

Designed, implemented, and maintained efficient solutions across diverse environments.

  • Conducted performance tuning for complex automation scripts and managed large-scale databases.
  • Collaborated with clients to assess requirements and deliver effective solutions.
  • Analyzed business issues in collaboration with stakeholders to identify optimal resolutions.
  • Mentored junior consultants on industry standards and best practices.
  • Utilized SQL Server, PostgreSQL, and MySQL for database administration.
  • Applied advanced Excel, JIRA, and UrbanCode Deploy for project management.

Senior Software Engineer

Motherson Sumi Systems Limited
08.2019 - 05.2022
  • Collaborated with internal and external clients to enhance database solutions across MSSQL, MySQL, and PostgreSQL.
  • Collaborated with cross-functional teams to clarify project requirements and align on specifications.
  • Conducted code reviews to uphold quality standards and ensure adherence to coding practices.
  • Mentored junior staff members in coding best practices and problem solving techniques.

Senior SQL Developer

mydesq technology
07.2018 - 08.2019
  • optimized SQL 2016 performance tuning automation and T-SQL DDL DML to enhance query execution speed
  • Developed complex SQL queries to extract and analyze data for various projects.
  • Optimized database performance by implementing indexing strategies and best practices.
  • Designed and maintained database schemas to support evolving business needs.
  • led troubleshooting efforts to resolve data-related issues in production environments, ensuring data integrity and availability
  • performed database tuning activities including indexing, partitioning, and performance monitoring to improve overall database efficiency
  • Created stored procedures, functions, views, triggers and indexes for efficient data manipulation.

SQL Developer DBA

p value analytics pvt ltd
06.2014 - 08.2017
  • Managed time-sensitive deliveries to multiple stakeholders associated with project.
    Communicated proactively with Airtel team and external vendors to ensure smooth operations.
    Led a team of 8 members, providing training and guidance for optimal performance.
    Optimized SQL queries, resolving slow-running queries in production environments.
    Automated application monitoring and backups while exploring innovative client solutions.
    Analyzed daily achievements for individual processes, taking actions to meet monthly targets.
    Facilitated scrum meetings to monitor application progress effectively.
    Developed complex SQL queries for data analysis and troubleshooting issues.
  • Developed complex SQL queries for data extraction and reporting.
  • Optimized existing SQL scripts, enhancing performance and efficiency for critical applications.
  • Designed and implemented database structures for new applications.
  • Trained junior developers on SQL best practices and coding standards.
  • Integrated multiple data sources into one unified view using views or joins in SQL queries.
  • Optimized existing queries for better performance using SQL query tuning techniques.
  • Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
  • Developed ETL processes using SSIS packages for loading data from various sources into a data warehouse environment.
  • Created and maintained database objects, ensuring data integrity and optimizing performance across systems.

executive

gtl limited
04.2014 - 06.2014
  • Utilized Access, SQL, and Excel to manage and analyze data.
  • Developed strategic initiatives to enhance operational efficiency across multiple departments.
  • Analyzed market trends to inform product development and service offerings.
  • Collaborated with cross-functional teams to streamline project management processes.

Education

MCA - Computers Applications

Graphic Era University
Dehradun
07-2013

BCA - Computers Applications

Sikkim Manipal University (SMU)
Dehradun
06-2010

Skills

  • Hadoop
  • SQL query optimization
  • Data analysis
  • Coding standards enforcement
  • Technical review
  • MySQL
  • Shell scripting
  • SQL and T-SQL
  • Advanced Excel
  • SQL Server development
  • PL/SQL
  • Stored procedures and views
  • DML and DDL
  • Performance tuning
  • Process automation
  • Database management
  • Microsoft Office Suite
  • AWS SCT
  • MySQL and PostgreSQL
  • Control-M migration
  • PowerCenter
  • GitHub
  • Urban Deploy
  • Jenkins

Languages

  • English
  • Hindi

Accomplishments

PAT ON THE BACK 2026

Work Preference

Job Search Status

Open to work

Work Type

Full Time

Location Preference

RemoteHybrid

Salary Range

₹199000/yr - ₹200000/yr

Timeline

Lead Consultant

ITC Infotech
05.2022 - Current

Senior Software Engineer

Motherson Sumi Systems Limited
08.2019 - 05.2022

Senior SQL Developer

mydesq technology
07.2018 - 08.2019

SQL Developer DBA

p value analytics pvt ltd
06.2014 - 08.2017

executive

gtl limited
04.2014 - 06.2014

MCA - Computers Applications

Graphic Era University

BCA - Computers Applications

Sikkim Manipal University (SMU)
BHUPENDER SINGH RAWAT