Working as Sr SQL Server DBA at the client CIT Group.Contributions Include:• Installing, Configuring and Managing Production, Staging and Dev environment SQL Servers.• SQL Server DB Monitoring and troubleshooting alerts• Working on AWS Cloud hosted SQL Servers and SQL Azure Migration.• Using AWS RDS, Aurora, S3, DynamoDB, ElastiCache and Redshift.• As a L3 Onsite DBA will be point of contact for all the escalated issues.• High availability and recoverability of databases in 24/7 environment by using Windows Clustering, Always ON Availability, Replication, DB Mirroring, Log Shipping, Backup and Restore to meet RTO/RPO objectives.• Strong command of Performance tuning and proven experience in troubleshooting performance problems using Index Optimization, Query Plan analyzing, Profiler, DMV and Server Configuration settings, TSQL programming and debugging skills for Query Optimization.• Managing and Configuring Backup and Recovery strategies for Databases.• SQL Developer, SSIS packages and SSRS reports building and deployment.• Participate in process and service improvements withing the database management function to improve the overall process performance.• Involved in the DR testing.• Maintaining the SQL Server monitoring using the PowerShell scripts to collect the performance related, DDL related and deadlock related events.• Designing and Developing QlikView documents, Experience in Power shell scripting for Automation, Python scripting and Power BI development.• Working in ITIL service modules(incident, Change, Problem and Release Management) using Service Now tool.

Was a Sr SQL Server DBA handling the USLBM project. As part of the profile below were my contributions. Contributions Include:• Perform Migration of SQL Server from 2005 to SQL Server 2014 version.• SSIS package creation for extracting the data from the legacy system on ProgressDB to SQL Server.• Developing SSRS reports to cater to the reporting needs of finance, accounts and sales teams.• Troubleshooting database performance issues to improve the SQL Server response time.• Working with different teams to gather the requirements related to reports and data needs.• Maintain the Database backups by developing a strategy to support any disaster situation that might occur.• Involved in migration of legacy data from other ERP systems in to Catalyst ERP system.• Designing and developing Qlikview Dcouments. • Providing the data feeds to the Salesi finance application tool.• Monitor the database and disk usage and ensure the usage is under check • Develop the DR strategy for the Database server recovery• Move the existing Reporting server jobs and build the new ones appropriately• Working on Cyber Query scripts to eliminate old DTS packages.• Working on other tasks that would improve the server availability at all times in future.• Performed Health checks on all the servers and rectified the database and server settings as per standard SQL server recommendations.

Worked as a Sr SQL Server DBA for the client RamQuest Inc handling the legacy T SQL scripts for performance optimization. Working on Execution plans to fine tune the SQL Scripts. Worked on other general DBA activities as well. Contributions Include:• Optimizing the T SQL Scripts for improved performance.• SQL Server Installations• Working with Developers in Enhancing the Stored Procedures.• Analyzing the Execution plans and based on it update the Indexes of the tables.• Using Database Engine Tuning Advisor to Optimize the T-SQL.• Modifying the Stored procedures as required.• Configuring the backup strategy.• Configuring the Security.• Analyzing the Data Models using Toad Data Modeler for better Database design and performance.• Monitoring SQL Server Performance using SQL Profiler, Perfmon counters and Index tuning.

Installation/Migration of SQL Server 2000, 2005, 2008 and 2012, Configuring server options, Creating and managing Database for SQL Server.Automating SQL Server Administrative tasks using SQL Server Agents by creating Jobs and Alerts.Worked on capacity planning and database sizing.Configuring and designing ReplicationDesigning and Configuring Log shippingConfiguring and designing Database Mirroring.Developing Maintenance PlansBacking and Restoring of DatabasesMonitoring SQL Server Performance and ActivityManaging and Configuring SQL Servers as Linked servers, Remote Server.Tuning Databases for performanceAdministering SQL Server using Graphical Administration tools which includes SQL Server Enterprise Manager, SQL Server Query Analyzer, Performance Monitors, SQL Server Profiler Server Service ManagerSQL Server Cluster installations and troubleshooting.

Worked as a Lead of a Microsoft Project. Was involved in successful Transitioning of the project. Lead a team of 20 members and the number of servers supported were 2500 which catered to different business units of the client.

Was the first member of the SQL Server team from the Offshore, India and took the KT from the onsite team and handled the support from offshore independently and successfully. As a Sr SQL Server DBA, was handling 30 applications individually for 2 years and later was involved in building the team and increasing the scope of work. Overall I was with ADP fpr 2 years 11 months.Earlier I started my career with Wipro Technologies as a SQL Server DBA, Production Support Analyst for Microsoft client. Supported the Client applications successfully. I was with Wipro for 2 years and 10 months.

Earlier I started my career with Wipro Technologies as a SQL Server DBA, Production Support Analyst for Microsoft client. Supported the Client applications successfully. I was with Wipro for 2 years and 10 months.