• Performed database migration of Sql server databases to Azure SQL DB and Azure Sql Managed instances.• Deployed SQL Server in an Azure Virtual Machine (VM) to migrate an existing on-premises SQL Server into the cloud.• Managed servers and database level security by implementing Authentication, Authorization and Auditing. • Employes general SQL, T-SQL, stored procedures and SQL Server Integration Services (SSIS) to manage database systems and to automate data migration and processing.• Designs, develops and implements database tables, views, indexes, triggers, and stored procedures to ensure data integrity for custom applications.• Experience in implementing high availability and disaster recovery strategies such as log shipping, failover cluster and Always on Availability groups.• Extensively worked on troubleshooting and fine tuning of databases for optimal performance.• Worked with Performance Tuning/Query Tuning, execution plans, trace flags and Extended events.• Implemented Sql Server patching to reduce server issues, optimizing applications and features, and improving efficiency.• Manage Sql Server database logins, users and roles and involved in Daily User maintenance.• Monitor database growth activities and Troubleshoot Transaction log issues.

• Designed and developed SSIS packages to extract data from SQL Server.• Created ETL processes using SSIS packages to load data into Excel & Flat files from SQL Server.• Solved complex data transformation issues using T-SQL code in SQL server management studio (SSMS) and SSIS packages.• Created Batch script processes to automate SSIS packages.• Involved in loading data (Flat file source) to oracle cloud.• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS).• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML triggers to facilitate efficient data manipulation and data consistency.• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.• Trained on creating reports from oracle cloud using oracle cloud report service.• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins.

• Involved in designing, developing and implementing application database code objects, such as stored procedures, user-defined functions, views and triggers.• Built and maintained SQL scripts and complex queries for data analysis, reporting and data extraction.• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database.• Used SSIS to develop jobs for extracting, cleaning, transforming and loading data from sources like excel/Flat file into data warehouse.• Perform quality assurance and testing of SQL server environment.• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS).• Responsible for extracting, transforming and loading (ETL) 5010 and 837 Inbound files in the proprietary software (EZCAP), reviewing errors received and correcting them using third-party tool (Bowman by BitInc).• Assisted in testing for 837 inbound/outbound as well as 999 and 277 inbound transactions.

• Design and maintain Sql scripts.• Created and optimized diverse SQL scripts.• Extracted and collected data to create needed reports.• Generate reports and spreadsheets detailing database changes and performances.