Arkajit D.

DATABASE DEVELOPER

122 euro
Freelancer
4 ans
Kolkata, INDIA

Mon expérience

Voir plus

ProcentrisJuly 2018 - Présent

Responsibilities:

* Decreased monthly server log error rates to an all-time low (0.14%).

* Extensively worked on the tuning of SQL query, batch jobs, optimizing the batch process as well as tuning various complex and time-consuming queries.

* Real-time monitored 6 Live Server with 32 different Agencies using SQL Sentry.

* Ensured client satisfaction level at its best by providing accurate and concise resolution and showing a high level of expertise from the technical aspect.

* Handled over 65 different types of invoices, E-Billing reports more than 1000 ad-hoc and standard report formats in SSRS.

* Identified and Worked with Parameters, Multi-Value Parameters for Parameterized reports in SSRS.

* Worked on various T-SQL queries, complex stored procedures, user-defined functions, triggers huge datasets optimization in SQL.

* Handled different replications -a snapshot, merge and transactional.

* Worked with the QA team on various data related assignments and observations.

* Provided client ad-hoc queries as per requirement. Worked with clients and provided resolution via FogBugz project management and issue tracking software.

* Worked on version controlling using Team foundation server(TFS) and maintained hierarchical

structure for the same.
Analyst

Mes compétences

SQL Server Reporting Services, SQL Developer, SQL, Microsoft SQL Server, Database and SQL tuning