Rohit is available for hire
Hire RohitRohit Kumawat
Verified Expert in Engineering
SQL Developer
Jaipur, Rajasthan, India
Toptal member since February 24, 2016
Bio
Rohit is an IT consultant with 12+ years of extensive technical expertise in architecting, designing, and operationalizing large-scale on-prem and cloud relational database systems and data warehouses. Rohit excels in skills such as SQL, IBM Db2 UDB, MySQL, PostgreSQL, SQL Server, Azure Databricks, and PySpark.
Portfolio
AB-InBev
Data Engineering, Query Optimization, Query Plan, Database Modeling...
PepsiCo Global - MD Projects
SQL, NoSQL, Database Optimization, Azure PaaS, MongoDB, Cassandra, PostgreSQL...
GE Healthcare (Client)
Snowflake, SQL, Amazon RDS, Azure SQL, Query Optimization, IT Support...
Experience
- SQL - 13 years
- IBM Db2 - 10 years
- PostgreSQL - 8 years
- Azure - 7 years
- Performance Optimization - 7 years
- Snowflake - 3 years
- Azure Databricks - 2 years
- PySpark - 2 years
Work Experience
Data Engineer
2024 - PRESENT
AB-InBev
- Developed the Azure SQL Index Advisor tool in Azure Databricks that generates index recommendations by analyzing queries stored in Query Store.
- Implemented the SQL Change Data Capture tool that generates change data capture over time.
- Streamlined data ingestion through the Databricks analytics engine and quality checks through the bronze and gold layers.
- Reduced ETL pipeline failure rates by 30% and improved resource utilization by dynamically scaling clusters based on forecasted load.
- Trained a time-series anomaly detection model using Azure ML with historical pipeline performance metrics.
Technologies: Data Engineering, Query Optimization, Query Plan, Database Modeling, Database Administration (DBA), Python, ETL, Data Pipelines, Microsoft SQL Server, PySpark, Data Warehousing, Azure Databricks, Azure, Performance Optimization, IT Support, Spark, Data Architecture, Data Strategy, Database Optimization, Azure PaaS, Database Management Systems (DBMS), Azure Synapse, BigQuery, GitHub
Database Optimization Expert (SQL/NoSQL)
2025 - 2026
PepsiCo Global - MD Projects
- Led database migration from Azure Cosmos DB for PostgreSQL to Azure Database for PostgreSQL Flexible Server, addressing the upcoming end-of-support considerations and ensuring a sustainable, supported database platform for PepsiCo workloads.
- Implemented database monitoring and alerting solutions for PepsiCo B2B databases, providing proactive visibility into CPU, memory, connections, storage, replication, query performance, and other critical database health metrics.
- Provided production and operational support for live PepsiCo environments, troubleshooting database incidents, performance issues, connectivity problems, and application-impacting database issues.
Technologies: SQL, NoSQL, Database Optimization, Azure PaaS, MongoDB, Cassandra, PostgreSQL, MySQL, Artificial Intelligence (AI), GitHub
Snowflake Developer
2022 - 2024
GE Healthcare (Client)
- Implemented a scalable ML pipeline using AWS SageMaker to predict data pipeline failures and optimize resource allocation in a big data environment.
- Developed Snowflake by executing data warehouse migration, data modeling, stored procedures, CDC using tasks and streams, SCD – Type 2 and 3 implementations. Implemented data loading from S3 to Snowflake, Snowpipe, transient tables, time travel, etc.
- Provided performance optimization and tuning suggestions, clustering solutions for development teams for efficient query performance, and budgeting credit usage.
- Collaborated closely with application developers to create and improve data flows between internal and external systems and the data warehouse.
- Provided L2/L3 admin support for Snowflake issues. Maintained knowledge builder documents, error list documents, and troubleshooting SOPs for the team.
- Specialized in Snowflake advanced concepts like setting up resource monitors and RBA Controls.
- Involved with development teams for database migration projects from on-prem to Snowflake environment.
- Configured and optimized SAP data pipelines for efficient extraction, transformation, and loading (ETL) processes. Designed SAP BW/BI solutions and integrated them with Snowflake for advanced analytics.
- Built data dashboards and reports using tools such as Tableau and Power BI to support business insights and decision-making.
- Performed Snowflake administration: user and account, key pair authentication for Linux, MFA set up for users, access management, DAC and RBAC, network policy and session policy management, database cloning, performance tuning, and optimization.
Technologies: Snowflake, SQL, Amazon RDS, Azure SQL, Query Optimization, IT Support, Debugging, Enterprise Resource Planning (ERP), SAP, Data Visualization, Data Architecture, Data Strategy, ETL Testing, Amazon SageMaker, Amazon Web Services (AWS), GitHub
SQL Server Developer | Database Administrator
2016 - 2022
Social27
- Secured SQL Server data and log backups on Azure Blob containers and worked on SQL Server point-in-time recovery.
- Performed advanced SQL scripting with T-SQL (Transact-SQL) and wrote stored procedures and functions as required by the development team.
- Monitored table space growth using standard scripts and worked with trend analysis data. Provided critical support to the product in releasing data definition language (DDL), executing data manipulation language (DML) statements, and troubleshooting.
- Administrated SQL Server on production environment. Did the installation, tuning, backups, and resource optimization.
- Created database objects like schemas, tables, views, stored procedures, indexes (cluster/non-cluster), triggers, user roles, and functions.
- Performed database performance problem analysis, diagnosis, and optimum performance monitoring, identifying and resolving database performance bottlenecks, SQL tuning, explaining SQL queries, and indexing.
- Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades, and security, including other administrative functions, as part of the profiling plan.
- Designed and maintained database standards and best practices. Physical database design for all database initiatives.
Technologies: SQL Server DBA, SQL, Transact-SQL (T-SQL), Microsoft SQL Server, MySQL Server, SQL Performance, Databases, Database Development, Data Modeling, Database Administration (DBA), Data Analysis, Data Analytics, Data Engineering, CSV File Processing, Query Optimization, Azure, ETL, Performance Optimization, IT Support, Debugging, IBM Db2, Enterprise Resource Planning (ERP), Data Visualization, Data Architecture, Data Strategy, SQL Stored Procedures, Business Intelligence (BI), Database Optimization, NoSQL, Azure PaaS, Database Management Systems (DBMS), Data Migration, PostgreSQL, GitHub
Project History
Auto Index Advisor Tool
I developed the SQL Auto Index Advisor tool by analyzing and iterating over hundreds of SQL queries running on the database engine. Built in Azure Databricks using Python, this tool automates generating index optimization recommendations. Specifically, it advises which indexes to create or drop, helping improve query performance and database efficiency. I streamlined the indexing process through this solution, reducing manual effort and ensuring that the database remained optimized for evolving query patterns.
Db2's Got Talent 2016 Contest
I participated in Db2's Got Talent 2016 contest, organized by DBI Software and the International Db2 Users Group (IDUG), and was in the top 4 Db2 database administrators based on votes from the Db2 community. We had to deliver tips and lessons learned and share them with the Db2 community.
Migration of 20+ DB2 Databases from AIX to Linux for Enhanced Performance and Cost Efficiency
The client aimed to migrate their legacy DB2 9.7 databases, hosted on an AIX machine with impending end-of-support, to a more modern environment. The objective was to upgrade to DB2 v11.5 and transition the databases to a Linux VM, enhancing supportability and cost-efficiency.
From the outset, I took ownership of the project, carefully assessing the existing infrastructure and understanding the client’s requirements. I led the planning and execution phases, ensuring a smooth migration by selecting the right tools, coordinating resources, and mitigating risks. I worked closely with the client’s IT team throughout the process to ensure minimal disruption, thorough testing, and a seamless cutover to the new environment. As a result, the migration was completed on schedule, achieving the desired performance improvements and cost savings while ensuring future scalability and supportability.
From the outset, I took ownership of the project, carefully assessing the existing infrastructure and understanding the client’s requirements. I led the planning and execution phases, ensuring a smooth migration by selecting the right tools, coordinating resources, and mitigating risks. I worked closely with the client’s IT team throughout the process to ensure minimal disruption, thorough testing, and a seamless cutover to the new environment. As a result, the migration was completed on schedule, achieving the desired performance improvements and cost savings while ensuring future scalability and supportability.
Education
2007 - 2011
Bachelor's Degree in Compuer Science
Rajasthan Technical University - Rajasthan, India
Certifications
DECEMBER 2022 - DECEMBER 2023
Microsoft Certified: Azure Database Administrator Associate
Microsoft
MARCH 2016 - PRESENT
IBM DB2 10.1 Database Administrator for Linux, Unix & Windows
IBM
Skills
Libraries/APIs
PySpark
Tools
GitHub, Amazon SageMaker, BigQuery, Subversion (SVN), Query Plan
Languages
SQL, Snowflake, Java, Transact-SQL (T-SQL), Python
Platforms
Linux, Unix, Amazon Web Services (AWS), Azure, Azure PaaS, AIX, Azure Synapse, Oracle
Storage
IBM Db2, Database Modeling, Database Replication, PostgreSQL, SQL Server DBA, MySQL Server, SQL Performance, Databases, Database Administration (DBA), SQL Stored Procedures, NoSQL, Database Management Systems (DBMS), MySQL, Microsoft SQL Server, Azure SQL, Data Pipelines, MongoDB, Cassandra
Paradigms
Database Development, ETL, Business Intelligence (BI)
Frameworks
Spark
Other
Performance Optimization, Data Analysis, Data Engineering, CSV File Processing, Query Optimization, Azure Databricks, Debugging, Data Visualization, Data Architecture, Data Strategy, Database Optimization, ETL Testing, Data Migration, Change Data Capture, Artificial Intelligence (AI), Data Modeling, Data Analytics, Data Warehousing, IT Support, Enterprise Resource Planning (ERP), Shell Scripting, Amazon RDS, English, Database Partitioning, Migration, SAP, SAP DB2
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring