Professional Summary
Over six years of professional experience in Database Administration, Database Design, Development and Support of MS SQL Servers 2012, 2014, 2016, 2017 and 2019 in Production, QA and Development environments. Hands-on experience in Microsoft SQL Server Database Installation, Configuration, Administration, Maintenance and Performance Tuning, in SQL server 2012, 2014, 2016, 2017 and 2019. Hands-on experience implementing SQL server high availability tools like Log shipping and Clustering MS SQL Server Performance Tuning, Query Optimization, Client/Server Connectivity, Data Transformation Services and running Database Consistency Checks Using DBCC. Expertise in implementing different types of high availability and disaster recovery mechanism like replication models, log shipping, database mirroring and clustering. Experience in implementing SQL Server Security and object permission like maintaining creation of logins & users, configuring permissions database authentication modes, and assigning roles of users. Worked on SQL Server 2016 migration from SQL Server 2014/2012 Worked on Creating Packages, Jobs and Sending Alerts using SQL Mail and DB Mail. Experienced in Data movement from Excel, Access, Flat file, Oracle to MS SQL Server by using BCP, SSIS and DTS utility. Created Linked Servers between SQL Server 2012 & 2014, also created DTS package for data transfer between the two environments. Experienced in Configuring Reporting services, developing and publishing reports using Microsoft Power BI and SSRS. Experienced in replicating data using Transactional replication, Merge and Snapshot. Expertness in trouble shooting database issues like space issues, deadlocks, performance and blocking. Having hands on experience migrating scripts in a production environment and extensive experience in creating and modifying stored procedures, triggers, views, cursors, and functions to meet business requirements. Hands-on experience on SQL Server TDE Encryption & Decryption. Experienced in allocating system storage & planning future storage requirements for the database system. Hands on experience on SSIS package development, deployment, and scheduling. Experienced in preparing and deploying Transact-SQL (TSQL) and PowerShell scripts. Having hands-on experience in Created Azure SQL database, Azure Synapse, Azure develops, performed monitoring and restoring of Azure SQL database. Performed migration of Microsoft SQL server to Azure SQL database. Extensive knowledge of Relational Database Management Systems, industry standards and agile best practices. Excellent analytical, Interpersonal and Communications skills, fast learner, hardworking and good team player. Worked on 24/7 production database on-call support. Multi-talented Database Administrator with 6 years of expertise in designing, testing and coding database solutions in various environments. Motivated self-starter consistently meets deadlines and succeeds in high-pressure environments.