Experience

Buyrite Group

• United Kingdom
• Import & Export
• 1 - 100 Employee

• Senior Database Developer

  • Jun 2018 - Present

  Create and manage SQL server instances to ensure optimal availability to the client. SQL server performance tuning and optimization. SQL development to create advanced processes which contains database automation. Managing ETL processes for raw data processing. SSIS package development as per requirements and making amendments. Fixing job failures due to system / data / any other issues. Daily interactions with internal team members in case of any red flag issue and resolve them without effecting the end user. Managing Disaster recovery and high availability solutions to ensure data security and integrity. Analyzing the architecture of database systems and providing optimal solution to the client if necessary. Refine and automate regular processes, track issues and document any changes made. Azure SQL DB handling and Azure SQL VM maintenance for SQL Server On-Premise to Azure migration. Complex SSIS packages development using various types of sources.

• Database Developer

  • Feb 2015 - May 2018

  Handling SQL server performance related issues. Working closely with dynamic management views and creating advanced queries which are helpful in identifying the issue. Optimizing queries, making amendments in procedure or queries using execution plans. Detailed examination of execution plans to narrow down the bad query, tables or indexes which may cause the performance issues. Creating index maintenance jobs using maintenance plans or stored procedures, which uses dynamic query to fetch the fragmented indexes. Setting up the SQL profiler to get the trace when required, also configuring extended events according to the requirement. Configuring HADR solutions, SQL server Always On configuration and maintenance. Maintaining database integrity, reliability, and performance. Installation, configuration, upgradation of MSSQL database. Performance Tuning of the database according to the business standards.