· Responsible for converting all ORACLE scripts into MS SQL SERVER scripts.

· Responsible for creating DB backup and DB Model for all the objects.

· Performance Tuning the converted stored procedures to improve the performance.

· Updating the commits through VSTS by creating Pull request and adding reviewers.

· Create new reports based on the requirement which are dependent on Financial calculations.

· Performance Tuning the existing reports to improve the performance.

· Performing the changes on the Production/Dev servers as per the requirement from users.

· Updating the commits through VSTS by creating Pull request and adding reviewers.

· Uploading huge data into Production environment monthly and weekly processing.

· Managing Flat files data into production database using SSIS packages.

· Preparing excel reports on the current data every month.

· Performing the changes on the Production/Dev servers as per the requirement from users.

· Scheduling of maintenance Jobs (Daily, Weekly, Monthly) as per the client request.

· Followed AGILE development Methodology to ensure teamwork, collaboration and process adaptability throughout the life-cycle of project.

· Created Tables, Views, Indexes, User Defined Functions and SSIS packages on SQL Server 2012 and BIDS 2008.

· Used SSRS reports for Reporting part of application.

· Designed the database and involved in writing and maintaining complex SQL Queries and required Stored Procedures and Triggers

· Using tools such as SQL profiler, performance monitor and database tuning wizard to identify the performance bottlenecks.

· Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.

· Develop, implement and administer database policies and procedures and provide technical support and assistance to all database end-users.