Dhirendra Kumar

 Overall 14 years of experience as an IT professional and 10 years’ experience in SQL or PL/SQL developer and Database Administration in L1 and L2 Support environments.
 Extensive experience in SQL development, relational databases (Oracle) and data distribution techniques.
 Experience data modelling, normalization and query performance tuning.
 Experience in maintenance database and troubleshooting.
 Experience in Job monitoring on production and check and do the analysis of any blocking and failure.
 Experience with troubleshooting database issue, performance issue and blocking issue.
 Developed database management applications on the Linux platform.
 Proficiency in improve performance tuning using execution plan, database tuning advisor and database profiler.
 Proficiency in monitor Production job using the tool RedGate and Datadog.
 Experience in creating login and users in the SQL Server environment and granting permission to users and logins.
 Daily activities include monitoring databases, checking error logs, event logs, checking the log file size and free space in data drives, connectivity off the databases.
 Validate and verify the service status and database connectivity after patching the SQL Server. Also doing the health check of DB.
 3 years’ experience in ETL tool (SSIS, Informatica) with SQL SERVER.
 Experience in SQL Server developer (DDL, DML, DCL, Joins, functions, Stored Procedure, Index, Complex query, Cursor, Performance tuning approach using SQL Query and more).
 Good understanding of Asset management/Capital Market/Investment Management domain and financial instruments & Securities.
 Experience in working on Agile Model (Using SCRUM) and DevOps, Jira
 Exposure of working on Development, Migration, Enhancement, Hand-Over, Production support (maintenance), Take-Over projects.