Harsh K.

Experience

• 

  Infosenseglobal

  Jun 2017 - Feb 2020

  Database Developer

  ● Worked in service based company for project related to Transportation.● Responsible for doing on time maintenance, development on MSSQL and PostgreSQL server.● Preparing tables, functions, stored procedures, indexes, views and triggers for various ongoing and new applications.● Ensuring Transaction wraparound does not occur on PostgreSQL.● Monitoring PostgreSQL log files for error, fatal or panic entries.● Transferring of data between MySQL, PostgreSQL and MSSQL Server.● Understanding execution plans and improving the query performance with a new better way.● Maintenance on statistics and index fragmentation activities.● Worked on GIS project and used PostGIS extension for retrieving and storing data in PostgreSQL Server.● Tables partitioning for large data in MSSQL and PostgreSQL Server.● Daily health checkup of database server for any error, fatal or panic entries.● Preparing of various scheduled/non scheduled documentations for maintenance activities.● Database upgradation from one major version to another major version.● Implemented materialized views and range partitioning in PostgreSQL 11.● Compare multiple database and generate scripts for the differences.● Adhere to Project Plan timeline and task tracking, ensuring timely delivery of Database development tasks.● Worked with all levels of development from analysis through implementation and support.● Excellent verbal and written communication skills and Good attitude towards work and flexibility desired. Show less

• 

  Knovos

  Feb 2020 - Mar 2021

  Database developer

  ● Working in product based company as a independent database developer for eDiscovery project. It includes responsibilities for development of tables, stored procedures, functions, indexes, views and triggers. It also includes development in SSRS reports.● Continuous Improvements in database performance by understanding execution plans and suggesting better approach for fast and speedy retrievals of data.● Resolving locks and deadlock issues.● Database administration activities including database backup, restore, users permission management and scheduling Jobs using SQL Server Agent.● Help write and optimize in-application SQL statements.● Assisting developers, implementation and support staff with putting together complex database queries and stored procedures.● Proficient understanding of code versioning tools such as TFS.● Learned Microsoft Azure Cloud in MSSQL and PostgreSQL Databases.● Strong team and individual player● Demonstrate flexibility and openness to bring creative solutions to address issues Show less

• 

  Cygnet Digital

  Apr 2021 - Dec 2022

  SQL Developer

  Responsibilities:-● Working in HR management and payroll system product for database development, management, performance tuning and Reporting.● Working closely with client for understanding there requirements and doing development on it. ● Preparation tabular data for Power BI tool using SQL Queries.● Worked on Performance tuning for slower performance queries.● Development of Stored procedures, functions, triggers, tables, views and indexes.● Resolving locks, blocks and deadlock issues.● Scheduling jobs using SQL Server Job Agent.● Guiding to team, code review for writing optimised query. ● Database backup, server roles and rights administration activities.● Experienced in using Profiler.● Developed reports in Power Bi Tool for Human resource and Sales dashboard.● Transforming, Cleansing and Processing data in Azure Data Factory.● Experience in Azure SQL Database with self hosted runtime.● Experience in Azure Data Factory and worked on several copy data activity by scheduling trigger.● Created Geo-replication for Azure SQL [Primary + Secondary] using Azure Self Hosted Runtime in Azure Data Factory.● Used Polybase in Azure Synapse Analytics by dedicated serverless pool.● Used Azure Stream Analytics for capturing real time data processing and used windowing functions to do analysis on data.● Experience for consistency levels in Azure Cosmos DB. Show less

• 

  S&P Global

  Jan 2023 - now

  Software Engineer 2

  ● Performance optimization for SQL queries and Python notebooks.● Creating and setting up pipelines in Azure DevOps.● Collaborate closely and Generating data packages with developers, engineers, and stakeholders to build new data sets using XFC configuration manager and prime.● Designing of database schemas and architecting queries for best performance results.● Writing of Databricks pySpark notebook for pull and merge the data from upstream to target using data conversions(If required).● Monitoring and development of DAGs (Python) in Apache Airflow.● Analyzing the source data and resolving the issues for any errors and performance issues.● Working with AWS services like S3 buckets, Redshift, PostgreSQL and Airflow.● Monitoring production jobs and fixing data issues raised by clients.● Working in Databricks SQL Notebooks for CDC tables to capture data history log.● Enhancing the existing processes having slower performance (Queries restructuring, Index tuning, Debugging).● Knowledge of code versioning systems like Azure GIT and generating production implementation accordingly.● Highly productive and Working in Agile development environment.● Development of DDL & DML triggers to protect critical table data and objects like Tables and views. Show less