Tushar S.

Tushar S.

Senior Data Engineer

Ahmedabad, India
Hire Tushar S. Hire Tushar S. Hire Tushar S.

About Me

Tushar is a Senior Database Administrator and Data Architect with 10+ years of experience in data engineering, analysis, and database administration. He works with a diverse skillset including SQL, Snowflake, AWS, Python, DBT, Power BI, and T-SQL to architect, design, and implement data engineering systems, manage and optimize servers/databases, and create dashboards with appealing visuals. Tushar is proficient in using the full spectrum of AWS capabilities to architect, deploy, and administer high-performance data systems, ensuring optimal functionality.

DBA 10 years Data Architecture 10 years Database Development 10 years SQL Server 10 years Snowflake 8 years Snowpark 8 years SQL Server Integration Services (SSIS) 10 years AWS S3 8 years AWS EMR 8 years DBT 10 years AWS Redshift SQL Server Reporting Services (SSRS) 10 years T-SQL 10 years Microsoft Power BI 10 years Apache Airflow 8 years SQL Server Analysis Services (SSAS) 10 years Python 10 years Pyspark 10 years PostgreSQL 10 years Aurora 8 years DynamoDB 10 years

Work history

UpStack
UpStack
Senior Database Administrator
2024 - Present
Remote
  • Providing support for database-related issues including performance, security, locks, bugs, connectivity, and auditing.

  • Establishing user needs and monitoring user access and security.

  • Maximizing service availability and overseeing database security.

  • Monitoring performance and managing parameters to provide fast responses to front-end users.

DBADatabase Administration (DBA) SQL Server
Contract
Contract
Data Architect
2021 - Present (3 years)
Remote
  • Working on a real estate analytics solution, implementing a global database across multiple AWS regions, writing Python scripts, and performance tuning slow-running T-SQL queries.

  • Creating a cloud data lake strategy for migrating the existing setup to cloud for easier administration.

  • Implementing cross-region replication using DynamoDB Global Tables for real-time data synchronization across regions.

  • Moving structured and unstructured data from Aurora PostgreSQL to an S3-based data lake using AWS Glue and S3.

  • Designing Redshift cluster configurations tailored to the client’s workload.

Contract
Contract
Senior Data Engineer
2019 - 2021 (2 years)
Remote
  • Worked on a P&C insurance analytics solution, migrating it from on-prem to cloud and creating AWS Glue jobs to fetch data in snapshot and incremental manners to AWS S3-based data lake in CSV format.

  • Created PySpark jobs and scripts to do a POC of transformations and ran them on an AWS EMR cluster for demo purposes.

  • Created AWS Lambda functions and designed an AWS Redshift cluster for migrating on-prem data warehouse to cloud data warehouse for higher performance and cost-effectiveness.

  • Optimized table design by selecting appropriate distribution styles (KEY, EVEN, ALL) and sort keys to maximize query performance and minimize data skew.

Contract
Contract
Data Engineer
2016 - 2018 (2 years)
Remote
  • Worked on a passenger information system, converting the existing Windows services to ETLs to get faster data synchronization up to 200%.

  • Optimized existing ETLs to eliminate processing delays and job failures to handle a 4x larger load of incoming data.

  • Altered the data warehouse and cube structure to accommodate new features and changes to the system and altered the data warehouse, cubes, MDX queries, and reports for SSRS report optimization.

  • Identified slow running queries and tuned the server configuration at hardware and SQL Server levels to tune up the overall database server performance.

ETLSQL Server Reporting Services (SSRS) Data WarehouseSQL ServerT-SQLMS SSISMDXSSAS
Contract
Contract
Junior Data Engineer
2015 - 2018 (3 years)
Remote
  • Worked on a scrap recycling & consolidation solution, designing data warehouse for a reporting system.

  • Developed a production server monitoring tool to identify blocking queries, wait statistics, slow running queries, server resource contention, and usage patterns.

  • Rewrote existing stored procedures for faster execution and less resource consumption.

  • Redesigned the database architecture to split the OLTP and Reporting modules into separate database for scalability & historical data support.

  • Migrated over 100 SSRS reports running on OLTP to data warehouse, supported by high-performance T-SQL queries and strong data testing.

Data WarehouseStored ProceduresSQL Server Reporting Services (SSRS) OLTPT-SQLSQL Server
Contract
Contract
Junior Data Engineer
2013 - 2015 (2 years)
Remote
  • Laid out a modular architecture and implementation plan for a BI solution for a European brewing giant.

  • Designed a new enterprise data warehouse and data mart architecture, created a data collection engine, and cleaned up the existing ETLs in production to resolve processing lags and optimize data processing.

  • Redesigned reports with a functional and analytical perspective and changed certain data storage and database design techniques for faster and easier queries.

  • Created stored procedures and new SSRS reports for each department to report their business and department performances.

Microsoft Power BI Data WarehouseData Marts ETLSQL Server Reporting Services (SSRS) Stored ProceduresSQL ServerT-SQLSQL Server Analysis Services (SSAS) MS SSIS

Education

BE Computer Engineering
BE Computer Engineering
GUJARAT TECHNOLOGICAL UNIVERSITY - India
2009 - 2013 (4 years)