Akash Halder

Software Engineer

India8 yrs 4 mos experience

Highly Stable

Key Highlights

7+ years of experience in SQL and database management.
Expert in performance tuning and optimization of SQL queries.
Proficient in migrating applications to Google Cloud Platform.

Stackforce AI infers this person is a Database Developer with expertise in Healthcare and Insurance sectors.

Contact

akashhalder45@gmail.com LinkedIn

Skills

Core Skills

Sql ServerDatabase Development

Other Skills

Agile DevelopmentAgile MethodologiesAndroidAndroid DevelopmentAndroid SDKAndroid StudioDOS commandsData ModelingDatabaseDatabase DesignDatabase OptimizationDatabase QueriesDatabasesDeadlockDebugging

About

Software Engineer with 7+ years of experience. Databases: SQL, Microsoft SQL Server (T-SQL), MY-SQL, Teradata, Google BigQuery (GCP) Domain : Healthcare, Insurance (P&C Risk Exposure), Renewables Professional Summary: • Tuning SQL/T-SQL queries, procedures, functions and other objects for better performance. • Migrated application from T-SQL to Google Cloud (GCP). • Created reports using SQL Server Reporting Services (SSRS). • Entry level knowledge of SSIS ETL tool. • Implementing new features like row and page compression mechanism & data compression. • Configuring SSMS profiler to store real-time data of expensive queries and analyze them. • Finding slow historical queries using DMVs and fixing them by doing query tuning & optimization. • Doing SQL code review. • Finding security issues like SQL injection and providing a fix. • Analyzing execution plan & taking corrective action from it. • Experienced in Creating and Updating Clustered and Non-Clustered Indexes. • Altering database object structure for better performance and to reduce the size. • Participates in database management system selection and maintains database consistency. • Working closely with the build and release team & assisting them in troubleshooting database issues. • Identified gaps in upgrade processes and implemented improvements to increase efficiency, performance, and accuracy. • Monitoring live client-server. Managed many client escalations by resolving their critical performance issue at their end. I was the go-to person for any DB related performance issues.

Experience

8 yrs 4 mos

Total Experience

4 yrs 4 mos

Average Tenure

3 yrs 11 mos

Current Experience

Coforge

SQL Developer

Jul 2022 – Present · 3 yrs 11 mos · Remote

Developed SQL queries and stored procedure that will extract data and compile it into meaningful reports.
Utilized Joins, CTE, temp table and sub-Queries to simplify complex queries involving multiple tables while optimizing procedures to be used in production.
Migrated application from T-SQL to Google Cloud (GCP).
Created/modified reports using SQL Server Reporting Services (SSRS).
Entry level knowledge of SSIS ETL tool.
Implementing new features like row and page compression mechanism & data compression.
Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the Performance.
Finding security issues like SQL injection and providing a fix.
Tuning SQL/T-SQL queries, procedures, functions for better performance.
Makes recommendations towards the development team for new code. Provides technical advice to dev, build and release team and assists in solving programming problems.
Working closely with the build and release team & assisting them in troubleshoot database issues.
Doing code review.
Altering database object structure for better performance and to reduce the size.
Finding slow running queries using DMVs and fixing them by doing query optimization.
Analyzing execution plan & taking corrective action from it.
Working in agile methodology. Participating in daily scrum meeting.
Configuring SSMS profiler to store real-time data of expensive queries and analyze them.
Worked with support team for non-production and production issues including production troubleshooting, query tuning, and process optimization.

Microsoft SQL ServerSQL DatabaseDatabasesSQL InjectionSQL Server Management StudioMSSQL+28

Eclinicalworks

Database Developer

Feb 2018 – Jul 2022 · 4 yrs 5 mos

Proficient in SQL Server and T- SQL in constructing Tables, Normalization/ Denormalization Techniques.
Implemented new features like row and page compression mechanism & data compression.
Installed, configured, and maintained SQL server.
Scheduled jobs for backup & index stats maintenance.
Experienced in Creating and Updating Clustered and Non-Clustered Indexes.
Tuned SQL/T-SQL queries, procedures, functions, and triggers for better performance.
Created automated jobs to populate DB for volume testing.
Found security issues like SQL injection and provided a fix.
Resolved blocking/deadlock issues.
Implemented the best way to handle DB connection leaks.
Makes recommendations towards the development team for new code.
Provided technical advice to dev, build and release team and assists in solving programming problems.
Worked closely with the build and release team & assisted them in troubleshooting database issues.
Participated in database management system selection and maintained DB performance.
Altered database object structure for better performance and to reduce the size.
Compared DB schema objects. Systematic analysis of the database to reduce size.
Found slow queries using DMVs and fixed them by doing query optimization.
Analyzed execution plan & taking corrective action from it.
Did RCA of DB related issues and provided corrective actions/suggestions.
Worked in agile methodology. Participated in daily scrum meetings.
Configured SSMS profiler to store real-time data of expensive queries and analyze them.
Identified gaps in upgrade processes and implemented improvements to increase efficiency, performance, and accuracy.
Monitored live client-server. Managed many client escalations by resolving their critical performance issue at their end. I was the go-to person for any DB related performance issues.