V S Ajithkumar Email & Phone Number

Chennai, Tn, In

Chennai, Tamil Nadu, India

● Migrated 1500+ tables from on-premise DB2 database to Azure SQL MI using Azure data factory and SSMA ● Created multiple pipelines in ADF for Data migration.● Create automated pipelines for data migration in ADF using ADF triggers.● To increase performance, automate dropping the index before data migration and create the index after data migration in ADF pipelines.● Created data flows in ADF from multiple tables to a single table.● Ability to work on Azure data lake storage and Azure Databricks.● Created Tables, Views, Constraints, Materialized views, and join.● Created database objects like procedures, functions, and DML triggers according to the requirement.

Chennai, Tamil Nadu, India

• Working on SSMA and ADF tools to migrate data from DB2 to Azure.• Create Azure Data Factory pipelines for data migration and scheduled data load.• Working on query tuning using Index.• Change DB2 queries to Azure SQL query using SSMA.• Create DML triggers to capture the insert, update and delete operation in tables.• Create Stored procedure for Index Maintenance, Reorg, and Rebuild • Working on the stored procedure to find the issue if raised.

Chennai, Tamil Nadu, India

● Working on Application maintenance system.● Working on configuration changes as per the request.● Working on SQL servers to fetch data.● Responsible for designing advanced SQL queries, procedures, and functions.● Created Scripts to fetch data Reports based on requirements.● Create joins to filter data from two or more tables.● Involved in updating procedures, functions, triggers, and packages based on the change request.

Chennai, Tamil Nadu, India

• Analysis of client requirements based on the service provided.• Health Checking of Live Server and monitoring respective Applications.• Troubleshooting applications that are down.• Escalating all revenue-related issues and coordinating with the business operation team.• Maintaining and keeping track of all issues using Atlassian JIRA.• Responsible for designing advanced SQL queries, procedures, functions, triggers, and cursor.• Created indexes on the table for faster retrieval of data to enhance database performance.• Tracking revenue on an hourly basis and reporting to respective managers.